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,
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
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Attached is a sample report I have. Is that similar to what you are looking for?

Attachment

Answered 12/06/2011 by: scottlutz
Orange Senior Belt

Please log in to comment
5
Maybe this report will help.

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
Answered 12/14/2011 by: dchristian
Red Belt

  • This is awesome! Thank you
Please log in to comment
0
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.
Answered 02/29/2012 by: Mariusja
Second Degree Green Belt

Please log in to comment
0
You can add this right above the order by:
WHERE DISPLAY_NAME = 'Your software here'
Answered 03/01/2012 by: dchristian
Red Belt

Please log in to comment
0
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)
Answered 03/14/2012 by: nbs
Orange Belt

Please log in to comment
0
nbs,

Can you post your SQL here, and I can test it out?
Answered 03/15/2012 by: scottlutz
Orange Senior Belt

Please log in to comment
0

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.

Answered 04/30/2013 by: thewuzzles
Orange Belt

Please log in to comment
Answer this question or Comment on this question for clarity