/build/static/layout/Breadcrumb_cap_w.png

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:
Posted by: Hobbsy 9 years ago
Red Belt
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
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ