Update several attributes from one

Question

Would it be possible to update this script to modify three or more attributes based off one?

ex. when updating departmentnumber "0666" we want the following attributes to update automatically: City, State and department (we build our department from city, state and dept number).

http://www.adaxes.com/script-repository ... e-s379.htm

Comments

Hello,

we build our department from city, state and dept number

What exactly do you mean?

Also, could you specify how City, State and department depend on the departmentnumber?

---

our example would be as follows: we update a department number to "0001" and the following attributes should change with it: city state and department.
ex. dept number = 0001 city= syracuse state = NY department = syracuse, ny - 0001

Answer 1

Hello,

Thank you for clarifying. Here you are:

$basePropertyName = "departmentNumber" # TODO: modify me
$valueMap = @{
    "01234" = @{
        "l" = "City1";
        "st" = "State1";
    };
    "57890" = @{
        "l" = "City2";
        "st" = "State2"
    };
} # TODO: modify me. Example @{<base property value> = <Property map>}. 
# $valueMap = @{"0001" = @{"l" = "City"; "department" = "Dep1"; "st" = "State"}}

# Get base property value
try
{
    $baseValue = $Context.TargetObject.Get($basePropertyName)
}
catch
{
    return # Value not specified
}

# Update properties
$propertyMap = $valueMap[$baseValue]
if ([System.String]::IsNullOrEmpty($propertyMap))
{
    $Context.LogMessage("Properties to update not specified for '$baseValue' value", "Warning")
    return
}

$user = $Context.BindToObjectEx($Context.TargetObject.AdsPath , $True)
foreach ($item in $propertyMap.GetEnumerator())
{
    $user.Put($item.Key, $item.Value)
}

# Build department
$department = [System.String]::Format("{0}, {1} - {2}", @($propertyMap["l"], $propertyMap["st"], $baseValue)) # TODO: modify me
$user.Put("department", $department)

# Commit changes
try
{
    $user.SetInfo()
}
catch
{
    $Context.LogMessage("An error occurred when updating user. Error: " + $_.Exception.Message, "Warning")
}

ExpandCopy code

Comments

Is it possible to pull this from a CSV file? We have 700 locations we would have to type out in the script. We could try a SQL table/database if needed but a CSV file would be better.

---

Hello,

Sure, find the script below. The Scheduled Task must be configured for the Domain-DNS object type. The domain here will be used only to trigger the script and does not define the scope of users it will executed on.

Import-Module Adaxes

$csvFilePath = "\\server\share\ImportedUsers.csv" # TODO: modify me
$userIdColumn = "DepartmentNumber" # TODO: modify me
$userIdProperty = "departmentNumber" # TODO: modify me

$domainName = $Context.GetObjectDomain("%distinguishedName%")
$importedUsers  = Import-Csv -Path $csvFilePath

foreach ($userFromCSV in $importedUsers)
{
    $userObject = @{}
    foreach ($property in $userFromCSV.PSObject.Properties)
    {
        $columnName = $property.Name
        $value = $property.Value

        # Parse special columns
        if ($columnName -ieq $userIdColumn)
        {
            $propertyName = $userIdProperty
        }
        else
        {
            $propertyName = $columnName
        }

        $userObject.Add($propertyName, $value)
    }

    # Build department
    $department = [System.String]::Format("{0}, {1} - {2}", @($userObject["l"], $userObject["st"], $userObject.$userIdProperty)) # TODO: modify me
    $userObject.Add("department", $department)

    # Check whether the user exists
    $valueForSearch = $userObject.$userIdProperty
    $userExists = Get-AdmUser -LdapFilter "($userIdProperty=$valueForSearch)" `
        -AdaxesService localhost -Server $domainName

    if ($userExists -eq $NULL)
    {
        $Context.LogMessage("User with value '$valueForSearch' in property '$userIdProperty' does not exists", "Warning")
        continue
    }

    if ($userExists -is [System.Array])
    {
        $Context.LogMessage("Found more than one user with value '$valueForSearch' in property '$userIdProperty'", "Warning")
        continue
    }

    # If user exists, update account
    try
    {
        Set-AdmUser -Identity $userExists.DistinguishedName -Replace $userObject `
            -AdaxesService localhost -Server $domainName -ErrorAction Stop
    }
    catch
    {
        $Context.LogMessage("An error occurred when updating user '$($userExists.Name)'. Error: " + $_.Exception.Message, "Warning")
    }
}

ExpandCopy code

---

thank you this worked just as we wanted. Is there a way to change an attribute across many different attributes.

ex. when using this script and changing the department number we also want the Display Name and Description to modify the department number as well.
before change: (displayName) DA 0666 Jay Klinkowsky (description) DA 0666
after change: (displayName) DA 1000 Jay Klinkowsky (description) DA 1000

The existing information should be retained and only the department Number should be modified.

---

Hello,

This can be achieved using Property Patterns. You will need to update the default values for displayName and description properties. To do so:

1. Launch Adaxes Administration Console.
2. Navigate to Configuration\Property Patterns\Builtin and select User Pattern.
3. In the Result Pane, double-click Display Name property.
   
4. Enter the following into the Generate default value field: %st% %departmentNumber% %firstname% %lastname%.
   
5. Select on creating and editing objects, click OK and save the changes.

For description property you can use the following template: %st% %departmentNumber%.

---

We cannot use the standard property pattern solution, as we have different data for each jobCode in the company.

Ideally we need to just be able to change the departmentNumber and leave the existing data.

---

Hello,

If you edit a user, only the values that were updated will change in the Display Name and Description fields according to the Property Pattern.

For example: The script we made for you updates City, State and Department properties if Department Number has changed. If the script does not change State property, it will not change in the Display Name and Description fields. However Department Number will be updated in both fields.

---

Thank you but the property pattern value is not he "st" = state that we populate it is a abbreviation of the job title. DA = Dental Assistant. So making that property pattern will not achieve the goal we are attempting. We need a way to just change the requested attribute within the description or display name field without altering the other data.

---

Hello,

The following version of the script will do the job:

Import-Module Adaxes

$csvFilePath = "\\server\share\ImportedUsers.csv" # TODO: modify me
$userIdColumn = "DepartmentNumber" # TODO: modify me
$userIdProperty = "departmentNumber" # TODO: modify me

function UpdateDepartmentNumberInProperty($string, $pattern, $departmentNumber, $userObject, $propertyName, $userName)
{
    $result = $string | Select-String -Pattern $pattern
    if ($result -eq $NULL)
    {
        $Context.LogMessage("The department number was not found in the $propertyName '$string' for user '$userName'. ", "Warning")
        return $NULL
    }

    $oldDeprtmentNumber = $result.Matches[0].Value

    $string = $string.Replace($oldDeprtmentNumber, $departmentNumber)
    $userObject.Add($propertyName, $string)
}

$domainName = $Context.GetObjectDomain("%distinguishedName%")
$importedUsers = Import-Csv -Path $csvFilePath

foreach ($userFromCSV in $importedUsers)
{
    $userObject = @{}
    foreach ($property in $userFromCSV.PSObject.Properties)
    {
        $columnName = $property.Name
        $value = $property.Value

        # Parse special columns
        if ($columnName -ieq $userIdColumn)
        {
            $propertyName = $userIdProperty
        }
        else
        {
            $propertyName = $columnName
        }

        $userObject.Add($propertyName, $value)
    }

    # Build department
    $department = [System.String]::Format("{0}, {1} - {2}", @($userObject["l"], $userObject["st"], $userObject.$userIdProperty)) # TODO: modify me
    $userObject.Add("department", $department)

    # Check whether the user exists
    $valueForSearch = $userObject.$userIdProperty
    $userExists = Get-AdmUser -LdapFilter "($userIdProperty=$valueForSearch)" `
        -AdaxesService localhost -Server $domainName -Properties "displayName", "description"

    if ($userExists -eq $NULL)
    {
        $Context.LogMessage("User with value '$valueForSearch' in property '$userIdProperty' does not exist", "Warning")
        continue
    }

    if ($userExists -is [System.Array])
    {
        $Context.LogMessage("Found more than one user with value '$valueForSearch' in property '$userIdProperty'", "Warning")
        continue
    }

    # Update Display name
    UpdateDepartmentNumberInProperty $userExists.DisplayName "(?<=.+\s)[0-9]+(?=\s.+)" $userObject.$userIdProperty $userObject "displayName" $userExists.Name

    # Update Description
    UpdateDepartmentNumberInProperty $userExists.Description "(?<=.+\s)[0-9]+$" $userObject.$userIdProperty $userObject "description" $userExists.Name

    # Update account
    try
    {
        Set-AdmUser -Identity $userExists.DistinguishedName -Replace $userObject `
            -AdaxesService localhost -Server $domainName -ErrorAction Stop
    }
    catch
    {
        $Context.LogMessage("An error occurred when updating user '$($userExists.Name)'. Error: " + $_.Exception.Message, "Warning")
    }
}

ExpandCopy code