Report if specific proccesses are running or not
Hi everybody!
thanks in advance for dedicating some effort for this thing.
does anybody have an idea of how build a report like this (in k1000):
a column with system name and a column indicating if a specific process is running or not (then i'll add more column with the same logic of the second one).
i already asked to some AI but nothing really worked.
Cheers everybody
Thomas
Answers (2)
this can be done easily, but ...
... it is likely you cannot use the results effectively.
When a system checks in, all info is uploaded to the appliance (running processes etc)
Between the check ins no changes are reported.
M.NAME,
M.IP,
P.NAME,
from PROCESS P
JOIN MACHINE_PROCESS_JT MPJT
ON P.ID=MPJT.PROCESS_ID
JOIN MACHINE M
ON M.ID=MPJT.MACHINE_ID
WHERE P.NAME rlike 'AmpWatchdog.exe'
Hi Nico,
amost there! with that code i can see all devices running that process. i would like to see also devices that are not running that process and under the column having a result like (running - not running). I can guess it takes a sort of CASE but i couldn't be able to write a code working fine.
Thanks for your help
Comments:
-
you can change the report as you like. A smarter move may be using this report as smart label and create a report with machines not in the smart label.
But I cannot stress it enough: it is only a "snapshot" of the time the machine checked in. If the process failed after the check in until the next check in you will not see it. - Nico_K 2 days ago