Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Details of calls in a Response Group queue - where is that stored?

Locked Details of calls in a Response Group queue - where is that stored?

  • Thursday, September 24, 2009 4:51 PM
     
     
    Sign In to Vote
    0

    Hello OCS SQL gurus...

    I've reached the point where I can run a select query against the OCS DB & see the tables in the SQL management tool.


    I'd like to query for details of calls in the response groups - or rather, the queues.  I looking for details such as the amount of total users & the amount of time they have been in the queue.

    From that query - I can then build a simple webpage to display queue activity, length of time in queue, etc...


    Can someone please advise what tables & what fields to query?

    Any pointers or advice welcome...


    Regards

    Paul Adams
       

    All Replies

    • Friday, October 09, 2009 4:27 PM
       
       
      Sign In to Vote
      0
      Bonjour Paul

      I have done that analysis on the QoEMetrics  DB with table Session, User and UserAgent. SO you need to collect QoE data.

      Alain Boulard
         
      • Friday, October 09, 2009 4:31 PM
         
         
        Sign In to Vote
        0

        Thanks Alain,

        Is that realtime - or AFTER the call has finished?


        Regards

        Paul

           
        • Friday, October 09, 2009 4:34 PM
           
           
          Sign In to Vote
          0
          Hello again

          The db is updated afer the call is finish.

          Alain
             
          • Friday, October 09, 2009 4:38 PM
             
             
            Sign In to Vote
            0

            That information is very useful & I can use that.

            I was hoping to see realtime stats - and then use this info to make some sort of real time queue view...

            But thank you anyway


            Regards

            Paul



               
            • Friday, October 16, 2009 4:38 PM
               
               Answered
              Sign In to Vote
              0

              For others...

              "We have set up a little AJAX website which queries

              Server[@Name='OCSSERVER\RTC']/Database[@Name='acddyn']/Table[@Name='MatchRequests' and @Schema='dbo']/Data

              Have a look at this table while there are active queued calls. If there ar no active calls, the table shoud be empty              ."


              I'd love to take credit for this - but it was not me - it was a guy called Marcus in the Telephony forum...


              Regards

              Paul Adams

              • Marked As Answer by Paul Adams Friday, October 16, 2009 4:39 PM
              •