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)
Please log in to answer
Posted by:
KevinG
6 years ago
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.
Posted by:
Nico_K
6 years ago
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.
Simply create a new one and grab the nessesary fields etc. Just follow the wizard.
