cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
99
Views
5
Helpful
1
Replies
Highlighted

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
Highlighted
Cisco Employee

Re: Unity Connection SQL query for search space

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'

 

CreatePlease to create content
Content for Community-Ad

Cisco COVID-19 Survey