Solved

Creating SCCM 2012 User Collections

Posted on 2013-01-15
1
884 Views
Last Modified: 2013-01-18
Hi All,

I have created user group base on their geographical location
example : staff_africa; staff_europe ; staff_india...
Now I want to create a collection using this name so that when I open the collection I see only users belonging to this group

I'm looking for the exact query that will help me create users collection base on the group name they belong to.
0
Comment
Question by:tanopatrice
1 Comment
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 38782501
select SMS_R_USER.ResourceID,SMS_R_USER.ResourceType,SMS_R_USER.Name,SMS_R_USER.UniqueUserName,SMS_R_USER.WindowsNTDomain from SMS_R_User where SMS_R_User.SecurityGroupName = '<domain>\staff_africa'

or

select SMS_R_USER.ResourceID,SMS_R_USER.ResourceType,SMS_R_USER.Name,SMS_R_USER.UniqueUserName,SMS_R_USER.WindowsNTDomain from SMS_R_User where SMS_R_User.SecurityGroupName LIKE '%staff_africa%'
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DNS and Active directories 4 54
Error 0x80070780 7 730
SCCM Failed to Run Task Sequence Error 27 699
How to verify if MS security patches have been effected 5 61
This comprehensive conference-networking guide will help you prep, practice and pack for success, reach out with purpose and confidence, capitalize on connections, and turn all those new leads into long-term connections.
IT certifications are a concrete representation of continual learning on the part of the candidate.  Continual learning is necessary for the long term success of an IT professional, but are IT certifications the right path for you?
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question