Sign in
 
HomeOnline20132010Interop ProgramsLibraryForumsGalleryLync Blogs
TechCenter >
> 
> 
Get user activity (call volume) using Powershell

답변됨 Get user activity (call volume) using Powershell

  • Saturday, February 18, 2012 10:42 PM
     
     
    Sign In to Vote
    0

    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

    • Moved by Noya LauModerator Wednesday, February 22, 2012 10:02 AM (From:Management)
    •  
     

All Replies

  • Sunday, February 19, 2012 2:34 PM
     
     Proposed Answer
    Sign In to Vote
    1

    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 )

     
  • Monday, February 20, 2012 6:58 AM
     
     
    Sign In to Vote
    0

    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 8:32 AM
     
     Answered
    Sign In to Vote
    0

    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
    •