I applied patch Q811493 to W2k wkstns. Received duplicate msgs (10008)for systems where it was successfully applied. Makes it difficult to get an accurate count of successful apps of the patch. Trying to create collection showing installed patches. Any idea why this wql will not work?
select res.ResourceID,res.ResourceType,res.Name,res.SMSUniqueIdentifier,res.ResourceDomainORWorkgroup,res.Client from SMS_R_System as res inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = res.ResourceId inner join SMS_G_System_UPDATE as p1 on p1.ResourceID = res.ResourceId where (res.OperatingSystemNameandVersion = "Microsoft Windows NT Server 5.0" or res.OperatingSystemNameandVersion = "Microsoft Windows NT Advanced Server 5.0" or res.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 5.0"
and SMS_G_System_OPERATING_SYSTEM.CSDVersion like "Service Pack 3" and SMS_G_System_OPERATING_SYSTEM.Locale = "0409" and p1.ProductName = "Q811493" and p1.IsInstalled = 2
select res.ResourceID,res.ResourceType,res.Name,res.SMSUniqueIdentifier,res.ResourceDomainORWorkgroup,res.Client from SMS_R_System as res inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = res.ResourceId inner join SMS_G_System_UPDATE as p1 on p1.ResourceID = res.ResourceId where (res.OperatingSystemNameandVersion = "Microsoft Windows NT Server 5.0" or res.OperatingSystemNameandVersion = "Microsoft Windows NT Advanced Server 5.0" or res.OperatingSystemNameandVersion = "Microsoft Windows NT Workstation 5.0"
and SMS_G_System_OPERATING_SYSTEM.CSDVersion like "Service Pack 3" and SMS_G_System_OPERATING_SYSTEM.Locale = "0409" and p1.ProductName = "Q811493" and p1.IsInstalled = 2