0 votes

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.

by (40 points)

1 Answer

0 votes
by (277k points)


To achieve the desired, you need to use custom columns. It is not about Adaxes not having specific attributes. The thing is that you can only obtain cloud objects using scripts and view their properties in reports only using custom columns. For details on how to work with report custom columns in scripts, have a look at section Setting values for custom columns of the following SDK article: http://www.adaxes.com/sdk/GeneratingReports/#setting-values-for-custom-columns. Also, the following script from our repository might be helpful: https://www.adaxes.com/script-repository/status-of-users-mfa-in-microsoft-365-s601.htm.

Related questions

0 votes
1 answer

I have a fairly simple function that I want to convert to a report in Adaxes that others can use The PowerShell function as it currently exists function Get-Groups { [CmdletBinding( ... with errors or a blank report. So how can I just add values to the report?

asked Jan 10 by jcrook (100 points)
0 votes
1 answer

I have an ADP Sync scheduled task that modifies and creates users from a csv file. I also have reports that show new users created and management history for user ... ADP Sync scheduled task so that they only run after the ADP Sync task is complete?

asked Jan 7, 2020 by barberk (60 points)
0 votes
0 answers

Hello, Please advise how to extract objects from two locations to create a report I am thinking something like SQL join operation Thank you.

asked Apr 4, 2023 by hhsmith (60 points)
0 votes
1 answer

How to create a user login history report?

asked Nov 1, 2022 by kherrera44 (20 points)
0 votes
1 answer

Hi, I followed this example: https://www.adaxes.com/sdk/IAdmTop6.html, but because the Custom Command is disabled, I get the following error message: System.Management.Automation ... if I enable the Custom Command. I am using Adaxes 2018.2 Best Regards Martin

asked Feb 19, 2020 by Martin (100 points)
3,411 questions
3,108 answers
545,849 users