Forum Discussion

Athique_Ahmed's avatar
Athique_Ahmed
7 years ago

SQL Results Table Display

Hi, LogicMonitor beginner here! I have a sql statement which outputs outstanding orders currently in the system and what date they are outstanding from. It may show as follows... 1...
Mike_Suding's avatar
Mike_Suding
Former Employee
7 years ago

@Athique Ahmed, I'm seriously considering making a DataSource that runs any SQL query and shows the resulting table in a 'text' dashboard widget (in HTML).  Would that help you? Currently the text widget is limited to 65,535 characters so it would be ~10 columns wide by 200 rows (depending on how much is in each 'cell')

But, in general, @Mike Moniz is correct in that LM is mostly designed to retrieving a single number every X minutes and graphing that over time.  LM config could run a SQL query and get the results but there's no dashboard widget to show the resulting config.