I am working on creating a report which will pull data from O365 using PowerShell (data I am looking for is not available natively in ADAxes from what I can see), and generate a report of Azure group memberships. The report prompts the user to select an ADObject which it then uses to determine what user object to pull the report for.
I know how to use this data to query O365 and get the data I want, but I am having difficulty figuring out how to add the data I collect into custom columns in the report.
For example, I have four columns I want to create and populate:
- Group Name (Text)
- Group Mail Address (Text)
- Group Type (Text)
- Dynamic Group (Boolean)
All of the above attributes I can pull from O365 via PowerShell, but I am not sure how to properly create the columns, and also to populate them with the attributes collected in the script.