Creating a report that shows Computer Name, Domain, OS version and Service Pack version
search cancel

Creating a report that shows Computer Name, Domain, OS version and Service Pack version

book

Article ID: 181022

calendar_today

Updated On: 01-28-2025

Products

IT Management Suite

Issue/Introduction

How can I create a report that contains domain, managed computers, OS, and service pack?

Environment

ITMS 7.x, 8.x

Resolution

The following query will return the computer Name, OS Name, OS Revision, and Domain for Windows 11 or Windows 2019 servers as example.  This query will need to be modified for you specific needs and is run against the Symantec_CMDB database.


------------------------------BEGIN QUERY SAMPLE ---------------------------------------

Select vc.Name, vc.[OS Name],ident.[OS Revision],vc.[Domain]
from Inv_AeX_AC_Identification ident
join vcomputer vc on vc.guid = ident._ResourceGuid
where vc.IsManaged = 1
AND vc.Name LIKE '%'
AND (vc.Domain LIKE '%' OR vc.Domain LIKE '%')
AND (vc.[OS Name] LIKE '%Windows 11%' OR vc.[OS Name] Like '%Server 2019%')
ORDER BY vc.[OS Name] ASC 

 

------------------------------END QUERY SAMPLE --------------------------