<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body dir="auto">
Yes, you can use origdevicename and destdevicename columns, use both with “or” to capture to and from. <br>
<br>
<div dir="ltr">Loren</div>
<div dir="ltr"><br>
<blockquote type="cite">On May 18, 2022, at 8:51 AM, Tim Reimers <treimers@ashevillenc.gov> wrote:<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">Hi all -
<div><br>
</div>
<div>Is there a way to determine call activity by the device in CDR?</div>
<div>I'm trying to evaluate call activity across a variety of VG-224s, and a CDR query or SQL query that would just instantly pull all call activity to/from a VG port would be very helpful..</div>
<div><br>
</div>
<div>Thanks Tim<br>
<div>
<div>
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<p><b><i><span lang="EN" style="color:blue;font-family:"Arial",sans-serif;font-size:10pt"><span style="color:blue"><a href="https://en.wikipedia.org/wiki/Quis_custodiet_ipsos_custodes%3F" target="_blank">Quis custodiet
</a>ipsos</span></span></i></b><b><i><span style="color:blue;font-family:"Arial",sans-serif;font-size:10pt"> nexus</span></i></b><b><i><span style="color:blue;font-family:"Arial",sans-serif;font-size:10pt"></span></i></b></p>
<p>Tim Reimers</p>
<p>Network Administrator</p>
<p>I.T Services</p>
<p>City of Asheville </p>
<p><a href="mailto:treimers@ashevillenc.gov" target="_blank">treimers@ashevillenc.gov</a></p>
<p>(desk) 828-259-5512</p>
<p>(cell) 828-552-1585</p>
<p>"<span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">That’s no ordinary
<strike>rabbit</strike></span> <span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">
packet! That’s the most foul, cruel, and bad tempered </span>badly framed<span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif"> packet you ever set eyes on. </span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">Listen,
that packet’s got a vicious streak a mile wide, he’s a killer</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:18px">.</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">He’s
got huge sharp MTU…eh, he can leap about and cross Vlans…. </span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">I warned you, I warned you but did you listen? No… ohhh no, it’s just a harmless
little<font size="4"> </font>packet on the network, isn’t it now....</span><span style="color:rgb(25,25,25);font-family:alright_sansregular,"Helvetica Neue",Helvetica,Arial,sans-serif">"</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<span>_______________________________________________</span><br>
<span>cisco-voip mailing list</span><br>
<span>cisco-voip@puck.nether.net</span><br>
<span>https://puck.nether.net/mailman/listinfo/cisco-voip</span><br>
</div>
</blockquote>
</body>
</html>