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,
Please log in to answer
Posted by: KevinG 2 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.
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