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