CREATE    VIEW dbo.storagefssum
        AS
        SELECT    TOP 200
            COUNT(dbo.ai_fsdef_prop.fsname) AS countoffilesystem,
            dbo.ai_fsdef_prop.fsname,
            SUM(dbo.ai_fsdef_prop.fssize) AS sumofdrivesize
        FROM    dbo.ai_fsdef_prop
        GROUP
        BY    dbo.ai_fsdef_prop.fsname
        HAVING    (((dbo.ai_fsdef_prop.fsname)<>''))
        ORDER
        BY    sumofdrivesize DESC
        
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