SMS 2003 Collection Query for Office 2003 Pro Installation
Finds all SMS Clients that have the resources required to support Offiice 2003. This requires a 233MHz processor, 128MB Ram, 400 MB of free space, and Windows 2000 SP3 or later (including Windows XP and Windows Server 2003)
select SMS_R_System.Name, SMS_R_System.SMSInstalledSites,
SMS_R_System.OperatingSystemNameandVersion,
SMS_R_System.ADSiteName, SMS_R_System.IPSubnets from
SMS_R_System inner join SMS_G_System_PROCESSOR on
SMS_G_System_PROCESSOR.ResourceID =
SMS_R_System.ResourceId inner join
SMS_G_System_X86_PC_MEMORY on
SMS_G_System_X86_PC_MEMORY.ResourceID =
SMS_R_System.ResourceId inner join
SMS_G_System_LOGICAL_DISK on
SMS_G_System_LOGICAL_DISK.ResourceID =
SMS_R_System.ResourceId inner join
SMS_G_System_OPERATING_SYSTEM on
SMS_G_System_OPERATING_SYSTEM.ResourceID =
SMS_R_System.ResourceId where
(SMS_R_System.OperatingSystemNameandVersion = "Microsoft
Windows NT Workstation 5.0" and SMS_G_System_OPERATING_SYSTEM.CSDVersion >= "Service
Pack 3") or (SMS_R_System.OperatingSystemNameandVersion =
"Microsoft Windows NT Server 5.0" and SMS_G_System_OPERATING_SYSTEM.CSDVersion >= "Service
Pack 3") or (SMS_R_System.OperatingSystemNameandVersion =
"Microsoft Windows NT Advanced Server 5.0" and SMS_G_System_OPERATING_SYSTEM.CSDVersion >= "Service
Pack3") or SMS_R_System.OperatingSystemNameandVersion =
"Microsoft Windows NT Server 5.2" or SMS_R_System.OperatingSystemNameandVersion = "Microsoft
Windows NT advanced Server 5.2" or SMS_R_System.OperatingSystemNameandVersion = "Microsoft
Windows NT Workstation 5.1" and SMS_G_System_PROCESSOR.MaxClockSpeed >= 233 and SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory >= 130612
and (SMS_G_System_LOGICAL_DISK.FreeSpace >= 400 and
SMS_G_System_LOGICAL_DISK.Name = "C:")