Report - Devices that run a specific process (4264820)

This custom SQL report that allows you to determine which machines are running specific process.

NOTE: All SQL code provided as a courtesy by KACE to its customers. We make no promises as to workability or functionality under certain circumstances. In default situations under normal setup these work as designed. KACE does not support modification nor usage.

• KACE highly recommend to test all code no matter the source before using in a production environment.
• If using Copy/Paste,  paste ithe code into a text editor then copy back out to remove any hidden characters or markup.

This SQL script  reports only process running on devices at inventory time.
It is not recommended  to decrease the inventory frequency in order to increase the accuracy.
Please use Metering for such purpose.

1. Click Reporting | Reports.

2. Click Choose Actions - New(SQL).

3. Enter Title Category and Description.

4. In the SQL field, enter the following script:

********** BEGIN SQL CODE ***********
select
M.NAME,
M.IP,
P.NAME,
P.FILE_VERSION
from PROCESS P
JOIN MACHINE_PROCESS_JT MPJT
ON P.ID=MPJT.PROCESS_ID
JOIN MACHINE M
ON M.ID=MPJT.MACHINE_ID
WHERE P.NAME rlike 'process_name'
********** END SQL CODE ***********

Replace  process_name  to actual process name (e.g. notepad )

5. Save the report.