Spectrum WEBI outage report Data mismatch. Outage Start time and end time are shown same

Document ID : KB000045515
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

Webi Outage Report showing the outage start time and end time same with a 0% outage

0-Problem.jpg

Cause: 

By design when we discover a model in spectrum it will record a 0% outage in the model outage table.

Hence we are seeing these 0% outages.  We need to filter them out by adding outage_type !=0 to the where clause.

Resolution:

  • Click on SQL button from Create Query window

WebiReportFieldsAndFiltersScreenshot.jpg

 

  • you will see below query

WebiReportSqlQuery.jpg

  • Click on Use custom SQL

3-CustomizeSqlQueryByClickingOnUseCustomSQL.jpg

  • Add "outage_type !=0 AND" to the where clause then the query will be as below

4-AfterModifiedWhereClause.jpg

  • Now click on Validate button to check for any sql errors

5-ClickOnValidateAfterQueryModification.jpg

  • Click on Save

6-ClickOnSave.jpg

  • Click on Run Query

7-ClickOnRunQuery.jpg

 

Now you will not see the 0% outages in the webi report.