/build/static/layout/Breadcrumb_cap_w.png
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

Comments


All Answers

0
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;
Answered 10/13/2018 by: KevinG
Second Degree Blue Belt

0
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.
Answered 10/05/2018 by: Nico_K
Red Belt