Issues with exporting multiple changed values from the Web Interface to a report

Question

Hello

I am trying to export data via a script in a Business Rule for multiple users when their password is reset in the Web console, and I am having the following issue:

• It only returns one row of values, not each row for each user

Code being used:

$csvFilePath = "C:\Scripts\Report.csv" # TODO: modify me
$removeCsvFile = $True # TODO: modify me

$usernames = $Context.TargetObject.GetPropertyValues("Name")

$Data = foreach ($user in $usernames) {

[pscustomobject]@{
    'First Name' = "%givenName%"
    'Last Name' = "%sn%"
    'Email' = "%mail%"
    'P' = "%unicodePwd%"
        }
}

$Data | Export-Csv -Path $csvFilePath -NoTypeInformation

Answer 1

Hello,

Business rules trigger for each object separately, even if a bulk operation is performed on multiple objects. In your case, the business rule triggers, and the script is executed for each user whose password is reset. If you need to export the property values of all users whose passwords were reset, you can get the values of a single user and append them to the export file in the script. To do so, specify the -Append parameter in the Export-Csv cmdlet.