Managed Install Report
Hi there,
Is it possible to create a report on a Managed Install?
I need a report that will give me the date on when the managed install was created and then also the status(Installed,Not installed, Not installed(1 of 3 attemps) of the deployment.
thanks,
Is it possible to create a report on a Managed Install?
I need a report that will give me the date on when the managed install was created and then also the status(Installed,Not installed, Not installed(1 of 3 attemps) of the deployment.
thanks,
0 Comments
[ + ] Show comments
Answers (7)
Answer Summary:
SELECT DISTINCT Date_format(MI.CREATED, '%Y/%m/%d') AS CREATED_DATE, S.DISPLAY_NAME, S.DISPLAY_VERSION, CASE WHEN MS.MACHINE_ID > 0 THEN 'Installed' WHEN MIA.ATTEMPT_COUNT > 0 THEN Concat('Not Installed (', MIA.ATTEMPT_COUNT, ' of ', MI.MAX_ATTEMPT_COUNT, ' attempts)') ELSE 'Not Installed' END AS STATUS, M.NAME, M.IP, M.LAST_SYNC, M.USER_NAME FROM SOFTWARE S JOIN MI ON ( S.ID = MI.SOFTWARE_ID ) JOIN MI_LABEL_JT MIL ON ( MI.ID = MIL.MI_ID ) JOIN LABEL L ON ( MIL.LABEL_ID = L.ID ) JOIN MACHINE_LABEL_JT ML ON ( L.ID = ML.LABEL_ID ) JOIN MACHINE M ON ( ML.MACHINE_ID = M.ID ) JOIN SOFTWARE_OS_JT SO ON ( SO.SOFTWARE_ID = S.ID AND SO.OS_ID = M.OS_ID ) LEFT JOIN MACHINE_SOFTWARE_JT MS ON ( M.ID = MS.MACHINE_ID AND MS.SOFTWARE_ID = S.ID ) LEFT JOIN MI_ATTEMPT MIA ON ( MIA.MI_ID = MI.ID AND MIA.MACHINE_ID = M.ID ) ORDER BY S.DISPLAY_NAME, S.DISPLAY_VERSION, STATUS
SELECT DISTINCT Date_format(MI.CREATED, '%Y/%m/%d') AS CREATED_DATE, S.DISPLAY_NAME, S.DISPLAY_VERSION, CASE WHEN MS.MACHINE_ID > 0 THEN 'Installed' WHEN MIA.ATTEMPT_COUNT > 0 THEN Concat('Not Installed (', MIA.ATTEMPT_COUNT, ' of ', MI.MAX_ATTEMPT_COUNT, ' attempts)') ELSE 'Not Installed' END AS STATUS, M.NAME, M.IP, M.LAST_SYNC, M.USER_NAME FROM SOFTWARE S JOIN MI ON ( S.ID = MI.SOFTWARE_ID ) JOIN MI_LABEL_JT MIL ON ( MI.ID = MIL.MI_ID ) JOIN LABEL L ON ( MIL.LABEL_ID = L.ID ) JOIN MACHINE_LABEL_JT ML ON ( L.ID = ML.LABEL_ID ) JOIN MACHINE M ON ( ML.MACHINE_ID = M.ID ) JOIN SOFTWARE_OS_JT SO ON ( SO.SOFTWARE_ID = S.ID AND SO.OS_ID = M.OS_ID ) LEFT JOIN MACHINE_SOFTWARE_JT MS ON ( M.ID = MS.MACHINE_ID AND MS.SOFTWARE_ID = S.ID ) LEFT JOIN MI_ATTEMPT MIA ON ( MIA.MI_ID = MI.ID AND MIA.MACHINE_ID = M.ID ) ORDER BY S.DISPLAY_NAME, S.DISPLAY_VERSION, STATUS
Please log in to answer
Posted by:
dchristian
12 years ago
Maybe this report will help.
I usually add a break on DISPLAY_NAME, makes it look nice.
I usually add a break on DISPLAY_NAME, makes it look nice.
SELECT DISTINCT DATE_FORMAT(MI.CREATED,'%Y/%m/%d') as CREATED_DATE,
S.DISPLAY_NAME,
S.DISPLAY_VERSION,
CASE
WHEN MS.MACHINE_ID > 0 THEN 'Installed'
WHEN MIA.ATTEMPT_COUNT > 0 THEN CONCAT('Not Installed (',MIA.ATTEMPT_COUNT,' of ', MI.MAX_ATTEMPT_COUNT,' attempts)')
ELSE 'Not Installed'
END AS STATUS,
M.NAME,
M.IP,
M.LAST_SYNC,
M.USER_NAME
FROM SOFTWARE S
JOIN MI
ON ( S.ID = MI.SOFTWARE_ID )
JOIN MI_LABEL_JT MIL
ON ( MI.ID = MIL.MI_ID )
JOIN LABEL L
ON ( MIL.LABEL_ID = L.ID )
JOIN MACHINE_LABEL_JT ML
ON ( L.ID = ML.LABEL_ID )
JOIN MACHINE M
ON ( ML.MACHINE_ID = M.ID )
JOIN SOFTWARE_OS_JT SO
ON ( SO.SOFTWARE_ID = S.ID
AND SO.OS_ID = M.OS_ID )
LEFT JOIN MACHINE_SOFTWARE_JT MS
ON ( M.ID = MS.MACHINE_ID
AND MS.SOFTWARE_ID = S.ID )
LEFT JOIN MI_ATTEMPT MIA
ON ( MIA.MI_ID = MI.ID
AND MIA.MACHINE_ID = M.ID )
ORDER BY S.DISPLAY_NAME,
S.DISPLAY_VERSION,
STATUS
Comments:
-
This is awesome! Thank you - gambitz 11 years ago
Posted by:
thewuzzles
11 years ago
For auditing purposes, is there a way to add the "admin" who pushed these managed installs to the systems? I find these very useful but we have had a few issues recently on who pushed what to who's machine.
Posted by:
scottlutz
12 years ago
Attached is a sample report I have. Is that similar to what you are looking for?
Posted by:
Mariusja
12 years ago
This looks great. Can we select specific software to run this report against?
For instance if I deploy Adobe I want to run the report only for the Adobe deployment.
For instance if I deploy Adobe I want to run the report only for the Adobe deployment.
Posted by:
dchristian
12 years ago
You can add this right above the order by:
WHERE DISPLAY_NAME = 'Your software here'
Posted by:
nbs
12 years ago
Is there a minimum version of Kace this will run under? our appliance is at 5.2, for status the report is just showing "Blob" (running via mysql workbench tool)
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.