Before you find anything else wrong--yes, you'll need to filter for blank records, gateway, etc. I was trying to give jed5 direction and options rather than writing a complete solution in my response. ... View more

True. Although the only time this won't work is when our time range spans a year-change. Since even "10/27/2011 23:40" < "10/28/2011 01:24" is true in alphanumeric comparison. And yes, the time range picker needs to be big enough to include all records that might potentially cross that instant of time in question. Again, quick and dirty and without the benefit of helper apps... ... View more

Since dateTimeConnect and dateTimeDisconnect only show up in CMR/cdrRecordType=1 records, by default CDR records are not counted. I actually anticipate this might undercount some, depending on conference calls and transfers but then there is some debate about how those should be counted for concurrency. Either way, this way counts it consistently--and consistency is basis of accurate reporting. As I mentioned about, without the availability of something like sideviewapps, the above query gets the job done. ... View more

I've put a request in to purchase Nick's app, and it's going through the corporate beaucracy so--possibly by this time next year--we'll have it in place 😐 In the meantime, without the assistance of sideviewapps... to get a count of calls happening at a specific time, you just need to count CDR records with dateTimeConnect < 3:48 and dateTimeDisconnect > 3:48 I use this for a quick count and list of calls at a specific time. Copy and paste this into your search window: [your--index--or--sourcetype--here] | convert ctime(dateTimeConnect), ctime(dateTimeDisconnect), ctime(dateTimeOrigination) | search dateTimeConnect < "10/28/2011 09:05" AND dateTimeDisconnect > "10/28/2011 09:05" | table dateTimeOrigination dateTimeConnect dateTimeDisconnect ... View more