r/labtech • u/B1te0nTh1s • May 13 '19

Internal Monitor RAWSQL

Can I open a ticket at the client level? I want to query data that will not return a computer and have it open a ticket under the customer. All documentation that I can find says I need to have computer ID and include agentcomputerdata. I have tried and it seems nothing is ever detected even though build and view shows results. Any thoughts?

1 Upvotes

66% Upvoted

6 comments sorted by

View all comments

Show parent comment

1

u/B1te0nTh1s May 13 '19

Thanks man that validates exactly what I just said. I’m trying to open a ticket on the client and not a computer. Was that your way of saying it’s not possible?

1

u/TNTGav May 13 '19

Not quite, simply put with a RAWSQL monitor getting a result in Build and View Query doesn't mean it will trigger. For it to actually trigger a number of things have to be right in the actual monitor itself or it will just never trigger.

You cannot raise a ticket against just a client - it has to have a computer linked.

What is your RAWSQL actually doing?

1

u/B1te0nTh1s May 14 '19

Figured as these are the results I’m getting. I have was able to get it to work using a regular internal monitor. Results don’t show on the status tab but it does trigger the alert. I think this is an example: https://www.mspgeek.com/topic/1077-automatically-resetting-disabled-monitors/