Dear all,(SMS2003) Can any one please provide for me a query to create a report to check the PCs that can be upgrade to windows 7.Regards,Mohammed

Hi,This report works with Configmgr, haven't tested it with SMS 2003. It's a default ConfigMgr SP2 report. It contains a prompt that you must remove.SELECT DISTINCT SYS.Netbios_Name0, fcm.SiteCode, ROUND(CONVERT (FLOAT ,LDISK.FreeSpace0) / 1024, 2) AS FreeSpace0, ROUND (CONVERT (FLOAT, PROC1.MaxClockSpeed0), -2)/ 1000 AS 'Processor (GHz)', ROUND (ROUND(CONVERT (FLOAT ,MEM.TotalPhysicalMemory0) / 1048576, 2) * 1024, 0) AS C083, ISNULL(CONVERT(VARCHAR(7), MAX (DA.AdapterRAM0) / 1024), 'UNKNOWN') AS AdapterRAM, OPSYS.Caption0 AS 'Operating System', CONVERT(FLOAT, LEFT(OPSYS.Version0, 3)) VersionFROM v_FullCollectionMembership fcmJOIN v_R_System SYS ON fcm.ResourceID=SYS.ResourceIDJOIN v_GS_PROCESSOR PROC1 ON SYS.ResourceID = PROC1.ResourceIDJOIN v_GS_X86_PC_MEMORY MEM ON SYS.ResourceID = MEM.ResourceIDLEFT OUTER JOIN v_GS_VIDEO_CONTROLLER DA ON SYS.ResourceID = DA.ResourceIDJOIN v_GS_OPERATING_SYSTEM OPSYS ON SYS.ResourceID = OPSYS.ResourceIDJOIN v_GS_LOGICAL_DISK LDISK ON SYS.ResourceID = LDISK.ResourceID AND LDISK.DeviceID0=SUBSTRING(OPSYS.WindowsDirectory0,1,2)WHERE ROUND (ROUND(CONVERT (FLOAT ,TotalPhysicalMemory0) / 1048576, 2) * 1024, 0) >= 1024AND ROUND (CONVERT (FLOAT, PROC1.MaxClockSpeed0), -2)/ 1000 >= 1 AND ROUND(CONVERT (FLOAT ,LDISK.FreeSpace0) / 1024, 2) >= 16AND fcm.CollectionID=@CollIDGROUP BY SYS.Netbios_Name0, fcm.SiteCode, LDISK.FreeSpace0, PROC1.MaxClockSpeed0, MEM.TotalPhysicalMemory0, OPSYS.Caption0, OPSYS.Version0Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products