0 votes

Hi

I'm trying to product a report to show the users with either E3, F3 or F5 licenses.

If I add the Adaxes "Microsoft 365 Licenses" attribute directly to the report then I can see the licenses assigned, but this is really ugly! image.png

I would like to add a custom column which would take the raw "Microsoft 365 Licenses" information from the user and show a nice "Microsoft E3" etc value.

Is this possible?

Thanks

by (1k points)
0

Hello,

This behavior is by design as the property contains only SKU part numbers of Microsoft 365 licenses. Do we understand correctly that the custom column should contain a comma-separated list of assigned licenses display names? For us to help you with the entire report, please, provide all the possible details regarding the desired behavior with live examples. Screenshots of the current report configuration will be much appreciated. You can post them here or send to us at support@adaxes.com.

0

Thanks for the information.

At the moment the report is displaying like this

image.png

What I would like to be able to do if possible is for the licenses to be replaced for a more user friendly opton such as

image.png

Thanks

Matt

0

Hello Matt,

Thank you for the provided example. In your screenshot, there is only one license present for each user in the Microsoft 365 Licenses column. Would it be convenient for you to have a comma-separated list of licenses in the column (e.g. Microsoft E5, Microsoft E5, Dynamics 365 Business)? It will be similar to the current behavior, but the names will be more user-friendly.

0

Hi

That would be a great start yes.

Ideally though the report would work as follows:

If the raw data is

image.png

and the person running the report selects that they want to see users with either an E3 or an E5 license then the report output would look like this

image.png

This way we don't have the report showing a lot of unrequired license information.

Thanks

0

Hello Matt,

Thank you for the update. As we understand, you want users to select the licenses for report generation. Would a checkbox list parameter meet your needs? image.png Also, what is a user selects multiple licenses and they are all assigned to an account? Should the license names be present as a comma-separated list in the corresponding column?

0

Hi

The checkboxes are perfect and I have managed to get the report to work with these already, it's more the license information returned I am struggling with :)

Yes, if an account has multiple of the selected licenses then the corresponsing column should show all the selected licenses associated to that account.

Thanks

1 Answer

0 votes
by (211k points)

Hello Matt,

Thank you for all the provided details. Have a look at the following script from our repository: https://www.adaxes.com/script-repository/microsoft-365-licenses-assigned-to-users-s641.htm.

Related questions

0 votes
1 answer

I'm trying to retrive the Microsoft 365 License product name in a report as the 'Office 365 License' attribute in Adaxes shows each individual licensed product e.g. ... 365 F3"} } $productnames = $productnames -join ", " $Context.Value = $productnames

asked Jul 27, 2020 by richarddewis (220 points)
0 votes
1 answer

I'm trying to use "Before Modify Office 365" event to request approval for changes. It seems to be kicking off for the "After Create User" event. How do I request ... for default settings but if admins want to make a change then it goes out for approval.

asked Jul 20, 2020 by ComputerHabit (790 points)
0 votes
1 answer

Adaxes version is 2018.2. I have build a custom report, and I don't want the 'Name' column with the pictures to appear in it. But it seem to be mandatory, it is greyed ... . Is there a way to remove / hide / or change the mandatory attribute or column ? Thanks

asked Jan 9, 2020 by Isabelle (50 points)
0 votes
1 answer

Hi, I try to make a report for our SAM to show all users with a specific license. But I fail to even find anything. I tried, among many ... .DirectorySearcher.AppendFilter("(adm-O365AccountLicenses=POWER_BI_STANDARD)") But I get nothing. Please advice.

asked May 20 by KristofferJ (80 points)
0 votes
1 answer

Hi Can you lead us to what we are doing wrong with this report? `$CID ="{ed8afa99-e34d-4531-b69a-0bd0785f4d3a}" $folders = gci -force '\server\Kunden'-ErrorAction ... Value generation = Template, empty. ColumnID is double checked an is the right one. Thanks

asked Mar 5, 2020 by maca (100 points)
2,607 questions
2,344 answers
6,228 comments
862,510 users