CREATE VIEW [dbo].[allservercomppoweranalysis]
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 = 'Server')
GO
GRANT SELECT ON  [dbo].[allservercomppoweranalysis] TO [aiadmin]
GRANT INSERT ON  [dbo].[allservercomppoweranalysis] TO [aiadmin]
GRANT DELETE ON  [dbo].[allservercomppoweranalysis] TO [aiadmin]
GRANT UPDATE ON  [dbo].[allservercomppoweranalysis] TO [aiadmin]
GRANT SELECT ON  [dbo].[allservercomppoweranalysis] TO [aipublic]
GO