Tactical-Tech.net

It wasn't easy figuring out how to get Powershell to play nice with AXL or the CallManager and it wasn't easy finding resources on it, so just posting this in case it helps any one out. For implementation and files, see DPD Implementation

$scriptPath = "C:PathToThisScript"

$list = import-csv "C:pathToNewLabelsNewLabels-a.csv"
$CUCMIP = "X.X.X.X"

clear

#This is to get around certificate issues

[Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}
[Net.ServicePointManager]::Expect100Continue = $false

$myCreds = Get-Credential

#GET THE WDSL FROM CUCM administrator->Applications->Plugins - it is a zip file, in it you will find the wsdl neccesary for this script to operate

$AXL = New-WebServiceProxy -Uri ($scriptPath + "AXLAPI.wsdl") -Credential $MyCreds
$AXL.Url = "https://" + $CUCMIP + ":8443/axl/"

write-host $AXL.Url

$ns = $AXL.getType().namespace

$SQLselectStr = New-Object ($ns + ".ExecuteSQLQueryReq")
$SQLDNPMUpStr  = New-Object ($ns + ".ExecuteSQLUpdateReq")
$SQLNumberUpStr  = New-Object ($ns + ".ExecuteSQLUpdateReq")
$SQLDeviceUpStr  = New-Object ($ns + ".ExecuteSQLUpdateReq")
$deviceUUID  = New-Object ($ns + ".XFkType")
$deviceReset  = New-Object ($ns + ".doDeviceResetReq")

$totalRecords = $list.Count
$iCount = 0

forEach ($item in $list) {
	$iCount = $iCount + 1
	
	$newLabel = $item.Label
	$phoneNumber = $item.Number
	$deviceName = $item.DeviceName
	
	write-host "$iCount/$totalRecords $newLabel"
	
	#Get the device UUID and Foreign Key from querying CUCM for the phone number and device name (SEP[MACaddress])
	$SQLselectStr.sql = "select d.pkid, dnpm.fkdevice
		from device as d, devicenumplanmap as dnpm, numplan as n
		where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and n.dnorpattern = '$phoneNumber' and d.name = '$deviceName'"
	$ReturnValue = $AXL.executeSQLquery($SQLselectStr)
	
	$ReturnValue.return | % {
		$deviceUUID.uuid = $_[0].innertext
		$deviceFK = $_[1].innertext
		}
				
	#Define what to update in CUCM
	$SQLNumberUpStr.sql = "update numplan	
		Set description = '$newLabel', alertingname ='$newLabel', alertingnameascii = '$newLabel'
		where dnorpattern = '$phoneNumber'"
		
	$SQLDNPMUpStr.sql = "update devicenumplanmap
		Set label = '$newLabel', display = '$newLabel', labelascii = '$newLabel', displayascii = '$newLabel'
		where fkdevice = '$deviceFK'"
		
	$SQLDeviceUpStr.sql = "update device
		Set Description = '$newLabel'
		where name = '$deviceName'"
	
	#Execute the SQL updates
	$AXL.executeSQLUpdate($SQLDNPMUpStr)
	$AXL.executeSQLUpdate($SQLDeviceUpStr)
	$AXL.executeSQLUpdate($SQLNumberUpStr)
	
	#reset the device
	
	$DeviceReset.deviceName = $deviceUUID
	$DeviceReset.ItemElementName = "deviceResetType"
	$DeviceReset.Item = "Reset"
	$AXL.doDeviceReset($DeviceReset)
	
	$SQLselectStr.sql = "select d.pkid, dnpm.fkdevice, dnpm.label, dnpm.display, dnpm.labelascii, dnpm.displayascii, n.description, n.alertingname, n.alertingnameascii
		from device as d, devicenumplanmap as dnpm, numplan as n
		where dnpm.fkdevice = d.pkid and dnpm.fknumplan = n.pkid and n.dnorpattern = '$phoneNumber' and d.name = '$deviceName'"
		
	$ReturnValue = $AXL.executeSQLquery($SQLselectStr)
	
	$ReturnValue.return | % {
		write-host $_[0].innertext
		write-host $_[1].innertext
		write-host $_[2].innertext
		write-host $_[3].innertext
		write-host $_[4].innertext
		write-host $_[5].innertext
		write-host $_[6].innertext
		write-host $_[7].innertext
		write-host $_[8].innertext
		write-host $_[9].innertext
		write-host $_[10].innertext
		}
}

write-host "done"

Using Powershell and AXL (SOAP) to update device and line descriptions