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... 

18/11/2018 - 1
19/11/2018 - 3
20/11/2018 - 2

Depending on how many orders are currently outstanding, these results can of course change for example more dates can be listed and the table can get longer if there are outstanding orders from further back in the year.

My question is how best to display this data on the dashboard, is there a widget that can be used to display data like this?

Thanks!

  • Mike_Suding's avatar
    Mike_Suding
    Former Employee
    6 years ago

    The way I usually start troubleshooting is to try a direct query from the debug prompt like this example below:  (other examples documented here) 

    !jdbc url="jdbc:mysql://server2:3306;databaseName=whatever?user=mike&password=secret" select * from inventory

    where server2 is my server, database name is 'whatever', username is mike and password is secret and then my SQL query.

    This way I can see the errors directly and see if it's authentication or other things like permissions.