Report Request
Hi Everyone
We are looking for a Software Inventory report that lists particaular software installed on PC, PC name and user name in K1000.Are there any recommendations for this report?
Many Thanks
Good afternoon everyone Our director is looking for a Help Desk report that shows tickets closed in the past 7 days, that were open for longer than 3 days Are there any recommendations for this report? Thank you
1 Comment
[ + ] Show comment
-
Sorry, Please ignore second request for help desk report or delete. - raxit.patel 9 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
Hobbsy
9 years ago
Try this, I created it quickly with the reports wizard:
SELECT MACHINE.NAME AS SYSTEM_NAME, USER_FULLNAME, (SELECT GROUP_CONCAT(DISTINCT SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.NAME ORDER BY SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.NAME separator '\n') FROM SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE WHERE MACHINE.ID = SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.MACHINE_ID) AS SAM_TITLE, (SELECT GROUP_CONCAT(DISTINCT SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.MAJOR_VERSION ORDER BY SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.MAJOR_VERSION separator '\n') FROM SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE WHERE MACHINE.ID = SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.MACHINE_ID) AS SAM_VERSION FROM MACHINE LEFT join SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE on MACHINE.ID=SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE.MACHINE_ID GROUP BY MACHINE.ID ORDER BY SYSTEM_NAME, USER_FULLNAME
