Microsoft .NET Framework 4 - Reports not showing the full results
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.
Answers (1)
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
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
