Running Process Report / based on version.
I'm trying to run a report that list all the computers running a certain process. I created a label that groups all the processes to one label. The precess is listed 5x. All 5 processes are associated with one label. I would like to create a report that shows all the computers running these processes.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
chrisgrim
13 years ago
[left]Corey,[/left][left] [/left][left]Something like this ought to do the trick:[/left][left] [/left][left]select M.NAME, P.NAME
from PROCESS P
join PROCESS_LABEL_JT PJ on PJ.PROCESS_ID = P.ID
join LABEL PL on PL.ID = PJ.LABEL_ID and PL.NAME = 'your_label_name'
join MACHINE_PROCESS_JT MJ on MJ.PROCESS_ID = P.ID
join MACHINE M on MJ.MACHINE_ID = M.ID[/left]
from PROCESS P
join PROCESS_LABEL_JT PJ on PJ.PROCESS_ID = P.ID
join LABEL PL on PL.ID = PJ.LABEL_ID and PL.NAME = 'your_label_name'
join MACHINE_PROCESS_JT MJ on MJ.PROCESS_ID = P.ID
join MACHINE M on MJ.MACHINE_ID = M.ID[/left]
Comments:
-
Being the complete SQL scripting nub that I am, how do I make this show me every system not running a process with a certain label? - eXistinZ 11 years ago
Posted by:
chipdisk
13 years ago
thanks for the tips, but the computer names are not showing. The only thing that show are the process names.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.