CREATE    VIEW dbo.linuxcomputers
        AS
        SELECT    ospub + ' ' + osname AS osname,
            userid,
            orgnm,
            office,
            hwsource,
            region,
            hwuuid,
            hwdom,
            hwname,
            hwsn,
            hwtype,
            hwmfgr,
            hwmodel,
            hwmem,
            hwuse,
            hwbiosmfgr,
            hwbiosver,
            hwbiosdate,
            hwprocmfgr,
            hwprocmodel,
            hwproctype,
            hwproccount,
            hwprocspeed,
            fssize,
            fsfree,
            ospub,
            osver,
            ossp,
            oslanguage,
            lscandate,
            instdate
        FROM    dbo.allcomputers
        WHERE    (osname LIKE '%Linux%')
        
GO
GRANT SELECT ON  [dbo].[linuxcomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[linuxcomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[linuxcomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[linuxcomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[linuxcomputers] TO [aipublic]
GO