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

[ Post a follow-up to this message ]