NeophyteSQL Server Global Performance --> MSSQLSERVER: Raw Data: No Data
Also, SQL Server Databases --> MSSQLSERVER - Databases are discovered but not all data is picked up in Raw Data tab- there is still No Data for some columns.
Seems like all the permissions are correct. Checked all the configurations.
NeophyteI run the !groovy from the Collector Debug- selected the device and received multiple errors. Can you please check the screenshot?
NeophyteI run !groovy and then paste the collection script below. I attach screenshot of the output.
MastermindOk, it returns 0 which means the script is exiting and saying that it's successful, but there's no output. Without any output, that's why you're not getting any data. As to why there's no output, you'll have to go into script debug mode. That's not something I can easily help you with through a forum.
What has support said?
NeophyteLM Support requires me to share the resource name from LogicMonitor. I can't share it it's part of MSP Policies. I am not sure how to go from there.
NeophyteI think I am in the right place now. I attach the screenshot. Referring to your previous answer: do I copy the whole script and run it in Debug or just a part of the script? Also, which script from the image is it?
MastermindWell, you're having problems collecting, so it would be the collection script (the bottom one). Yes, it would be the entire script after executing the !groovy command to bring up the script executor. Pick the target device and run the script.
NeophytePoll Now shows:
NaN
param not found in output - (method=namevalue, param=MSSQLSERVER.ActiveTempTables)
Can you explain where do I get the collection script in order to run it in debug?
The picture attached shows where currently I finished the steps you mentioned.
MastermindDown below that it should have some more output. I don't know if your module is scripted or not, but if you click "Edit Global Definition" after closing out the poll now dialog box, it'll take you to the module definition. That will show if it's scripted and what the collection script is.
MastermindWhat did LM support say?
NeophyteI am still waiting for LM Support response.
In the meantime, what would be a good way to troubleshoot this issue?
MastermindIs it scripted? If so, check what poll now shows for the script output. Then put the collection script into the collector debug and see what the output looks like.
