I have an issue with the reporting feature (using the wizard) in KACE.  I am trying to run a report to tell me how many machines have Framework 4 installed on them.  I know I can look and see which ones have them installed under the software tab, but the problem is not just singled out to this one report.  In this instance, I created the report and added a rule to filter only machines that have the Display Name Microsoft .NET Framework 4.  I have close to 600 machines and the report only returns 3 that have Framework 4 installed.  I know that I have installed it on over 500+ computers and verified this.  Anyone else have issues with the wizard?

I am not a SQL guy, but can I get better results writing a SQL code for this report?

Thank you.

Answer Summary:
SELECT M.NAME, S.DISPLAY_NAME, S.DISPLAY_VERSION FROM MACHINE M, MACHINE_SOFTWARE_JT MS, SOFTWARE S WHERE M.ID = MS.MACHINE_ID AND MS.SOFTWARE_ID = S.ID AND S.DISPLAY_NAME LIKE '%FRAMEWORK 4%' -- ADJUST CRITERIA HERE AND S.IS_PATCH = 0 ORDER BY M.NAME, S.DISPLAY_NAME
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2

I think this will at least get you going in the right direction.

 

SELECT M.NAME,

S.DISPLAY_NAME,

  S.DISPLAY_VERSION

 FROM MACHINE M,

MACHINE_SOFTWARE_JT MS,

SOFTWARE S

WHERE M.ID = MS.MACHINE_ID

  AND MS.SOFTWARE_ID = S.ID

  AND S.DISPLAY_NAME LIKE '%FRAMEWORK 4%' -- ADJUST CRITERIA HERE

  AND S.IS_PATCH = 0

ORDER BY M.NAME, S.DISPLAY_NAME
Answered 04/27/2012 by: dchristian
Red Belt

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