CREATE VIEW  [dbo].[allcomputersunkonwncategory]
AS
SELECT  allcomputers.userid, allcomputers.orgnm, allcomputers.office, allcomputers.hwsource, allcomputers.region,
        allcomputers.osname, allcomputers.ossp, allcomputers.osver, allcomputers.ospub,    allcomputers.oslanguage, allcomputers.hwuse,
        ROUND(allcomputers.fssize / 1e9, 1) AS fssize,
        ROUND(allcomputers.fsfree / 1e9, 1) AS fsfree,
        allcomputers.instdate, allcomputers.lscandate, allcomputers.hwuuid, allcomputers.hwdom,     allcomputers.hwname,
        allcomputers.hwsn, allcomputers.hwtype, allcomputers.hwmfgr, allcomputers.hwmodel, allcomputers.hwmem,
        allcomputers.hwbiosmfgr, allcomputers.hwbiosver, allcomputers.hwbiosdate,
        allcomputers.hwprocmfgr, allcomputers.hwprocmodel, allcomputers.hwproctype,
        allcomputers.hwproccount, allcomputers.hwprocspeed, allcomputers.hwcpuperf,
        allpowercomputers.turn_off_monitor_ac,allpowercomputers.turn_off_hdd_ac,allpowercomputers.standby_ac
FROM dbo.allcomputers LEFT OUTER JOIN dbo.allpowercomputers
ON dbo.allcomputers.[hwuuid] =  dbo.allpowercomputers.[hwuuid]
WHERE (dbo.allpowercomputers.[hwuuid] IS NULL)
GO
GRANT SELECT ON  [dbo].[allcomputersunkonwncategory] TO [aiadmin]
GRANT INSERT ON  [dbo].[allcomputersunkonwncategory] TO [aiadmin]
GRANT DELETE ON  [dbo].[allcomputersunkonwncategory] TO [aiadmin]
GRANT UPDATE ON  [dbo].[allcomputersunkonwncategory] TO [aiadmin]
GRANT SELECT ON  [dbo].[allcomputersunkonwncategory] TO [aipublic]
GO