Recursively Query v_R_user in Configuration Manager

The following query will allow you to search the view v_R_user in the Microsoft Configuration Manager database so that you can identify a manager and then find everyone who works for that manager all the way down the tree. I’ve found this useful in the past for joining with other information in the database to identify all the systems used by a specific group within an organization. This requires that you collect the manager name during user discovery. You can remove any fields that you don’t discover. It also requires that you have managers identified in Active Directory for discovery.

Have a suggestion for an improvement?  Please let me know in the comments!


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.