K1000 report for startup processes
Hello, I was just wondering how to create a report that will check for a specific startup process that's running and send en email out.
4 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
11 years ago
It doesn't look like the report wizard includes the ability to filter on startup processes, which is unfortunate. This would have to be created using a SQL report. Do you have experience writing SQL? If not, then post the process that you are looking for and I can create a report that will identify machines with that process.
SELECT
S.*,
MSJ.MACHINE_ID,
M.NAME as MACHINE_NAME,
M.USER_FULLNAME as LAST_USER
FROM
STARTUPPROGRAM S
LEFT JOIN
MACHINE_STARTUPPROGRAM_JT MSJ ON S.ID = MSJ.STARTUPPROGRAM_ID
left join
MACHINE M ON MSJ.MACHINE_ID = M.ID
WHERE
S.NAME LIKE '%cry%' OR
S.NAME LIKE '%xirdabfigquf%' OR
S.NAME LIKE '%7mq46vq7sw%' OR
S.NAME LIKE '%AdFNyehJMxJUC%' OR
S.NAME LIKE '%fiksaqviqfux%' OR
S.NAME LIKE '%hiclynkirsah%' OR
S.NAME LIKE '%pesyvazqonyr%' OR
S.NAME LIKE '%qybkyqracinr%' OR
S.NAME LIKE '%xirdabfigquf%' OR
S.NAME LIKE '%retvcqjm%' OR
S.NAME LIKE '%rrvuyuap%' - mnutbrown 11 years ago