| Ed Leatherman 2007-01-29, 7:11 pm |
| Hi Steve,
Yes you can. Might be able to do it with CAR but I dont use that unless I
must. You can use the MS SQL query analyzer on the publisher to generate all
kinds of useful information;
Load up the Query Analyzer from the start menu, use local authentication.
Select the CDR database from the dropdown at the top.
Query I like to use and modify (I think I got this one from Wes)
SELECT DATEADD(ss, datetimeorigination, 'Jan 1, 1970 00:00:00')
AS datetime, callingPartyNumber, originalcalledpartynumber,
finalcalledpartynumber, duration, origdevicename, destdevicename
FROM calldetailrecord
WHERE callingPartyNumber = '39811'
ORDER BY datetimeorigination
Off the top of my head, you could search based on
WHERE origdevicename = 'yourgatewaynamehere' OR origdevicename =
'yourothergatewaynamehere'
to get incoming calls (or there might be an better way)
Timestamps in the results are in GMT with that sql query.
Ed
On 1/29/07, Miller, Steve <MillerS@dicksteinshapiro.com> wrote:
>
> All I see are outgoing when I run a department billing report. Please
> help!
>
>
--
Ed Leatherman
Senior Voice Engineer
West Virginia University
Telecommunications and Network Operations
|