Distinguish incoming Outgoing calls on sql

[loren343]

Hye,
I use CCM 4.2.
On Entreprise Manager, i wish write a sql command to obtain just outgoing calls.
How do this ?
I know sql language, but i don't understand concept about cisco cdr.
Thanks

 

[cdiross]

Why do this when CDR provides you with predefined reports on that specifically?

 

[cdiross]

select * from calldetailrecord where callingpartynumber=''

From CDR DB

You'll need to export in .csv format and cleanup the junk columns you don't need in excel