cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
257
Views
5
Helpful
1
Replies

Unity Connection SQL query for search space

Hi,

 

Is there an sql query to lookup with users(alias) that are using a specific Search space on CUC 11.5.

 

Thanks

1 Reply 1

lindborg
Cisco Employee
Cisco Employee

This will return the partition name, search space name, user alias and extension for the primary extension of all subscribers:

SELECT vw_searchspacemember.partitionname, vw_searchspacemember.SearchSpaceName, vw_subscriber.alias, vw_dtmfaccessid.DtmfAccessId
FROM vw_searchspacemember, vw_subscriber, vw_dtmfaccessid
WHERE vw_searchspacemember.partitionobjectid=vw_dtmfaccessid.PartitionObjectId
AND vw_subscriber.ObjectId = vw_dtmfaccessid.Parent_SubscriberObjectId
AND vw_dtmfaccessid.IdIndex=0

 

if you want to filter on a specific searchspace name you can add:

AND vw_searchspacemember.SearchSpaceName='xxx'

 

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers