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

[Jonathan Charles]

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
> > >
> >
>