/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide Comments

Comments

Please log in to comment

Community Chosen Answer


Answers

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.
Answer this question or Comment on this question for clarity

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