Report - Search Option with empty Param Value

Question

Hi,

I copied report "recently created users" and added a parameter to check for specific value in extensionAttribute3.

If this attributes starts with e.g. value "startdate" , only those users should be shown. If not, all. (value is then empty in AD)

Config

Report is working fine if checkbox is checked and param value is set. Its not working with unchecked and empty value and I tried several options already (space, $null, * , %%, ? , ...)

Any idea how to build the report?

Answer 1

Hello,

Unfortunately, there is no possibility to achieve the desired behavior using criteria. It can only be done using a script. For example:

$parameterName = "param-MyParameter" #: TODO modify me
$valueWhenChecked = "startdat" #: TODO modify me

# Get parameter value
$parameterValue = $Context.GetParameterValue($parameterName)

# Build criteria
if ($parameterValue -eq $valueWhenChecked)
{
    $criteria = New-AdmCriteria "user" {mailboxType -ne "shared" -and whenCreated -lt "%param-Days%" -and extensionAttribute3 -contains $valueWhenChecked}
}
else
{
    $criteria = New-AdmCriteria "user" {mailboxType -ne "shared" -and whenCreated -lt "%param-Days%" -and extensionAttribute3 -empty $False}
}

# Generate report
$Context.DirectorySearcher.AddCriteria($criteria)
$Context.Items.Add($Context.DirectorySearcher)

Comments

Hi,

thanks for this idea. I needed to change the script logic, as no account was shown and your date logic seems wrong.

But now everything is working :)

$daysback = "%param-Days%"
$date = (Get-Date).AddDays(-$($daysback))

# Build criteria
if ($parameterValue -eq $valueWhenChecked)
{
    $criteria = New-AdmCriteria "user" {whenCreated -ge $date -and extensionAttribute3 -startsWith $valueWhenChecked}
}
else
{
    $criteria = New-AdmCriteria "user" {(whenCreated -ge $date) -and ( (extensionAttribute3 -empty $True) -or (extensionAttribute3 -empty $False) )}
}