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

Comments

Please log in to comment

Community Chosen Answer

1
[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]
Answered 12/08/2010 by: chrisgrim
Senior Purple Belt

  • 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?
Please log in to comment
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
thanks for the tips, but the computer names are not showing. The only thing that show are the process names.
Answered 12/08/2010 by: chipdisk
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity