Wednesday, March 28, 2007

Vista SMS Report

When reviewing Vista requirements I put this together. In the SMS console create 2 new reports and copy these in. Next create a dash board using both reports. Now you can see total minimum and total premier. Obviously the premier machines meet the minimum requirements. I made a minimum to see what computers can run Vista (no Aero) [Vista Minimum] and those that would do very well [Vista Premier]
I tried to grab all the video cards, video ram, desktop ram. Granted this is no subsitute for the Vista, are you ready, software. But it atleast gives us a sign.
Premier Ram is set to 1.5GB though we are looking at 2GB but it should be enough to have a good performance. Modify as you like.
--------------------------------- Vista Minimum
SELECT Distinct SYS.Netbios_Name0,MEM.TotalPhysicalMemory0/1024 As Memory,vc.name0 as VideoCard,
pr.name0 as Processor,man.model0 as Model, pr.MaxclockSpeed0 as Speed
FROM v_R_System SYS
JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID
join v_GS_VIDEO_CONTROLLER vc on SYS.ResourceID = VC.ResourceID
join V_GS_processor pr on SYS.ResourceID = pr.ResourceID
join V_GS_Computer_System Man on SYS.ResourceID = man.ResourceID
WHERE MEM.TotalPhysicalMemory0/1024 >= 990
and SYS.Operating_System_Name_and0
Like '%Workstation%' and (vc.AdapterRam0 > 64000) and vc.name0 not


---------------------------------

-------------------------Vista Premier
SELECT Distinct SYS.Netbios_Name0, MEM.TotalPhysicalMemory0/1024 As Memory,vc.name0 as VideoCard,pr.name0 as Processor,man.model0 as Model
FROM v_R_System SYS
JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID
join v_GS_VIDEO_CONTROLLER vc on SYS.ResourceID = VC.ResourceID
join V_GS_processor pr on SYS.ResourceID = pr.ResourceID
join V_GS_Computer_System Man on SYS.ResourceID = man.ResourceID
WHERE MEM.TotalPhysicalMemory0/1024 >= 1400
and SYS.Operating_System_Name_and0
Like '%Workstation%' and (vc.name0 Like '%X600%'
or vc.name0 like '%RADEON X300%' or vc.name0 like '%Radeon X1300%' or vc.name0 like '%GeForce Go 7300%' or vc.name0 like '%GeForce FX Go5200%'
or vc.name0 like '%X700%' or vc.name0 like '%X600%'or vc.name0 like '%RADEON X300%'or vc.name0 like '%X550%' or vc.name0 like '%82945G%' or vc.name0 like '%82g965%' or vc.name0 like '%945GM%' or vc.name0 like '%GMA950%'
or vc.name0 like '%NVIDIA Quadro nvs%') and vc.name0 not like '%secondary%'
and (pr.name0 like '%pentium(r) 4%' or pr.name0 like '%pentium(r) D%' or pr.name0 like '%Genuine Intel(R) %' ) and pr.MaxClockSpeed0>=2900
order by netbios_name0
-----------------------------