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

Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • Sorry, Please ignore second request for help desk report or delete.
Please log in to comment

Answers

0
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
Answered 02/06/2015 by: Hobbsy
Red Belt

Please log in to comment
This content is currently hidden from public view.
Reason: Removed by member request
For more information, visit our FAQ's.

Answer this question or Comment on this question for clarity