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