How to get a report of Active Directory Users suspended a certain time ago

Summary: This article describes how to get a report of Active Directory Users suspended 30 days ago.

Applies to: Cayosoft Administrator 8.x or later.

ID: KB20211215-1

---

 

Configuration

1. Create the AD Users report.
2. In Query criteria specify this script:

   {accountNameHistory -eq "<objectsuspended/>" -and accountNameHistory -like "*SuspendReport*" -and whenChanged -ge $compareDateTime}

3. In Other Query Settings in Filter specify this script:
   { [DateTime]::Parse(([xml]($_.accountNameHistory -like "*type=""SuspendReport""*")[0]).ObjectOperationsReport.start) -ge $compareDateTime }
4. In Initialization script:
   { $global:compareDateTime = [DateTime]::Now.AddDays(-30) }
5. Save changes.