Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Unity SQL query for distribution list membership

I am trying to run a query that will list all members of a distribution list along with their extension, first and last name.

Here is the query I am trying to build off:

select dtmfaccessid, vw_distributionlist.alias, systemdlistmember.alias, systemdlistmember.displayname

from vw_distributionlist

join systemdlistmember on parentobjectid=systemdlistobjectid

where dtmfaccessid like 90090122

order by systemdlistmember.displayname

I don't think you can query against vw_distribuionlist and vw_subscriber at the same time.

Any ideas?

Thanks

Jason

217
Views
0
Helpful
0
Replies