Get-CqmAutomated.ps1 will identify your monitor database (presuming there only is one database), it will detect your database’s date format and launch CQM.PS1 from a folder specified. It will then get the current date and calculate the start date
based on your input. 30, 60, 90 or 180 days are the options.
This script was created for automation purposes, and given necessary email parameters, it will send a zipped file with the content to the designated address (be mindful of the size of log files, and possible mail server restrictions).
This script is meant as compliment to the existing CQM.PS1 script, and cannot be used alone.
The current version of CQM.ps1 (1.5 when the script was created) can be read here: http://blogs.technet.com/b/jenstr/archive/2015/06/01/microsoft-call-quality-methodology-scorecard-for-skype-for-business-server-v1-5.aspx
- This script is for both Enterprise and Standard Edition Server.
- The script has not been tested in a multiple site topology. But run with care if not in a single site.
- Be aware of possible caveats with blocking firewalls, or missing rights on severeal components.
- This script has been tested with a co-location of all databeses.
- This script has been tested with databases on seperate instances.
- If no switch is used to define number of days, script uses the default of 30 days from current date
- If QoECdrVersion is not set through the parameter, script will try to to a version lookup (Warning, might fail, should always set QoECdrVersion for accuracy)
- There is a built-in cleanup routine, trying to remove old reports og zipfiles generated manually og by previously running this script.
- V1 - October 2015
- This is the initial release of this script
- V1a - October 2015
- Added QoECdrVersion to script for compability with Lync 2010 and 2013
- Added a versioncheck of the monitordatabase depending registrarpool, should detect version automatically
- Added Current Release Link
- Added info about dateformat, seperator character and default sipdomain to the outgoing email
- Script is now signed
- Handling multiple databases in large deployments