Hello,

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

Adam