Webi Outage Report showing the outage start time and end time same with a 0% outage
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.
- Click on SQL button from Create Query window
- Add "outage_type !=0 AND" to the where clause then the query will be as below
- Now click on Validate button to check for any sql errors
Now you will not see the 0% outages in the webi report.