Query for Service Pack Query for Service Pack bgfs (TechnicalUser) (OP) 2 Dec 08 04:28 Hi can someone show be a query that will return all XP systems with Service Pack 1 together with their netbios name RE: Query for Service Pack SimonDavies (MIS) 2 Dec 08 11:07 I would have a look at something like this.select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM onSMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 5.1" and SMS_G_System_OPERATING_SYSTEM.CSDVersion = "Service Pack 1" SimonThe real world is not about exam scores, it's about ability. RE: Query for Service Pack bgfs (TechnicalUser) (OP) 4 Dec 08 03:43 Thanks for that. It returned what I was after perfectly and given me an idea of query construction. Thanks RE: Query for Service Pack McTech (TechnicalUser) 6 Feb 09 15:42 I was looking for a query to see how many I've already loaded XP SP3 - this did the job wonderfully. I think I shall give you a star.....Thanx bunches!