[cisco-voip] CCM 5, need to find out who called 911

[Pete Fabian]

I have always gone into car > CDR > Search > By User/Extension and search
for 911 and 9911

This has always worked reliably for me on 4.x and 5.x

 

-----Original Message-----
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Jonathan Charles
Sent: Thursday, July 19, 2007 8:39 AM
To: Voll, Scott
Cc: cisco-voip at puck-nether.net
Subject: Re: [cisco-voip] CCM 5, need to find out who called 911

OK, I got data from a live system...

This works.

Basically, you get a txt file (change it to a CSV and open it with
Excel), the finalCalledParty is there... just a matter of searching
for 911 and then scrolling over to callingPartyNumber

I found the evil-doer


Jonathan

On 7/19/07, Jonathan Charles <jonvoip at gmail.com> wrote:
> OK, making some progress here...
>
> I went into CAR, and if you go to Go to CDR - Export CDR/CMR and
> export the data for the day in question, you get a TXT file with the
> following headers:
>
> There are a lot:
>
>
cdrRecordType,globalCallID_callManagerId,globalCallID_callId,origLegCallIden
tifier,dateTimeOrigination,origNodeId,origSpan,origIpAddr,callingPartyNumber
,callingPartyUnicodeLoginUserID,origCause_location,origCause_value,origPrece
denceLevel,origMediaTransportAddress_IP,origMediaTransportAddress_Port,origM
ediaCap_payloadCapability,origMediaCap_maxFramesPerPacket,origMediaCap_g723B
itRate,origVideoCap_Codec,origVideoCap_Bandwidth,origVideoCap_Resolution,ori
gVideoTransportAddress_IP,origVideoTransportAddress_Port,destLegIdentifier,d
estNodeId,destSpan,destIpAddr,originalCalledPartyNumber,finalCalledPartyNumb
er,finalCalledPartyUnicodeLoginUserID,destCause_location,destCause_value,des
tPrecedenceLevel,destMediaTransportAddress_IP,destMediaTransportAddress_Port
,destMediaCap_payloadCapability,destMediaCap_maxFramesPerPacket,destMediaCap
_g723BitRate,destVideoCap_Codec,destVideoCap_Bandwidth,destVideoCap_Resoluti
on,destVideoTransportAddress_IP,destVideoTransportAddress_Port,dateTimeConne
ct,dateTimeDisconnect,lastRedirectDn,pkid,originalCalledPartyNumberPartition
,callingPartyNumberPartition,finalCalledPartyNumberPartition,lastRedirectDnP
artition,duration,origDeviceName,destDeviceName,origCallTerminationOnBehalfO
f,destCallTerminationOnBehalfOf,origCalledPartyRedirectOnBehalfOf,lastRedire
ctRedirectOnBehalfOf,origCalledPartyRedirectReason,lastRedirectRedirectReaso
n,destConversationId,globalCallId_ClusterID,joinOnBehalfOf,comment,authCodeD
escription,authorizationLevel,clientMatterCode
>
> The box I ran it on is a test box with no call detail... I have the
> cust sending me the data for that day...
>
> I will tell you what I find (it looks like a simple CSV, so this may
> not be that bad...
>
>
>
> Jonathan
>
>
> On 7/19/07, Jonathan Charles <jonvoip at gmail.com> wrote:
> > I think we are screwed:
> >
> > admin:
> > admin:run sql select callingPartyNumber from CallDetailRecord
> > The specified table (calldetailrecord) is not in the database.
> > admin:
> >
> >
> > If there is no CDR table.... then again, I am probably running this on
> > the wrong DB...
> >
> >
> > Jonathan
> >
> > On 7/19/07, Jonathan Charles <jonvoip at gmail.com> wrote:
> > > I have a sample query:
> > >
> > > run sql select name,nodeid from ProcessNode
> > >
> > > I figure, maybe the tables didn't change and I can modify my sql 2000
query...
> > >
> > >
> > >
> > > Jonathan
> > >
> > > On 7/19/07, Voll, Scott <Scott.Voll at wesd.org> wrote:
> > > > Soon as you find out..... let me know ;-)
> > > >
> > > > Scott
> > > >
> > > > -----Original Message-----
> > > > From: cisco-voip-bounces at puck.nether.net
> > > > [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Jonathan
> > > > Charles
> > > > Sent: Thursday, July 19, 2007 7:54 AM
> > > > To: cisco-voip at puck-nether.net
> > > > Subject: [cisco-voip] CCM 5, need to find out who called 911
> > > >
> > > > So, since they took away all of our SQL queries when they went to
> > > > Linux, it doesn't change the fact that we still need to know who
> > > > called 911.
> > > >
> > > > So, how do we do it?
> > > >
> > > > I have posted this request before, and it has been ignored... I am
> > > > debating on opening a TAC case to find out how...
> > > >
> > > >
> > > >
> > > > Jonathan
> > > > _______________________________________________
> > > > cisco-voip mailing list
> > > > cisco-voip at puck.nether.net
> > > > https://puck.nether.net/mailman/listinfo/cisco-voip
> > > >
> > >
> >
>
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip