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

[Jonathan Charles]

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,origLegCallIdentifier,dateTimeOrigination,origNodeId,origSpan,origIpAddr,callingPartyNumber,callingPartyUnicodeLoginUserID,origCause_location,origCause_value,origPrecedenceLevel,origMediaTransportAddress_IP,origMediaTransportAddress_Port,origMediaCap_payloadCapability,origMediaCap_maxFramesPerPacket,origMediaCap_g723BitRate,origVideoCap_Codec,origVideoCap_Bandwidth,origVideoCap_Resolution,origVideoTransportAddress_IP,origVideoTransportAddress_Port,destLegIdentifier,destNodeId,destSpan,destIpAddr,originalCalledPartyNumber,finalCalledPartyNumber,finalCalledPartyUnicodeLoginUserID,destCause_location,destCause_value,destPrecedenceLevel,destMediaTransportAddress_IP,destMediaTransportAddress_Port,destMediaCap_payloadCapability,destMediaCap_maxFramesPerPacket,destMediaCap_g723BitRate,destVideoCap_Codec,destVideoCap_Bandwidth,destVideoCap_Resolution,destVideoTransportAddress_IP,destVideoTransportAddress_Port,dateTimeConnect,dateTimeDisconnect,lastRedirectDn,pkid,originalCalledPartyNumberPartition,callingPartyNumberPartition,finalCalledPartyNumberPartition,lastRedirectDnPartition,duration,origDeviceName,destDeviceName,origCallTerminationOnBehalfOf,destCallTerminationOnBehalfOf,origCalledPartyRedirectOnBehalfOf,lastRedirectRedirectOnBehalfOf,origCalledPartyRedirectReason,lastRedirectRedirectReason,destConversationId,globalCallId_ClusterID,joinOnBehalfOf,comment,authCodeDescription,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
> > > >
> > >
> >
>