CREATE VIEW "storagefssum" ("countoffilesystem", "fsname", "sumofdrivesize")  AS
       SELECT Count(ai_fsdef_prop.fsname), "ai_fsdef_prop"."fsname", Sum(ai_fsdef_prop.fssize)
       FROM "ai_fsdef_prop"
       GROUP BY ai_fsdef_prop.fsname
       HAVING ai_fsdef_prop.fsname <> ''
GO
GRANT SELECT ON  [dbo].[storagefssum] TO [aiadmin]
GRANT INSERT ON  [dbo].[storagefssum] TO [aiadmin]
GRANT DELETE ON  [dbo].[storagefssum] TO [aiadmin]
GRANT UPDATE ON  [dbo].[storagefssum] TO [aiadmin]
GRANT SELECT ON  [dbo].[storagefssum] TO [aipublic]
GO