If you are looking SCCM query to
create collection for Workstation / Server computer so you can use this query.
Here is the query..
Query
for workstation machine:
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_SYSTEM on SMS_G_System_SYSTEM.ResourceID =
SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole =
"Workstation"
Query
for server machine:
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_SYSTEM on SMS_G_System_SYSTEM.ResourceID =
SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole =
"Server"
If you have any queries please comment
below.
Note: Please find My Youtube video's Click Here
