Excluding computers from a collection

There are many ways to exclude computers from a collection. One way is to have a sub collection and exclude that one. The next is to create a sub select statement with a few machines..

where SMS_G_System_COMPUTER_SYSTEM.Name not in ( "comp1", "comp2" )

Assuming you have a collection of computers and you want to exclude certain ones then simply append this statement to your Where clause. This will remove these two computer from your list. Test it and see what happens..

Office 2007 updates

If you are deploying Office 2007 you might want to slipstream just like you did with 2003. Generally I don't talk about deployments but since this involves patches I thought I would give a little talk.

First we need to find out what patches are needed. Either use SMS to determine what Office 2007 patches are needed, install a fresh copy and do an office update or some other method.

After you have all the .exe patches you will need to extract the msp file from them. Some .EXE's you can use WinRAR or something else to open the file. With the patches you will need to use the extract method.

"patch.exe /extract" this will cause a window to popup and ask you where to put the msp file. It will need to be in your UPDATE folder. Once Office 2007 is installed then it will patch. Keep this folder up-to-date so that your new computers will come with a fully patched Office 2007.

For More information please see the Office 2007 patch link below

http://technet2.microsoft.com/Office/en-us/library/2ce70869-aa75-4a73-9c9b-8b74001f1c3c1033.mspx?mfr=true

Laptop Network Configuration Group

Do you have locked down laptops and you want to enable the users to change the ip address. This is assuming they are traveling and need a new ip at a hotel. There are several ways you can accomplish this. Here is a vbscript method.

*-------------------
'' This will add all the domain users to the network config group for laptopson error resume next
Set network = WScript.CreateObject("WScript.Network") strComputer = network.computernameSet objGroup = GetObject("WinNT://" & strComputer & "/Network Configuration Operators,group")Set objUser = GetObject("WinNT://DOMAIN/DOMAIN USERS")objGroup.Add(objUser.ADsPath)
--------------------------------