CREATE VIEW NPOTSScoreBoard AS
SELECT r.server_addr
    ,r.probe_addr
    ,r.rsrcIndex
    ,r.rsrcOtherIndex
    ,r.rsrcName
    ,r.userId
    ,bytesToServer=100-case WHEN SUM(bytesToServer) > 100 THEN 100 ELSE SUM(bytesToServer) END
    ,bytesToClients=100-case WHEN SUM(bytesToClients) > 100 THEN 100 ELSE SUM(bytesToClients) END
    ,userrespTime=100-case WHEN SUM(userrespTime) > 100 THEN 100 ELSE SUM(userrespTime) END
    ,netRespTime=100-case WHEN SUM(netRespTime) > 100 THEN 100 ELSE SUM(netRespTime) END
    ,TSlinkErr=100-case WHEN SUM(TSlinkErr) > 100 THEN 100 ELSE SUM(TSlinkErr) END
FROM NPOTSAlertView r
GROUP BY
    r.server_addr
    ,r.probe_addr
    ,r.rsrcIndex
    ,r.rsrcOtherIndex
    ,r.rsrcName
    ,r.userId
GO
GRANT SELECT ON  [dbo].[NPOTSScoreBoard] TO [uniadmin]
GO