CREATE    VIEW dbo.appsnotetrust
        AS
        SELECT    allcomputers.*
        FROM    dbo.allcomputers
        WHERE    hwuuid NOT IN
            (SELECT    hwuuid
            FROM    ai_swdef_hwdef_rel
            WHERE    swuuid IN
                (SELECT    swuuid
                FROM    ai_swdef_prop
                WHERE    UPPER(swname) LIKE '%ETRUST ANTIVIRUS%'))
        
GO
GRANT SELECT ON  [dbo].[appsnotetrust] TO [aiadmin]
GRANT INSERT ON  [dbo].[appsnotetrust] TO [aiadmin]
GRANT DELETE ON  [dbo].[appsnotetrust] TO [aiadmin]
GRANT UPDATE ON  [dbo].[appsnotetrust] TO [aiadmin]
GRANT SELECT ON  [dbo].[appsnotetrust] TO [aipublic]
GO