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?


Thanks

Jason

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

Actions

This Discussion