Answers ( 3 )


    i use it for a patch group as we only want to patch specific machines for users in a certain ad group. so the collection group is the user group you want to use.

    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 join SMS_G_SYSTEM_COMPUTER_SYSTEM on SMS_G_SYSTEM_COMPUTER_SYSTEM.ResourceID = SMS_R_SYSTEM.ResourceID join SMS_G_system_SYSTEM_CONSOLE_USAGE on SMS_G_SYSTEM_COMPUTER_SYSTEM.ResourceID = SMS_G_system_SYSTEM_CONSOLE_USAGE.ResourceID join SMS_R_User on SMS_G_system_SYSTEM_CONSOLE_USAGE.TopConsoleUser = SMS_R_User.UniqueUserName join SMS_FullCollectionMembership on SMS_FullCollectionMembership.Name = SMS_R_User.Name Where SMS_FullCollectionMembership.collectionID = ‘xxxx’

    Best answer


    First you can understand SQL query is used in SQL Server management studio to get the report.

    For creating collections in SCCM console. you need to use WQL Query.

    Possible to create the WQL device collection based on user collection. what is your requirement.

    based on what condition you need to validate the users?

    I mean last logon user or primary user or top console user or it’s user adgroup ?



    Device collection based on user collection …why do you need that pls?

    I don’t think it’s possible to mix users in the device collection

    and devices in users collection.

Leave an answer

Sorry, you do not have permission to answer to this question .