Group Policy WMI filtering

This is from hhttp://technet.microsoft.com/en-us/library/cc947846.aspx and http://technet.microsoft.com/en-us/library/cc758471.aspx but I have added more information with examples or WMI filters and a table of Windows version numbers and Product Types. WMI filters can take significant time to evaluate, so they can slow down logon and startup time. The amount of time depends on the construction of the query.…

Read more Group Policy WMI filtering

SCCM 2007 R2 – SQL Queries

To get an accurate list of computers to usernames vice versa, change the part in RED to suit SELECT     v_R_System.Netbios_Name0, v_R_System.User_Name0, v_RA_System_IPAddresses.IP_Addresses0, v_RA_System_IPSubnets.IP_Subnets0,                       v_GS_COMPUTER_SYSTEM.UserName0FROM         v_R_System INNER JOIN                      v_RA_System_IPAddresses ON v_R_System.ResourceID = v_RA_System_IPAddresses.ResourceID INNER JOIN                      v_RA_System_IPSubnets ON v_R_System.ResourceID = v_RA_System_IPSubnets.ResourceID INNER JOIN                      v_GS_COMPUTER_SYSTEM ON v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceIDWHERE     (v_RA_System_IPSubnets.IP_Subnets0 = ‘10.10.35.0‘) Or………. From two subnets SELECT    …

Read more SCCM 2007 R2 – SQL Queries

Users & Computers Inventory

This is to create an accurate inventory of user names to computer names and vice versa On a server, create a shared folder. Grant the share permission and NTFS permission for the folder to allow Full Control for the group Everyone. On your domain controller, create a new GPO at domain level. Edit the policy.…

Read more Users & Computers Inventory

Install Self Signed Exchange 2010 SSL certificate

For my example, my domains are… Local domain: vcp.local Outside domain: vcpdomain.com.au #NETBIOS name of Client Access exchange server:        vcpsydex01 #Internal FQDN (AD name):        vcpsydex01.vcp.local #External FQDN (Public name):        smtp.vcdomain.com.au #Autodiscover name:            autodiscover.vcdomain.com.au #SubjectName:                cn=smtp.vcdomain.com.au Run the following command on the Client Access Server for generating the new Self-Signed SSL cert using the names listed…

Read more Install Self Signed Exchange 2010 SSL certificate

Picking up Computer Group Membership Changes without a Reboot

Firstly, this is a great article I got from – http://sdmsoftware.com/blog/2008/08/picking_up_computer_group_memb.html One of the irritating side effects of using Group Policy security group filtering on computers is that, if you change a computer’s group membership, you either had to reboot the computer or wait the default 7 days for the computer’s Kerberos ticket to expire…

Read more Picking up Computer Group Membership Changes without a Reboot

Install a local TCP/IP printer using a VBS script

To install a printer using a TCP/IP port, I run the following script, which works perfectly. Just change the sections in RED to suit. ………………………………………………………………………………………………. strComputer = "."Set objWMIService = GetObject("winmgmts:" _    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")objWMIService.Security_.Privileges.AddAsString "SeLoadDriverPrivilege", True Install "10.10.65.23" ‘ Start the install of the printer sub Install(strIP)    InstallPrinterPort strIPend Sub ‘==================strBasePrinter…

Read more Install a local TCP/IP printer using a VBS script