CREATE    VIEW dbo.notscannedlast30days
        AS
        SELECT    dbo.allcomputers.*
        FROM    dbo.allcomputers
            INNER JOIN ai_hwdef_lscandate_kpi
            ON allcomputers.hwuuid= ai_hwdef_lscandate_kpi.hwuuid
        WHERE    ( ai_hwdef_lscandate_kpi.lscandate < DATEADD(m, - 1, GETDATE()))
        AND    ( len(osname) != 0 and osname != ' ' and osname is not null )
GO
GRANT SELECT ON  [dbo].[notscannedlast30days] TO [aiadmin]
GRANT INSERT ON  [dbo].[notscannedlast30days] TO [aiadmin]
GRANT DELETE ON  [dbo].[notscannedlast30days] TO [aiadmin]
GRANT UPDATE ON  [dbo].[notscannedlast30days] TO [aiadmin]
GRANT SELECT ON  [dbo].[notscannedlast30days] TO [aipublic]
GO