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.
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.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center