Saturday, February 18, 2012 10:42 PM
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.
- Moved by Noya LauModerator Wednesday, February 22, 2012 10:02 AM (From:Management)
Sunday, February 19, 2012 2:34 PM
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 )
- Proposed As Answer by Noya LauModerator Wednesday, February 22, 2012 10:00 AM
Monday, February 20, 2012 6:58 AM
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
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
- Marked As Answer by clay28 Tuesday, February 28, 2012 8:20 AM