CODE WRITTEN BY QUEST KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY AND NOT SUPPORTED BY KACE TECHNICAL SUPPORT. CLIENT CONFIRMS THE NEED FOR TESTING AND ACCEPTS ALL RESPONSIBILITY FOR USE AND MISUSE OF CODE. QUEST KACE SHALL NOT BE HELD LIABLE FOR DAMAGE OR DOWN TIME RESULTING FROM USE OF THIS OR ANY CODE PRESENTED FOR PURPOSES OF TROUBLESHOOTING OR DEMONSTRATION
Click Reporting > Select Action > Add New Report (SQL).
Enter your report Title, Category, and Description fields and add the following SQL:
select S.DISPLAY_NAME as SOFTWARE_NAME, S.DISPLAY_VERSION as VERSION, M. NAME as MACHINE_NAME, M.USER_FULLNAME as LAST_USER from SOFTWARE S left join MACHINE_SOFTWARE_JT MSJ ON S.ID = MSJ.SOFTWARE_ID left join MACHINE M ON MSJ.MACHINE_ID = M.ID where S.DISPLAY_NAME like 'Windows Internet Explorer 8%' and not IS_PATCH and NOT M.NAME like '' order by S.DISPLAY_NAME , S.DISPLAY_VERSION , M. NAME |
*NOTE - The above report is for Internet Explorer 8 you would need to change the line that reads S.DISPLAY_NAME like 'Windows Internet Explorer 8%' for other software packages.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center