Does VNQM store CDR records long term?

Question

We're currently looking into getting a solution that will keep our CDR records long term, for reporting purposes.

This would be especially useful for Call Centers, heavy users, departments, etc.

Does VNQM currently store Cisco CDR records long term?

I only see that I can look up calls for "Last 30 days"...

In addition, I would love to pull out report/graph based on certain phone numbers (or clusters of numbers - like a call center), and display call volume by HOUR of day or by DAY of week.

FormerMember · Answer

Well, you can create monthly reports and schedule it to be emailed to certain email box and keep it there for as long as you need to. Each month will go to that email box, so you can go back at any time. Yes, it is a hassle to go via diff files for each month, but you easily can join them if you decide so in a single file. A bit more work but it is a work around.

rkrvaric · Answer

Well, we're a Community College system, and there are many people asking for historical data long after the fact..

* We have our own Police for example... * Suddenly captain has wanted to map our where most calls came from... we only have less than 30 days of data. 
* Or see how many times calls were received from a specific garage blue-light emergency phone in the past X months.

* Different departments want to see call volume...

Every campus/school has their own Financial Aid dept, Registration dept, Admissions dept.

We're unable to pull up historical data on how many people have called the respective numbers at each school/campus to justify Call Center calculations, increase in head count, etc...

* Quarterly billing of international/long distance calls to departments
* Abuse of phone use, excessive personal usage, etc
* If I already have all my devices in Solarwinds... the mapping of the calls looks pretty cool (I'm a very visual person).

This is not data that needs to be instantly, superfast available... But we'd like to be able to go back and see a full, long-term picture of what calls have been made/received.

As you can imagine, in a government institution, the wheels turn very slow.

Call Quality problems are usually investigated within the first 2-3 weeks.

Currently, we generate about 300 Megs of CDR records per WEEK (busy week) - so, I would guess about 1GB of CDR (Not CMR records) per month.

The week of Jan 13-20 was CDR: 284MB, CMR: 116MB

michal.hrncirik · Answer

Hi,

31 days is maximum history we store for CDRs. VNQM is currently designed to quality troubleshooting rather than capacity planning, billing or long term quality reporting. The problem is technology, not the reason that we would be intentionally blocking historical data.

MS SQL can't handle well so many records and then search fast by multiple condition. We are working now on special indexing search engine that should solve this problem long term. but I don't think you may expect that from VNQM in 2014.

Is the phone traffic (long term) major info you want to get? If so, what is the use case for this (cost?). More specific use case would help us to understand your problem and design search engine by the right way,