Approval Requests Missing approved requests

Question

I have reviewed the the actual logs under logging and can see tasks that went off for approval, but when I select Approval Requests - I cannot find them under approved, denied, or cancelled. Where can I find out who approved these items and when? I believe it may be a limitation problem as when I select All - Approved it shows me 1000 and that never grows beyond that number.

Answer 1

Hello Michael,

Currently, Adaxes shows you only 1000 latest Approval Requests. The task to show all Approval Requests is in our TODO list.

For now, you can use a PowerShell script that outputs all approved requests that were initiated during the last X days. The number of days is specified by the $daysNumber variable. Here it is:

[Reflection.Assembly]::LoadWithPartialName("Softerra.Adaxes.Adsi")

$daysNumber = 30 # TODO: modify me

$admNS = New-Object("Softerra.Adaxes.Adsi.AdmNamespace")
$admService = $admNS.GetServiceDirectly("localhost")

# Bind to the Approval Requests container
$containerPath = $admService.Backend.GetConfigurationContainerPath("ApprovalRequests")
$searcher = $admService.OpenObject($containerPath.ToString(), $NULL, $NULL, 0)

# Get approval requests
$state = 1 # Approved request
#$state = 2 # Denied request
#$state = 3 # Canceled request

$startDateTime = ((Get-Date).AddDays(-$daysNumber)).ToFileTime()

$searcher.SearchFilter = "(&(objectCategory=adm-ApprovalRequest)(adm-ApprovalState=$state)(adm-ApprovalRequestCreationTime>=$startDateTime))"
$searcher.PageSize = 500

$requests = $searcher.ExecuteSearch()

# Iterate through the requests
foreach($request in $requests.FetchAll())
{
    $request = $admService.OpenObject($request.AdsPath, $NULL, $NULL, 0)

    Write-Host "Date: " $request.CreationDate
    Write-Host "Operation:" $request.DescriptionOfOperationToApprove
    Write-Host "ProcessedBy:" $request.ProcessedBy.Get("name")
    Write-Host "Requestor:" $request.Requestor.Get("name")
    Write-Host
}

$requests.Dispose()

Comments

Thank you, could I get this to wrtie to a file?

---

Hello Michael,

Yes, sure. This version of the script outputs the Approval Requests information to the CSV file specified by $csvFilePath.

[Reflection.Assembly]::LoadWithPartialName("Softerra.Adaxes.Adsi")

$csvFilePath = "\\server\share\File.csv" # TODO: modify me
$daysNumber = 30 # TODO: modify me

$admNS = New-Object("Softerra.Adaxes.Adsi.AdmNamespace")
$admService = $admNS.GetServiceDirectly("localhost")

# Bind to the Approval Requests container
$containerPath = $admService.Backend.GetConfigurationContainerPath("ApprovalRequests")
$searcher = $admService.OpenObject($containerPath.ToString(), $NULL, $NULL, 0)

# Get approval requests
$state = 1 # Approved request
#$state = 2 # Denied request
#$state = 3 # Canceled request

$startDateTime = ((Get-Date).AddDays(-$daysNumber)).ToFileTime()

$searcher.SearchFilter = "(&(objectCategory=adm-ApprovalRequest)(adm-ApprovalState=$state)(adm-ApprovalRequestCreationTime>=$startDateTime))"
$searcher.PageSize = 500

$requests = $searcher.ExecuteSearch()

# Iterate through the requests
$newCSVObject = @()
foreach($request in $requests.FetchAll())
{
    $request = $admService.OpenObject($request.AdsPath, $NULL, $NULL, 0)

    $newPSObject = New-Object PSObject
    $newPSObject | Add-Member -Name Date -Value $request.CreationDate -MemberType NoteProperty
    $newPSObject | Add-Member -Name Operation -Value $request.DescriptionOfOperationToApprove -MemberType NoteProperty
    $newPSObject | Add-Member -Name ProcessedBy -Value $request.ProcessedBy.Get("name") -MemberType NoteProperty
    $newPSObject | Add-Member -Name Requestor -Value $request.Requestor.Get("name") -MemberType NoteProperty

    $newCSVObject += $newPSObject
}

$newCSVObject | Export-CSV $csvFilePath -NoType
$requests.Dispose()

---

Starting from version 2013.1, Adaxes shows all Approval Requests that match the search filter. The limitation of showing only 1000 Approval Requests has been removed.