I want to add a custom column in a report that displays the age of account in days

Question

I want to add a custom column in a report that displays members of a group that shows the age of the user account in days. Is that possible?

Answer 1

Hello,

Yes, it is possible. You will need to generate the custom column value using a script. In the script, use the New-TimeSpan cmdlet. The following article will also be helpful: https://adaxes.com/sdk/GenerateReportCustomColumns.

Comments

Thank you.

This is what I have but it throws an error. Can you let me know how to adjust it to return the value in days?

# Assign a column value to $Context.Value
$Context.Value = New-TimeSpan -End (Get-Date %whenCreated%)

---

Hello,

The script is expected to error out because it is not allowed to execute the New-TimeSpan cmdlet with only the -End parameter. That is something you can see from the article we referenced in the previous post. Also, value reference %whenCreated% will not work here as it will resolve into the property value of the initiator making the column value the same for all objects in the report. Here is the script you can use.

# Get object creation date
$object = $Context.GetDirectoryObject()
$whenCreated = $object.Get("whenCreated")

$timeSpan = New-TimeSpan -Start $whenCreated -End "%datetime%"
$Context.Value = $timeSpan.Days

---

thank you