This SQL query was developed without any prompts to report, count and display all of the Network Operating Systems (NOS) installed including any Service Pack (SP) that may be installed.
Note: To use the SQL script as a Report copy and paste the Name, Category, Comment and of course the SQL statement shown below to the appropriate new Report boxes or modify to your liking as needed.
Name: Count Network Operating Systems (NOS)
Category: Operating System
Comment: This Report Without Prompts Will Count And Display All The Network Operating Systems (NOS) Installed Including Any Service Packs.
Caption0 as 'Network Operating System (NOS)',
'Service Pack' = Case
When CSDVersion0 Is Null Then ''
Group By Caption0, CSDVersion0
Order By 'Count'