none
Get user activity (call volume) using Powershell

    Question

  • Hi all,

    Is there a way to use PowerShell to access Call Detail Records?  I would like to use PowerShell to lookup Call Detail Records and look up the data based on user as the caller or callee, conference ID, or a date range.

    Thanks

    Saturday, February 18, 2012 10:42 PM

Answers

  • The data is held in SQL and the Schema is document I believe. There are no specific cmdlets but you could write something to manually query SQL and pull the data.

    hope that helps

    Tom


    Tom Arbuthnot, Consultant Modality Systems
    Blog: Lync'd Up Blog Join over 300 UC Pros who subscribe for blog updates: Email or RSS
    Twitter @tomarbuthnot

    • Marked as answer by clay28 Tuesday, February 28, 2012 8:20 AM
    Monday, February 20, 2012 8:32 AM

All replies

  • Hi,

    I assume that you aware that you need to have monitoring server deployed to have call detail records and as per my knowledge, there an't any power shell cmdletts available to queury the QOE Database. you might need to do this in SQL admin side.


    Thamara. MCTS, MCITP Ent Admin, Specialized in U.C Voice OCS 2007 R2 Z-Hire -- Automate IT Account creation process ( AD / Exchange / Lync )

    Sunday, February 19, 2012 2:34 PM
  • Ok thanks for the feedback.

    We have deployed the Lync Monitoring server...I was just was wondering if I can get that data with powershell.

    Monday, February 20, 2012 6:58 AM
  • The data is held in SQL and the Schema is document I believe. There are no specific cmdlets but you could write something to manually query SQL and pull the data.

    hope that helps

    Tom


    Tom Arbuthnot, Consultant Modality Systems
    Blog: Lync'd Up Blog Join over 300 UC Pros who subscribe for blog updates: Email or RSS
    Twitter @tomarbuthnot

    • Marked as answer by clay28 Tuesday, February 28, 2012 8:20 AM
    Monday, February 20, 2012 8:32 AM