Calculating quarterly/annual recorded call minutes

[DancingDave]

Hi, has anyone ever calculated the number of minutes that they record over a quarter or a year?

I thought about looking at the number of DATs we used, however, we run a variety of DAT types (DDS2 to DDS4) for archiving and use a variety of compressions on our loggers (ca. 3400 channels over six sites), so that method would be a bit convoluted.

My initial thought was to query the CLS, but as a customer, we don't have direct access to the Nice databases. If anyone had an idea of the query to run (or a schema for the database), we could ask the vendor to do a 'value add'

I also thought about looking at the activity on the channels for each of the loggers, but this would only give me 24 hour activity.

Alternatively, if anyone had any other ideas, I'd be delighted to hear from you.

Cheers

DD

 

[biglebowski]

i used to have a script that would count the calls during a set time period but you would need access to the cls and query analyser. I'll see if i've got it written down at home this evening.

Are you suggesting coconuts migrate?

 

[mikeyb123]

why do you not have access to the nice database?

we do via either sql enterprise manager or any kind of Odbc compliant app

It's not getting any smarter out there. You have to come to terms with stupidity, and make it work for you.

 

[DancingDave]

It's a managed service and the support contract doesn't allow for it unfortunately. Quite frustrating at times, but on balance, probably best!

 

[denazn]

You should be able to query as much as you want on the database, as long as you don't make any modifications (for obvious reasons). There are many people who use Crystal Reports, Business Object and other reporting applications that query the NICE database to get information they want.

Anyways, in relation to the question, you can probably do a sum of duration for the dates you want (it is broken down to one call table per month). You will just need to exclude D records under CLS flags (this is a system generated call record to "link" calls together), and any calls that have recorded=N in the database. That should give you a pretty good idea of your duration.

 

[randyb19]

Which database or data source should I be connecting to produce reports?

 

[codenerd100]

In the NIC_CLS database, each month has it's own table. In SQL Enterprise Manager, look for the tables named something like: NICE_Calls_001, 002, 003, etc. Just run a top ten query on each table until you find the month you want. Look at the start_date field to determine which month of calls it's storing.

 

[biglebowski]

to count the calls use the following.

select count * from NICE_CLS_CALLS_xxxx

That rug really tied the room together, did it not?

 

[AlmostMe]

I don't think that will give a real count. Each record has a minimum of two indexes, one for teh current call segment and 1 for the parents call segment. Without putting a lot of thought into it you would probably need to do a count of distinct parent call id's. Not sure if this would be right though without taking more time to think about it.