Active Directory report based on 365 licence type

Active Directory report based on 365 licence type


Not sure I'm going about this the right way, or if it is possible. any help would be great :)

I would like to create a report to use for an automation.

The report should return users who:
Are licenced with 365 Business Premium specifically
That are not part of a certain group
That have a certain keyword in their title
are a member of a certain domain.

I know I can achieve the licenced users on the M365 reports, and the rest of the queries can be done in AD reports, but how can I get the list of licenced users into the AD reports from M365 reports?

I've tried creating a scheduled report, but can't see how to use the report from the M365 module as a basis for further filtering in a AD reports custom report

Many thanks

                New to ADManager Plus?

                  New to ADSelfService Plus?