Modify VA format for AD

Question

Hi, 
 
 We are trying to create a VA with a mobile number so that a workflow is triggered and sets the number in AD. 
 
 The issue we face is the formatting of the number, see below: 
 
 Original VA: 07702874158 
 Transformed Value to set in AD: +44 7702 874158 
 
 Note: This is a made up number! 
 
 Does anyone have any ideas on how we can achieve this using the settings in the workflow options? 
 
 Thanks in advance.

Stu.Pollock · Answer

Hi infra_2020 
 
 I'm assuming you already know how to create a VA? 
 The issue you've got is how you convert the telephone number from what is entered, into the format you actually want in the native mobile attribute. 
 There is no direct OOTB conversation available, however you could do this in a number of ways. For my example I'm going to make a number of assumptions: 
 
 All telephone numbers are for UK based mobiles (therefore am not covering other countries telephone formats, nor land line formats other than where there is a cross over) 
 All telephone numbers provided are into the VA are exactly 11 numeric characters long 
 There are no special characters enter in the VA (IE no +) 
 The number entered if not already an in UK international format (IE 441111444444 or + 441111444444 ), and therefore 12 or 3 characters long. 
 
 Therefore I would 
 1. Create an Administration Policy, which controls the value of your edsvaCustomerMobile VA, which restricts the VA to only numbers and must be 11 characters long

2. Create a script module to convert your source value to the destination value, I created the below for this example, but you'd need to test it for your exact use case, and add any error handling etc etc. 
 Function Covert-Mobile($Request)
{
 $CountryCode = "+44"
 $Attribute = "edsvaCustomerMobile"
 $Length = 11
 $Return $null
 $AreaCode = $null
 $Number = $null
 
 $Value = $Request.Get($attribute)
 
 If($Value)
 {
 If($Value.length -eq $Length)
 {
 $AreaCode = $Value.Substring(1,4)
 $Number = $Value.Substring(5,6)
 
 $Return = [string]::Format("{0} {1} {2}",$CountryCode,$AreaCode,$Number)
 $EventLog.ReportEvent($Constants.EDS_EVENTLOG_WARNING_Type,"$Attribute is $Length, return `"$Return `"")
 }
 Else
 {
 $EventLog.ReportEvent($Constants.EDS_EVENTLOG_WARNING_Type,"$Attribute is not $Length, return `"$Return `"")
 }
 
 }
 Else
 {
 $EventLog.ReportEvent($Constants.EDS_EVENTLOG_WARNING_Type,"$Attribute is blank, return `"$Return `"")
 }
 
 Return $Return
}

} 
 2. Create workflow(s) for create/update of the edsvaCustomerMobile VA, where you modify the request

Then update the Mobile attribute with a value generated by the script above

Which you'd select by choosing "Value generated by rule expression" 
 
 Then from the "Add entry" drop down, select "Value generated by script" 
 
 Then select your script, and the function in the script it uses:

Endpoint Privilege Management

Modify VA format for AD

Top Replies