Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Pulling simple reports from CUCM 6.1(2) - RTMT ?

Hi all,

I used to use a plethora of SQL queries on our old CCM 3.3 to pull off reports on a monthly basis for things such as VGC details, IP Comm accounts, users with Extension Mobility etc.

Obviously v6.1 uses an Infomix (sp?) db not SQL. Is it possible to use RTMT to pull off detail for simple reports? I only need simple data such as VGC phone numbers and descriptions, users who use Ext Mob and their descriptions and numbers etc.

Thoughts appreciated.

EDIT - i have noticed that there is a plugin that might be of use? "Cisco CallManager AXL SQL Toolkit". Does this allow SQL queries to be run in the same fashion as was possible on v3.3?

11 REPLIES
New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

Also interesting in this question

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

The main "CDR Reporting" tool within "CM Serviceability" will allow me to view CDR and CAR data for users (numbers dialled etc). But im still struggling to find an easy way to pull off more basic data like i used to do in SQL Query Manager on the older Windows based CallManager v3.3

All i need is to report on the use of VGC devices, their numbers and decriptions. Simple stuff like that into a .csv file really.

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

I understand you are not looking for traffic reports in the VGC devices but just the numbers and descriptions...try this

Bulk Administration --> Phones --> Generate Phone Reports --> Find phones where --> Device Type = Scroll down list to select Cisco VGC Phone --> Find --> Next --> Select the Device fields and Line fields that you want in the report --> click Submit

Go to Bulk Administration --> Job Scheduler--> check if job is completed

Go to Bulk Administration --> Upload/Download files --> Click Find --> select and download your file.

It's in TXT format but it is comma separated, so you can import it in exchange to get a descent report...

hope this helps

:JoeL

pls rate useful posts

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

Thanks Joel - will give this a go.

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

i meant to say import the .csv to excel...not exchange...typo

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

You see, without the typo you would have got a 5 ! :o) [Joking]

I've had a play with the reports and they seem perfect. More options than the old SQL ones tbh. Thanks Joel !

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

My boss siad that he want see everyday new file (up to date) with all phones there. In CCM 4 I could do this with export MSSQL into txt.

How I can do this in CUCM?

I can use Job Scheduler but how I can AUTOMATIC download needed data from CUCM?

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

go to Cisco Unified Serviceability --> Tools --> Serviceability archive --> It shows RTMT reports by month --> click month --> shows Daily reports --> click yesterday's date --> there are various reports --> DeviceRep _mm_dd_yyyy.pdf shows you a graph of registered phones --> this may help

I don't know if there needs to be some configuration done or not...let me know if it works...

:JoeL

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

Thanks for this great tip.  I was pulling my hair out to figure where my reports where.  Cisco help was no help.

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

glad to help

:JoeL

New Member

Re: Pulling simple reports from CUCM 6.1(2) - RTMT ?

Hi JoeL,

One more question.  I need list of IP addresses as well with my report.  I've tried the hidden URL https://myserverIP/CCMAdmin/reports/devicelistx and I get


type Status report

message /CCMAdmin/reports/devicelistx

description The requested resource (/CCMAdmin/reports/devicelistx) is not available.

Is there any other way to display IP addreses with the phone report in CCM

System version: 6.1.2.1000-13
Thanks for any info that you can provide.

964
Views
9
Helpful
11
Replies
CreatePlease to create content