CREATE VIEW NBarScoreBoard AS
SELECT r.server_addr
    ,r.probe_addr
    ,r.rsrcIndex
    ,r.rsrcOtherIndex
    ,r.rsrcName
    ,r.userId
    ,AllStatsHCInBytes=100-case WHEN SUM(AllStatsHCInBytes)>100 THEN 100 ELSE SUM(AllStatsHCInBytes) END
    ,AllStatsHCOutBytes=100-case WHEN SUM(AllStatsHCOutBytes)>100 THEN 100 ELSE SUM(AllStatsHCOutBytes) END
    ,availability=100-CASE WHEN SUM(availability)>100 THEN 100 ELSE SUM(availability) END
FROM NBarAlertView r
GROUP BY r.server_addr
    ,r.probe_addr
    ,r.rsrcIndex
    ,r.rsrcOtherIndex
    ,r.rsrcName
    ,r.userId
GO
GRANT SELECT ON  [dbo].[NBarScoreBoard] TO [uniadmin]
GO