/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


How can I create a query to list all devices running a process

05/24/2016 864 views
Hi

How can I create a query to look for processes and display the list of computers having the process running?

For querying software catalog, I found this query which I customize for my uses:

SELECT SC.NAME AS SOFTWARE_NAME, M.NAME as MACHINE_NAME, M.LAST_USER as LASTUSER

FROM SAM_MACHINE_JT  JOIN CATALOG.SAM_CATALOG SC ON SC.ID = SAM_MACHINE_JT.SAM_CATALOG_ID
JOIN SAM_COUNT ON SAM_COUNT.SAM_CATALOG_ID = SC.ID
LEFT JOIN SAM_METER_DATA SMD ON SMD.MACHINE_ID = SAM_MACHINE_JT.MACHINE_ID
AND SMD.TITLED_APPLICATION_ID = SC.ID
LEFT JOIN SAM_METER_TITLED_APPLICATION SMTA ON SMTA.TITLED_APPLICATION_ID = SC.ID 
LEFT JOIN SAM_NOT_ALLOWED SNA ON SNA.TITLED_APPLICATION_ID = SC.ID
LEFT JOIN MACHINE M ON M.ID = SAM_MACHINE_JT.MACHINE_ID
LEFT JOIN KBSYS.SAM_TITLE_REQUEST STR ON STR.SAM_APPLICATION_FILE_ID = SC.ID
LEFT JOIN USER U on REPLACE(M.USER_LOGGED,'DOMAIN\\','') = U.USER_NAME

WHERE (SC.SAM_TYPE IN ('TITLED_APPLICATION', 'TITLED_SUITE') AND (SC.SOFTWARE_CATEGORY_ID <> 32)) AND SC.NAME like 'SQL Server%'


How can I modify the above to query against Processes instead of Software Catalog as the above is doing?  I would like to be able to join the data with the computer name and the last known user.

Thank you.



0 Comments   [ + ] Show comments

Comments


All Answers

2
Use the wizard!  here is one that looks for winvnc.exe to be running on the machine






Answered 05/24/2016 by: SMal.tmcc
Red Belt

Don't be a Stranger!

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

Sign up! or login

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