CREATE view  pubsum AS SELECT ai_pubdef_prop.pubname, SUM(ai_swdef_instcnt_kpi.count) AS "count" FROM  ai_swdef_instcnt_kpi INNER JOIN  ai_swdef_prop ON ai_swdef_instcnt_kpi.swuuid = ai_swdef_prop.swuuid INNER JOIN  ai_pubdef_prop ON ai_pubdef_prop.pubuuid = ai_swdef_prop.pubuuid where pubname!= '' GROUP BY ai_pubdef_prop.pubname
GO
GRANT SELECT ON  [dbo].[pubsum] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubsum] TO [aipublic]
GO