Unity SQL query for distribution list membership

Unanswered Question
May 7th, 2008
User Badges:

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?



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)


This Discussion