Populate a multi-valued active roles sync

Question

Hello ARS Experts, I have a need to create a virtual multi-valued attribute and have it populated from a database. I use ARS Synchronization to sync some values already from this table but this new one I'm not sure if it is possible. 
 The SQL column will contain something like one;two;three. How can I populate the multi-valued virtual attribute properly to have each one of the values delimited in the column from the DB? 
 Thanks for any help in advanced. 
 Lu

lrigs · Accepted Answer

Hi All, I've got this figured out. Although I've not ran it for a large amount. Still waiting on the data to be calculated for what we need. My only worry is the system being overloaded if we have 40k or some employees to update. 
 If anyone has information on how to optimize or make this not overload, please let me know. 
 Thank you, 
 Lu 
 
 $string = $srcObj["dbColumn"]
$dbColumns = $string.Split(",")
$return = @()
ForEach ($value in $dbColumns)
{
	$return = $return + $value
}
$return

Endpoint Privilege Management

Populate a multi-valued active roles sync

Top Replies