CREATE    VIEW dbo.storagefilesystemsum
        AS
        SELECT    TOP 200
            COUNT(fsname) AS countoffilesystem,
            fsname,
            SUM(fssize) AS sumofdrivesize
        FROM    dbo.ai_fsdef_prop
        GROUP
        BY    fsname
        HAVING    (fsname <> 'N/A')
        ORDER
        BY    SUM(fssize) DESC
        
GO
GRANT SELECT ON  [dbo].[storagefilesystemsum] TO [aiadmin]
GRANT INSERT ON  [dbo].[storagefilesystemsum] TO [aiadmin]
GRANT DELETE ON  [dbo].[storagefilesystemsum] TO [aiadmin]
GRANT UPDATE ON  [dbo].[storagefilesystemsum] TO [aiadmin]
GRANT SELECT ON  [dbo].[storagefilesystemsum] TO [aipublic]
GO