Tricks SCCM >> SCCM Query for Virtuals
Hi,
Trick which allows via a query of identification systems in your
virtual architecture SCCM (valid for VMware technology, Hyper V,
Virtual PC and Virtual Server 2005 R2.
Here is the request to copy:
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")
It is possible to link this request to a collection.