0 Replies Latest reply on Jun 6, 2019 9:53 PM by rafa_gp

    Query to get calls with some conditions


      Hi Guys,


      I'm trying to get a report where all calls out of work hours can be generated on a report, I have a query that get the date and time, I convert the hour to 24 hours and 12 hours format, but on the table VoIpCallDetails I don't find the field originphoneextension and destinationphoneextension, I see only incoming calls but not all calls (incoming and outcoming). Another table called VoIpCalls I see fields like OrigDeviceName and DestDeviceName but for my propose I need extenions because I will filter all those calls where the destionation number starts with 00 (international calls), on Orion web when I make a report, the field "origphoneextension" contains the extension but on tables directly over database I don't see something similar, Does some know if there is a table on database that contains a field with origin extension and destination extension for a call generated?



      This is my query


      select OrigDateTimeStamp ,

      FORMAT(OrigDateTimeStamp ,'hh') as hora12,

      cast(DATEPART(hour, OrigDateTimeStamp ) as numeric)  as hora24

      from VoipCallDetails

      where OrigDateTimeStamp BETWEEN  '06/01/2019'  AND '06/30/2019' AND

      (   cast(DATEPART(hour, OrigDateTimeStamp ) as numeric)   IN (19,20,21,22,23,0,1,2,3,4,5,6,7))



      Thanks you so much for any support