When Spotlight on Messaging (SOM) 7.4 is installed for the first time orupgraded from a previous version of SOM,someWeb Reportsshowno data (if it is a first time install) orshow nonew data (ifupgraded from a previous version).
Below is a list of affected reports:
BlackBerry SRP Status
BlackBerry CPU Utilization (upgrade only)
BlackBerry Memory Utilization (upgrade only)
Exchange CPU Utilization (upgrade only)
Exchange Memory Utilization (upgrade only)
OCS Server At A Glance
OCS CPU Utilization (upgrade only)
OCS Critical Process Time
OCS Available Physical Memory (upgrade only)
OCS Critical Process Working Set
OCS System Disk Utilization
OCS Active Connections
OCS TLS Active Connections
OCS Database Physical Disk Usage
OCS IM Conferencing Load
OCS Audio Video Conferencing load
OCS Telephony Conferencing Load
OCS Web Conferencing Load
Bug found in the database Webreports scripts.
Run the attached script provided
1. Download the script below
2. Copy the attached SQL script - UpgradeWRViews.sql to the SQL server hosting SpotlightManagementFramework database.
3. Open SQL script in the SQL client tools and execute it.
