cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
994
Views
2
Helpful
9
Replies

Device reports

Hello,

Dose anyone know where CUCM stores the registered devices reports, the that you can get from risdb.

What I would like to get is a report of registered devices form 1 hours ago, 3 hours ago and so on.

How can this information be obtained?

Thanks!

9 Replies 9

npetrele
Cisco Employee
Cisco Employee

You'd probably have to poll the database on a regular basis and your app could figure out what devices were registered and when.  You could use RisPort, or you can get information from the registrationdynamic table. Here's a row from that table to give you an idea of what info you can find:

            <row>

               <pkid>1e56bd91-4737-4ca6-ae3a-bf4fd61513fe</pkid>

               <lastknownipaddress>10.99.136.214</lastknownipaddress>

               <lastknownucm/>

               <fkdevice>6b62beb6-c6c1-d614-76e0-c407ca72cb8a</fkdevice>

               <datetimestamp>1481067359</datetimestamp>

               <lastknownconfigversion/>

               <locationdetails>UNIDENTIFIED</locationdetails>

               <tkendpointconnection>2</tkendpointconnection>

               <portorssid>blizzard</portorssid>

               <lastseen>1481067360</lastseen>

            </row>

Thanks for the answer.

Cucm already stores this information I think. How is it building the reports from Serviceability, this is what I would like to find out.

Thanks!

I honestly don't know.  I don't have access to the code it uses to generate reports.  I suspect it's polling and keeping track of things like the timestamps. 

I'll ask around to see if anyone is more familiar with reporting than I am.

I see you posted this question in Reports.  You might get a better answer there.

You're talking about Prime Collaboration Reports, right?  PCA Reports?

Cisco Prime Collaboration Assurance Guide - Advanced, 10.0 - Prime Collaboration Reports [Cisco Prime Collaboration] - C…

Let me know so I can direct my questions to the right people.

I am referring to Serviceability Reports Archive.

That show up in CUCM only for the past day, these reports are build somehow and what I would like to find out is where is this information stored and how can we pull it.

Thank you,

Okay, I asked an engineer, but it seems to me that all you'd have to do is run RisPort's selectCMDevice periodically and keep track of registered devices that way.  Store the values in your personal database, and generate your own reports.

Do you know of any options of getting this information from pub only? No meatter the way.

Yes, you can specify the node you want to query with selectCMDevice.  For example, this selects all Registered devices on the node identified by IP address:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soap="http://schemas.cisco.com/ast/soap">

   <soapenv:Header/>

   <soapenv:Body>

      <soap:selectCmDevice>

         <soap:StateInfo></soap:StateInfo>

         <soap:CmSelectionCriteria>

            <soap:MaxReturnedDevices>200</soap:MaxReturnedDevices>

            <soap:DeviceClass>Phone</soap:DeviceClass>

            <soap:Model>255</soap:Model>

            <soap:Status>Registered</soap:Status>

            <soap:NodeName>10.194.104.60</soap:NodeName>

            <soap:SelectBy>Name</soap:SelectBy>

            <soap:SelectItems>

               <!--Zero or more repetitions:-->

               <soap:item>

                  <soap:Item>*</soap:Item>

               </soap:item>

            </soap:SelectItems>

            <soap:Protocol>Any</soap:Protocol>

            <soap:DownloadStatus>Any</soap:DownloadStatus>

         </soap:CmSelectionCriteria>

      </soap:selectCmDevice>

   </soapenv:Body>

</soapenv:Envelope>

See:  Cisco DevNet: sxml - API Reference - Real-Time Information (RisPort)

Thank you,

This is not really ok with 35000 users/devices. To much overhead.

This is one of the reason I think the reports are the best/easiest way to go.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: