/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: chrisgrim 14 years ago
Senior Purple Belt
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]

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 12 years ago
Posted by: chipdisk 14 years ago
Senior Yellow Belt
0
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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ