HOWTO find all groups a device belongs to

Expand / Collapse
 

HOWTO find all groups a device belongs to


Article ID: 51756 - Last Review: December 10, 2012

PROBLEM

You have an individual device (Agent, Extension, Queue, etc.) and need to quickly find out what Groups they belong to.  In YourSite Explorer this is a bit cumbersome, as you have to search the other way around (open Group, see Members).



RESOLUTION

The attached .ZIP file contains scripts for Agent, Extension, and Queue.  They can be modified to fit any group and device type.

1. Download the attached .ZIP file to a system with SQL Management Studio and access to the SQL server. 
2. Extract the .ZIP file.  Inside there are three SQL scripts to search by device (Agent, Extension, and Queue).
3. Double click the appropriate script to load it into SQL Management Studio.
4. Substitute a reporting number in place of the #### near the end of the script.  Be careful to keep the single quotes around your reporting number.
4. Click the Execute Now button at the top.  The scripts will return Names, and Reporting numbers for all groups the selected device belongs to.

NOTE: There are actually several forms of 'single quote', and SQL Management Studio is very particular.  If you get a syntax error, try removing the single quotes and re-adding them (on the key next to Enter with " and ' .)



APPLIES TO

CCM, all versions 

Keywords: device agent extension queue group lookup member membership



Rate this Article:
     

Attachments


SQL-ReverseLookups.zip SQL-ReverseLookups.zip (988 GB, 763 views)

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Monday, December 10, 2012
Last Modified By: amontpetit
Type: HOWTO
Article not rated yet.
Article has been viewed 5,086 times.
Options