"Microsoft 365 licenses assigned to users" report not working

Question

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 script

"$searchIterator = $Context.DirectorySearcher.ExecuteSearch()" "$searchResult = $searchIterator.Current"

I did wonder if this is because the DirectorySearcher still trying to use AppendFilter, so I tried changing this to

$criteria = New-AdmCriteria "user"
$Context.DirectorySearcher.AddCriteria($criteria)

But I still get the same error's.

Thanks

Matt

Answer 1

Hello Matt,

Your changes to the script are correct. We made them in the repository as well. With the changes the script work just fine in Adaxes 2023 and 2023.2. Make sure that you properly configure the parameter and custom column.

Comments

I'm glad I'm half way there!

Just to check, for the SKU for Business premium

The value when checked for the check list will be SPB?

---

Hello Matt,

Yes, that is correct.

---

Hmm, I must be missing something then. Here's my parameter

and here's the first part of the script, the rest is unchanged from your template

$licensesColumnID = "{edca8ffc-39ba-4feb-adde-545c779b32d1}" # TODO: modify me
$licensesParameterName = "param-Licenses" # TODO: modify me
$separator = ";" # TODO: modify me

# Get licenses to check
$licensesToCheck = $Context.GetParameterValue($licensesParameterName).Split($separator)

$criteria = New-AdmCriteria "user"
$Context.DirectorySearcher.AddCriteria($criteria)
try
{
    $searchIterator = $Context.DirectorySearcher.ExecuteSearch()

Yet when I run the report, I get 2 errors for every user.

I'm running Adaxes 3.16.21906.0 in a non HA setup on Server 2022.

---

Hello,

How exactly did you configure the custom column? Please, provide us with a screenshot of the Value Calculation tab. You can post the screenshot here or send to us at support@adaxes.com.

---

Oh dear, oh dear, oh dear! It seems I've been a little bit of an idiot and put your script in the custom column calculation

I'm so sorry for wasting your time.

Thanks as always for your amazing support though.

Matt