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
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.