python logic to parse out and append perfMon data

[dedwards16@bloomberg.net]

Hi - can someone help me figure this out - I have the following python logic that I'm using to connect to UCM and execute perfMon api. I do get back some xml but cant seem to parse out, for example the various child values.

Request=requests.post(url,data=soaprequest,verify=False,auth=HTTPBasicAuth('UserName','password@' ))
root = ET.fromstring(Request.text)
print (Request.text)

samplePerfMon = {'perfmonCollectCounterDataResponse': 'http://schemas.xmlsoap.org/soap/envelope/',
'perfmonCollectCounterDataReturn': 'http://schemas.cisco.com/ast/soap'}

for data in root.findall('perfmonCollectCounterDataResponse:perfmonCollectCounterDataReturn', samplePerfMon):
result = data.find('perfmonCollectCounterDataResponse:Name', samplePerfMon)
print (result.text)

##so at this point I get some xml back as follows:

<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><ns1:perfmonCollectCounterDataResponse xmlns:ns1="http://schemas.cisco.com/ast/soap"><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AnnunciatorOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AnnunciatorResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AnnunciatorResourceAvailable</ns1:Name><ns1:Value>192</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AnnunciatorResourceTotal</ns1:Name><ns1:Value>192</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AuthenticatedCallsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AuthenticatedCallsCompleted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AuthenticatedPartiallyRegisteredPhone</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\AuthenticatedRegisteredPhones</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\BRIChannelsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\BRISpansInService</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\CallManagerHeartBeat</ns1:Name><ns1:Value>675970</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\CallsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\CallsAttempted</ns1:Name><ns1:Value>17798</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\CallsCompleted</ns1:Name><ns1:Value>17116</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\CallsInProgress</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\CumulativeAllocatedResourceCannotOpenPort</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\EncryptedCallsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\EncryptedCallsCompleted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\EncryptedPartiallyRegisteredPhones</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\EncryptedRegisteredPhones</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\ExternalCallControlEnabledCallsAttempted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\ExternalCallControlEnabledCallsCompleted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\ExternalCallControlEnabledFailureTreatmentApplied</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\FXOPortsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\FXOPortsInService</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\FXSPortsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\FXSPortsInService</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\HWConferenceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\HWConferenceCompleted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\HWConferenceOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\HWConferenceResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\HWConferenceResourceAvailable</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\HWConferenceResourceTotal</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\HuntListsInService</ns1:Name><ns1:Value>8</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\IVROutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\IVRResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\IVRResourceAvailable</ns1:Name><ns1:Value>192</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\IVRResourceTotal</ns1:Name><ns1:Value>192</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\InitializationState</ns1:Name><ns1:Value>100</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\LocationOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MCUConferencesActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MCUConferencesCompleted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MCUHttpConnectionErrors</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MCUHttpNon200OkResponse</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MCUOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MOHMulticastResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MOHMulticastResourceAvailable</ns1:Name><ns1:Value>1000000</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MOHOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MOHTotalMulticastResources</ns1:Name><ns1:Value>1000000</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MOHTotalUnicastResources</ns1:Name><ns1:Value>1000</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MOHUnicastResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MOHUnicastResourceAvailable</ns1:Name><ns1:Value>1000</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MTPOutOfResources</ns1:Name><ns1:Value>1088</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MTPRequestsThrottled</ns1:Name><ns1:Value>216</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MTPResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MTPResourceAvailable</ns1:Name><ns1:Value>96</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\MTPResourceTotal</ns1:Name><ns1:Value>96</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\NumberOfPushErrorResReceived</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\NumberOfPushReqSent</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\NumberOfPushResReceived</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\PRIChannelsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\PRISpansInService</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\PartiallyRegisteredPhone</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\RegisteredAnalogAccess</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\RegisteredHardwarePhones</ns1:Name><ns1:Value>15</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\RegisteredMGCPGateway</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\RegisteredOtherStationDevices</ns1:Name><ns1:Value>127</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPLineServerAuthorizationChallenges</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPLineServerAuthorizationFailures</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPTrunkApplicationAuthorizationFailures</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPTrunkApplicationAuthorizations</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPTrunkAuthorizationFailures</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPTrunkAuthorizations</ns1:Name><ns1:Value>51</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPTrunkServerAuthenticationChallenges</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SIPTrunkServerAuthenticationFailures</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SWConferenceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SWConferenceCompleted</ns1:Name><ns1:Value>2122</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SWConferenceOutOfResources</ns1:Name><ns1:Value>76</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SWConferenceResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SWConferenceResourceAvailable</ns1:Name><ns1:Value>192</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SWConferenceResourceTotal</ns1:Name><ns1:Value>192</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\SystemCallsAttempted</ns1:Name><ns1:Value>4054</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\T1ChannelsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\T1SpansInService</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\TLSConnectedSIPTrunks</ns1:Name><ns1:Value>6</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\TLSConnectedWSM</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\TranscoderOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\TranscoderRequestsThrottled</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\TranscoderResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\TranscoderResourceAvailable</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\TranscoderResourceTotal</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\UnEncryptedCallFailures</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBConferencesActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBConferencesAvailable</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBConferencesCompleted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBConferencesTotal</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBOutOfConferences</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBResourceAvailable</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VCBResourceTotal</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VideoCallsActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VideoCallsCompleted</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VideoOnHoldOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VideoOnHoldResourceActive</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn><ns1:perfmonCollectCounterDataReturn><ns1:Name>\\10.17.2.200\Cisco CallManager\VideoOutOfResources</ns1:Name><ns1:Value>0</ns1:Value><ns1:CStatus>1</ns1:CStatus></ns1:perfmonCollectCounterDataReturn></ns1:perfmonCollectCounterDataResponse></soapenv:Body></soapenv:Envelope>

##i would like to extract data for each field, for example the Name/Number and its associated CallsQueued, LineGroupMembersAvailable, QueueCallsAbandoned

[Seb Rupik]

Hi there,

You could regex the XML for the values you want:

import re

REGEX_STR = (<ns1:perfmonCollectCounterDataReturn>).*(CiscoCallManager\\{0}</ns1:Name><ns1:Value>)(?P<value>\d*).*?(</ns1:perfmonCollectCounterDataReturn>)

targets = ["CallsQueued", "LineGroupMembersAvailable", "QueueCallsAbandoned"]

for target in targets:
    match = re.search(REGEX_STR.format(target), result.text)
    if match:
        print("The value for {0} is: {1}".format(target, match.group["value"])

...written and tested in notepad, but should work! :)

Paste it after your final print statement. Incidentally the attributes you listed "CallsQueued, LineGroupMembersAvailable, QueueCallsAbandoned" don't actually appear in the XML output.

cheers,

Seb.

[dstaudt]

ETree is a helpful package for Python XML parsing, but is probably outside the scope of the support in this forum.  A tutorial like this might be a good place to start learning about it: https://lxml.de/tutorial.html

We've found that the Python Zeep library makes working with CUCM SOAP APIs (like Serviceability Perfmon) fairly easy - especially as you can create and parse the request/response objects as Python objects.  Here is a set of samples, which includes one showing how to use <perfmonCollectCounterData> with Zeep: https://github.com/CiscoDevNet/serviceability-python-zeep-samples/

[dedwards16@bloomberg.net]

Thanks Dave and Seb! I'll research both and report back here with results.

[dedwards16@bloomberg.net]

The provided solution works! Thanks much!

[dedwards16@bloomberg.net]

Hi - thanks for the suggestions. I tried the code located here - https://github.com/CiscoDevNet/serviceability-python-zeep-samples/blob/master/perfmonPort_collect_counter_data.py

It works when retrieving  the Cisco CallManager object, but fails when retrieving the Cisco Hunt Pilots object - with error:

InsecureRequestWarning: Unverified HTTPS request is being made. Adding certificate verification is strongly advised.

Any thoughts? 

Thanks much!

[dstaudt · Accepted solution]

The message shown is a warning (vs. an error) re HTTPS certificate validation - it should not prevent processing or otherwise interrupt the script.  There should be some comments in the source about how to properly implement CUCM HTTPS cert checking (which you'll want to do in production.)

You might try setting 'DEBUG = True' in the code to see the request/response as they occur - perhaps you are getting an empty data set back..?