/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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