Hi Folks……. again it’s something about SCCM, I think few of
my last articles would have helped you in many System administrative
aspects…now I am here with SCCM collection query for virtual and physical
machines in the given environment.
Here is the query,
Query for Virtual
machines:
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 where SMS_R_System.IsVirtualMachine
= "1"
Query for physical
machines:
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 where SMS_R_System.IsVirtualMachine != "1"
Note: Please find My Youtube video's Click Here
