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
-----------------------------

Exiting Batch Files

Sometimes when using SMS you want to use a Batch file to see if a file is present and preform an action, or maybe delete a file. When using batch files you can get the current error level for validation or set the error level to your liking. For instance you have a batch file that checks to see if a file is present, if so run a program, else exit. Lets say for instance that the Batch always exits with a error 1 but it should exit with a 0 and continue on with the next program. To get around do this in the batch file
---
Exit /b [error level]
Exit /b 0 <- this will allow you to exit with a successful exit code
----

or try this

-----
set errorlevel=0 <- this will allow you to exit with a successful exit code

-----


This should only be done if you have tested and know the desired out come. Forcing a successful exit can lead to other problems. Make sure you cover any possible errors that might occur in the Batch file

Google Search in IE 6

There are several ways to change your search engine. You could just click search and change it. You can use the IE 6 deployment tool to change it and then push it out to your computers. But that seems to only affect the search bar. What happens if you want to change it in the address bar as well. Here is a vbscript that you easily change to a reg file. Either way you can push it through SMS to your clients. I really don't know why I did this a vbscript and not a reg file. I guess I was looking to see what I could do with VBS and the registry. When this is run per user it will set their search default to Google but it will also change the address bar into a google search. No need for the Google tool bar.

--------------------------google-search.vbs
Dim objShell, RegLocate
Set objShell = WScript.CreateObject("WScript.Shell")
On Error Resume Next

'Set Search Assistant

RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main\Use Search Asst"
objShell.RegWrite RegLocate,"yes","REG_SZ"

RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main\Search Page"
objShell.RegWrite RegLocate,"http://www.google.com","REG_SZ"

RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main\Search Bar"
objShell.RegWrite RegLocate,"http://www.google.com/ie","REG_SZ"

RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\SearchURL\"
objShell.RegWrite RegLocate,"http://www.google.com/keyword/%s","REG_SZ"

RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\SearchURL\provider"
objShell.RegWrite RegLocate,"gogl","REG_SZ"

RegLocate = "HKEY_CURRENT_USER\Software\Microsoft\search Assistant\DefaultSearchURL"
objShell.RegWrite RegLocate,"http://www.google.com/search?q=","REG_SZ"
--------------------------