QuickTricks: ConfigMgr Query for Virtuals

Looking for a query to identify what systems are virtuals in ConfigMgr? Check this out! select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.NetbiosName from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Manufacturer in ("VMware, Inc.","Microsoft Corporation") This identifies systems which are running in Hyper-V or VMWare, and…

Technet Magazine Articles November 2008

The November edition of TechNet magazine is now available online at: http://technet.microsoft.com/en-us/magazine/default.aspx?pr=blog. This edition includes three articles that I consider to be especially interesting: Monitoring Windows Server 2008 with OpsMgr 2007 by Pete Zerger. Granular Targeting In Operations Manager 2007 by Steve Rachui. Using Configuration Manager with Windows Server 2008 by Cameron Fuller. This is…

Create a computer group for systems without an AD Site in OpsMgr

Previously I wrote up a blog entry on how to create computer groups based upon Active Directory sites within Active Directory (http://cameronfuller.spaces.live.com/blog/cns!A231E4EB0417CB76!950.entry). Recently I was creating these groups and found that several of the systems did not actually have an Active Directory Site defined for them (seen in the Windows Computer properties of the system…