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…

For a multiple-forest domain configuration I was working on I needed to be able to discover and deploy agents from another forest than the one that my ConfigMgr server was in. This is a ConfigMgr environment which was using advanced security.  The discovery in the remote system kept failing on the discovery for the forest…