CDR & Spreadsheets… 5 things to know!
Cisco Call Detail Records (CDR) have a lot of data, very overwhelming if you ask me, and I have over 12 years of Call Analytics experience. A CDR is a comma delimited file that can easily be opened in a spreadsheet, but you’ll quickly realize how much data there is and how difficult it can be interpreting the call data this way. Depending on the CUCM version you’re running there are around 130 different fields or columns!
Here are 5 things you need to know:
1. Date and Time are listed in Unix Time Format or Epoch as commonly known. Simply put, it’s not easy to read without first doing some calculations. Epoch Time is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT) and of course not counting leap seconds… Who wants to calculate that… ¯\_(ツ)_/¯
2. There is NO ring time! If you need to find out how long a call rang before it was answered you’ll need to do more calculations. Look for the “dateTimeOrigination” and “dateTimeConnect” fields, once you find them simply subtract and you’ll have the ring time in seconds.
3. If you’re looking to find out what internal resource answered a call start by tracking down the “finalCalledPartyNumber”, “destDeviceName” and in some cases “finalCalledPartyUnicodeLoginUserID” fields. Note, important pieces of information to better identify a user like First Name, Last Name, Managers,Departments or other Organizational Units are missing from CDR. Device Pool, Device Type, Device Description and Locations are other valuable pieces of information that you may need…. but sadly these are also missing from CDR.
4.Most worksheets have a maximum row limit of around 1 Million. This means that if your CUCM services more than 150 devices and each device makes around 20 calls per day and you need to report against all the calls in a one year time period a worksheet won’t be able to display all the information.
5.The most important thing to know is that Variphy deploys in as little as 15 minutes. Have complete control of your CDR!
Oh my goodness! Amazing article dude! Thank you so much, However I am encountering difficulties with your RSS. I don’t understand the reason why I can’t join it. Is there anybody else having the same RSS issues? Anybody who knows the answer will you kindly respond? Thanx!
While posing as her own helper whereas hiding his face from her thoughts, Qimir attempts to execute Mae after she elects to betray him, slaughtering the squad of Jedi who had searched for her across the galaxy, before looking after Mae’s unconscious twin Osha.
I’m impressed, I must say. Rarely do I encounter a blog that’s both educative and engaging, and without a doubt, you’ve hit the nail on the head. The issue is something too few people are speaking intelligently about. I am very happy that I came across this during my search for something relating to this.
A customized desk with LED lighting, ergonomic chairs with character-themed upholstery, and a number of screens showcasing anime wallpapers can create an immersive gaming expertise.
2023-05-27 Kodak Black & NLE Choppa feat.
Aw, this was a very nice post. Finding the time and actual effort to create a top notch article… but what can I say… I procrastinate a lot and don’t manage to get nearly anything done.
Noha-A Joo is a brand new scholar at Amityville Highschool.
May I simply say what a relief to find a person that really understands what they are talking about on the internet. You certainly know how to bring a problem to light and make it important. More and more people need to look at this and understand this side of the story. I can’t believe you are not more popular because you definitely possess the gift.
I enjoy reading through an article that can make men and women think. Also, thank you for permitting me to comment.
Sons of Abraham 18 November 2013 2.Zero Sons of Abraham offers further depth to the three Abrahamic faiths: Christianity specifically, but also added some content material for Muslims and the Jewish religion.
Immigration Lawyers… […]the time to read or visit the content or sites we have linked to below the[…]…
Hi, I believe your website may be having web browser compatibility problems. Whenever I take a look at your website in Safari, it looks fine however, when opening in I.E., it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Aside from that, fantastic site!
This is a really good tip especially to those fresh to the blogosphere. Short but very precise information… Thanks for sharing this one. A must read post.
Hello! I recently would choose to give a huge thumbs up with the great info you’ve got here with this post. We are coming back to your site to get more soon.
This is really important, You’re a remarkably expert article author. I’ve joined with your feed and also count on reading your excellent write-ups. In addition to that, I’ve shared your websites inside our web pages.
This is a topic that is close to my heart… Take care! Where are your contact details though?
There a few fascinating points with time in this article but I do not know if I see all of them center to heart. There is certainly some validity but I will take hold opinion until I explore it further. Good article , thanks and that we want more! Put into FeedBurner too
I was able to find good advice from your content.
Oh my goodness! Amazing article dude! Many thanks, However I am going through issues with your RSS. I don’t know the reason why I am unable to join it. Is there anybody else getting identical RSS issues? Anyone that knows the answer will you kindly respond? Thanks.
I like reading a post that will make men and women think. Also, many thanks for allowing for me to comment.
Friday Night Lights is a great tv series, i love the game and i love the story::
Greetings! I know this is kinda off topic but I’d figured I’d ask. Would you be interested in trading links or maybe guest authoring a blog article or vice-versa? My site addresses a lot of the same subjects as yours and I believe we could greatly benefit from each other. If you are interested feel free to send me an e-mail. I look forward to hearing from you! Wonderful blog by the way!
After study few of the articles on your blog these days, and that i like your manner of blogging. I tag it to my favorites internet site list and will be checking back soon. Please visit my web site too and let me recognize your thought.
I’m impressed, I have to admit. Really rarely must i encounter a weblog that’s both educative and entertaining, and let me tell you, you have hit the nail around the head. Your thought is outstanding; the thing is an issue that inadequate people are speaking intelligently about. My business is delighted i always stumbled across this within my find something relating to this.
When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several e-mails with the same comment. Is there any way you can remove people from that service? Thanks a lot!
I am interested in looking for more of such topics and would like to have further information. Hope to see the next blog soon.
Hi! I simply would like to offer you a big thumbs up for your excellent info you have here on this post. I am coming back to your blog for more soon.
The post is definitely nicely written but it contains many useful facts. I am just ready to find your distinguished way of writing the post. So now you make it easy for me to learn and implement. Nice one for sharing around.
I have to express my appreciation for your generosity in support of women who really want help on in this concern. Your personal commitment to getting the message around appeared to be especially beneficial and have specifically made regular people like me to attain their endeavors. The interesting help signifies a lot to me and much more to my fellow workers. Thanks a ton; from each one of us.
Your writing is fine and gives food for thought. I hope that I’ll have more time to read your articles . Regards. I wish you that you frequently publish new texts and invite you to greet me
Your style is really unique compared to other people I’ve read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this web site.
As a Newbie, I am always exploring online for articles that can aid me. Thank you
I needed to send you one very little remark just to thank you so much once again about the superb information you have contributed above. It is remarkably generous with people like you to present freely exactly what a few people could possibly have made available as an ebook in making some bucks for their own end, notably considering that you might have tried it in case you desired. The pointers as well worked to provide a easy way to know that most people have the same zeal just as my personal own to see whole lot more with regards to this problem. I’m certain there are a lot more fun moments in the future for many who looked at your blog.
It’s perfect time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I want to suggest you few interesting things or advice. Perhaps you could write next articles referring to this article. I desire to read more things about it!
This is the best drug film I have seen in a while.
I was on FaceBook looking for heat press forum, when I found a link to this blog, glad I stopped by!!! Thanks!!!!
The next time I read a blog, I hope which it doesnt disappoint me up to this blog. I mean, I know it was my option to read, but I personally thought youd have something fascinating to state. All I hear is often a handful of whining about something that you could fix if you werent too busy interested in attention.
Pretty! This was an extremely wonderful post. Thanks for providing this information.
It is best to take part in a contest for top-of-the-line blogs on the web. I’ll recommend this website!
I was trying to find this. Really refreshing take on the information. Thanks a lot.
howdy, I’ve been havin a tough time attempting to rank well for the words “victorias secret coupon codes”… Pls approve my comment!!
I don’t normally comment but I gotta tell regards for the post on this amazing one : D.
Nice one for discussing the knowledge. I recently uncovered the info tremendously valuable.
As I website possessor I believe the subject material here is rattling fantastic , appreciate it for your efforts.
noutati interesante si utile postate pe blogul dumneavoastra. dar ca si o paranteza , ce parere aveti de cazarea in regim hotelier ?.
Howdy! I know this is kind of off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having difficulty finding one? Thanks a lot!
Good post. I study one thing tougher on totally different blogs everyday. It can all the time be stimulating to learn content from different writers and observe a bit of something from their store. I’d favor to use some with the content material on my weblog whether or not you don’t mind. Natually I’ll offer you a link on your web blog. Thanks for sharing.
Shortly before his first loss of life, Palpatine had sent a psychic command by the Force to Mara Jade, planting in her the need to kill Luke.
Spot on with this write-up, I seriously feel this web site needs a great deal more attention. I’ll probably be returning to read through more, thanks for the information!
Information collected on 23 April 2017 confirmed that not less than 42 of users on that day had activated at least one mod.
Beautiful blues — cobalt and turquoise — proceed the water picture and add depth to the scene.
i am very picky about baby toys, so i always choose the best ones;
I don’t usually comment but I gotta state thanks for the post on this great one : D.
polo shirts are very casual and stylish indeed, most of the time i use polo shirts.,
It’s difficult to acquire knowledgeable individuals about this topic, and you sound like what happens you’re speaking about! Thanks
A powerful share, I simply given this onto a colleague who was doing a little bit analysis on this. And he the truth is bought me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the deal with! But yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love studying extra on this topic. If possible, as you turn into expertise, would you mind updating your blog with extra details? It is highly helpful for me. Big thumb up for this blog submit!
I discovered your blog site internet site on yahoo and appearance a number of your early posts. Preserve within the great operate. I recently additional up your Rss to my MSN News Reader. Looking for forward to reading more by you at a later date!…
I enjoy reading an article that can make people think. Also, many thanks for allowing for me to comment.
Congratulations on having one of the most sophisticated blogs Ive come across in some time! Its just incredible how much you can take away from anything simply because of how visually beautiful it’s. Youve put collectively a great blog space –great graphics, videos, layout. This is unquestionably a must-see blog!
I believe you have mentioned some very interesting points , thankyou for the post.
Youre so cool! I dont suppose Ive read anything similar to this just before. So nice to uncover somebody with some original thoughts on this subject. realy appreciate beginning this up. this fabulous website are some things that is needed online, a person with a bit of originality. beneficial project for bringing new things to your net!
I always was concerned in this subject and still am, thankyou for putting up.
You may get started with a brief announcement of the occasion at your web site.
Way cool! Some very valid points! I appreciate you penning this post plus the rest of the website is really good.
NL Pitchero reviews that “Boreham Wood have announced that lengthy-standing Academy Director and first-workforce assistant-manager Luke Garrard, has been promoted to first-staff supervisor following Ian Allinson’s current departure. Garrard’s appointment is just not felt by chairman Danny Hunter to be both a gamble or a rushed appointment, as he has been instrumental in each the first-team and academy’s success stories over the last eight seasons. He has also performed a fantastic job in helping Allinson during the last three years and has improved not only our coaching provision but the organisation throughout the board. With Garrard and Junior Lewis already overseeing the brand new daily training programme in regards to the first-staff squad, that is an appointment that will not disrupt the club`s stability and one that rewards Garrard’s potential, arduous work and loyalty. Hunter mentioned, ‘I’ve had great success at the membership in recent times with our coverage of selling from within. Luke has been a profitable player here, a profitable coach here, a profitable academy director right here and a profitable assistant supervisor here. In reality I’ve mentored him for many years, knowing that the day would come for him to ultimately handle this club and that day is now here'”.
I couldn’t resist commenting. Exceptionally well written!
Following their marriage they made their home at Erick.
After looking at a number of the blog posts on your blog, I truly appreciate your way of blogging. I bookmarked it to my bookmark webpage list and will be checking back in the near future. Take a look at my web site as well and let me know your opinion.
Hey this is exactly a really excellent content. Terrific discuss. I’ll talk about this suggestions with all of my girlftriend!
You get the typical humor involving Ferrell being kicked on for being a nerd but you also get a nice running gag of every hot woman wanting his body.
Thanks for the good writeup. It in reality used to be a enjoyment account it. Glance complex to more introduced agreeable from you! However, how can we communicate?
Hi, i think that i saw you visited my weblog so i came to “return the favor”.I am trying to find things to improve my site!I suppose its ok to use a few of your ideas!!
Your blog does not display correctly on my iphone – you might wanna try and repair that
I love the valuable info you supply in your posts. Do you still feel this way?
Hello there! This blog post could not be written much better! Looking through this post reminds me of my previous roommate! He continually kept preaching about this. I will send this information to him. Fairly certain he’ll have a great read. Thank you for sharing!
I need to to thank you for this wonderful read!! I definitely loved every little bit of it. I have got you bookmarked to check out new stuff you post…
Everyone loves it when people get together and share thoughts. Great website, keep it up.
I wanted to thank you for this wonderful read!! I absolutely loved every bit of it. I have you book marked to look at new stuff you post…
An impressive share, I recently given this onto a colleague who has been performing a small analysis with this. And then he in reality bought me breakfast simply because I found it for him.. smile. So i want to reword that: Thnx with the treat! But yeah Thnkx for spending enough time to discuss this, I feel strongly regarding it and adore reading read more about this topic. If it is possible, as you become expertise, would you mind updating your blog site to comprehend details? It can be extremely useful for me. Big thumb up with this article!
Greetings! Very useful advice in this particular post! It’s the little changes which will make the biggest changes. Thanks for sharing!
Nice post. I find out something tougher on diverse blogs everyday. It will always be stimulating to learn content from other writers and rehearse a little from their site. I’d prefer to apply certain while using content on my small blog regardless of whether you don’t mind. Natually I’ll provide link on the internet weblog. Thank you for sharing.
Regards for this post, I am a big big fan of this internet site would like to keep updated.
Very good information. Lucky me I found your website by chance (stumbleupon). I’ve bookmarked it for later.
There’s noticeably a bundle to know about this. I assume you made certain good factors in features also.
Bute made the choice secretly to grant the request, not even informing Benjamin Franklin; he supposed the place as a reward for Benjamin’s position and a transfer to weaken the Penn faction.
We keep your page. Watch it offline again soon. Very interesting article.
An interesting discussion may be valued at comment. I do believe that you can write much more about this topic, it will not certainly be a taboo subject but usually people are insufficient to speak on such topics. An additional. Cheers
Evelyn Fewings. For companies to the Neighborhood in Tiverton, Devon.
When I initially left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and from now on every time a comment is added I receive four emails with the exact same comment. Is there a way you are able to remove me from that service? Thanks.
Pretty! This was a really wonderful post. Thank you for providing these details.
You might imagine that this is a fairly useless characteristic, however do not be misguided!
I was able to find good information from your blog articles.
This excellent website really has all of the information I needed concerning this subject and didn’t know who to ask.
You’re so cool! I don’t believe I have read a single thing like this before. So great to discover somebody with some original thoughts on this topic. Seriously.. thank you for starting this up. This web site is something that’s needed on the internet, someone with some originality.