Friday 18 December 2009

Office 2007 SP2 required query

Office 2007 SP2 required query
select SMS_R_System.Name, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "2007 Microsoft Office Suite Service Pack 2 (SP2)" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "2007 Microsoft Office Suite Service Pack 2 (SP2)") and SMS_R_System.Obsolete = 0 and SMS_R_System.Client = 1 and SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation%" and SMS_R_System.ResourceDomainORWorkgroup = "DOMAINNAME" and SMS_R_System.Name not in ("MACHINE NAMES","Machine Names")

No comments:

Post a Comment