Question How can I create a report that contains domain, managed computers, OS, and service pack?
The following query will return the computer Name, OS Name, OS Revision, and Domain for Windows 2000 or Windows 2003 servers. This query will need to be modified for you specific needs and is run against the Altiris database.
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 2000%' OR vc.[OS Name] Like '%Server 2003%') ORDER BY vc.[OS Name] ASC