AnsweredAssumed Answered

Silly Question regarding output of EVNT.DB

Question asked by Wolfgang_Brueckler_1288 on Feb 19, 2018
Latest reply on Feb 20, 2018 by Wolfgang_Brueckler_1288
Hi All

this time I have a very silly question - but at the moment I do not have a clue how to proceed.

Just for fun (and admin purposes) I want to experiment with another method checking if some agents are up or down.
(Yes I know most other ways - I want to stick on my method - just for education purposes)

I have 2 SQL statements - one that returns a list of all existing agents - the other one returns a list of rinning agents.

The difference of both would be a list of inactive agents.

Traying to do this with an EVENT.DB its successfully triggering the !SCRIPT.

But here is my problem: How do I get the agent list - or outcome of my both SQLs?
Yeah - I could use 2 SQL jobs (again) or process 2 SQLI VARAs (again) but this would be double of the effort - a bit useless doing it twice....


Do you have any (good) hints how to get the outcome (SQL difference) of my EVNT.DB out of !SCRIPT?

THX a lot & cheers