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