none
Response group usage report RRS feed

  • Question

  • Hi all,

    just wondering if anyone know which table/database this report is fetched from?

    https://technet.microsoft.com/en-us/library/gg558632.aspx?f=255&MSPPError=-2147217396

    We use Power BI to generate our own report and would like to integrate Response Group Usage Report.

    Tried to google and bing, but I cannot see where this data is retrieved from.

    Would save me a lot of time if anyone could point me to the right direction.

    Thanks!


    Please mark as helpful if you find my contribution useful or as an answer if it does answer your question. That will encourage me - and others - to take time out to help you. Thank you! Off2work

    Tuesday, June 21, 2016 12:49 PM

Answers

  • in Lync 2013 documentation you will find the USType as below

    1024

    Response_Group_Service

    RGS

    apart from that i dint find any document which explains about the storage procedures or database tables to extract data.

    However, in following article covered how to query  RGS usage reports but its for Lync 2010 not sure if this helps you or not but you can have a look at 

    https://danielbergsten.wordpress.com/2011/08/30/lync-2010-response-group-sql-query/

    http://www.ucprofessional.com/2011/01/response-group-queue-monitoring.html


    Regards, Raju

    Tuesday, June 21, 2016 2:16 PM

All replies

  • in Lync 2013 documentation you will find the USType as below

    1024

    Response_Group_Service

    RGS

    apart from that i dint find any document which explains about the storage procedures or database tables to extract data.

    However, in following article covered how to query  RGS usage reports but its for Lync 2010 not sure if this helps you or not but you can have a look at 

    https://danielbergsten.wordpress.com/2011/08/30/lync-2010-response-group-sql-query/

    http://www.ucprofessional.com/2011/01/response-group-queue-monitoring.html


    Regards, Raju

    Tuesday, June 21, 2016 2:16 PM
  • Very interesting question as usual, I tried all online resource but no one seems to be mentioning the same. I tried few basic SQL queries but not able to get this table value.

    Linus || Please mark posts as answers/helpful if it answers your question.

    Tuesday, June 21, 2016 7:10 PM