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 (2.0k 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 (270k points)
selected by
Best answer

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 (260 points)
0 votes
1 answer

Hi how can we pull reports on users and there Microsoft 365 license.

asked Nov 13, 2023 by johanpr (80 points)
0 votes
1 answer

Hi all, we switched from an exchange hybrid model to online only. So we turned off our on-prem exchange server. After some tries we faced the following problem: After ... Will Adaxes recognize that there is no on-prem anymore? Thank you for helping us!

asked Nov 16, 2022 by robin.christmann (160 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

Hi I'm trying to add your report from here but whenever I run it, I get 2 errors for each user which seem to correspond to the following 2 lines in the ... "user" $Context.DirectorySearcher.AddCriteria($criteria) But I still get the same error's. Thanks Matt

asked Oct 16, 2023 by chappers77 (2.0k points)
3,326 questions
3,025 answers
7,724 comments
544,675 users