/build/static/layout/Breadcrumb_cap_w.png

Report Request: I need an inventory count by OS and System Build.

My manage wants to a monthly report on how many systems XYZ, OS build and the computer name. 

Here's the layout that I'm looking for.

Computer Name      OS Name       OS Build    Last inventory. 

I don't know any SQL to create this report. 

If anybody has any ideas, it's appreciated and Thank you,

0 Comments   [ + ] Show comments

Answers (2)

Posted by: KevinG 2 years ago
10th Degree Black Belt
1
Here is a select statement that contains most if not all of the OS related columns from the MACHINE table. Plus the last inventory date.
If there are columns you do not care to include in the output, just remove the column name.

select NAME, IP, OS_NAME, OS_NUMBER, OS_MAJOR, OS_MINOR, OS_MINOR2, SERVICE_PACK, OS_VERSION, OS_BUILD, OS_INSTALLED_DATE, OS_FAMILY, OS_ARCH, LAST_INVENTORY from MACHINE;
Posted by: Nico_K 2 years ago
Red Belt
1
this report can be done with the wizard without any SQL knowledge.
Simply create a new one and grab the nessesary fields etc. Just follow the wizard.
 
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