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

Configure Backup Exec 12.5 For VMware ESX VCB Backups

Pre-Configuration Steps Install VMware Consolidated Backup Framework onto the Backup Exec server Before installing VCB and connecting the proxy host to the SAN you should disable automount via diskpart(cmd, diskpart, automount disable, automount scrub). When you don’t disable automount Windows will signature all “incoming” disks. When this happens the VMware hosts will not recognize the…

Read more Configure Backup Exec 12.5 For VMware ESX VCB Backups

Default logon domain with IIS

When using IIS FTP for example, the username and password box that pops up won’t accept a username on the domain without putting the domain in front. To avoid having to type in domain\username in the username box follow this Microsoft knowledge base article. This is the error that you might get: Error message in…

Read more Default logon domain with IIS