Windows way to Digital Learning……

Posts tagged ‘Query based collection to collect Hyper-V Vmware Hosts’

Query based collection to collect Hyper-V / Vmware Hosts

Query based collection to collect Hyper-V  & Vmware Hosts and Guest Systems.

Host and Guest OS Collection

Host and Guest OS Collections

 

#1 Query based collection to collect all hyper-v  & Vmware hosts using WQL.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName in (“Hyper-V Virtual Machine Management”,VMware Authorization Service”)

#2 Query based collection to collect all hyper-v  & Vmware guests using WQL.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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”)

 

 

Tag Cloud