CREATE    VIEW [dbo].[allcomputerspwrmgmtdriftscore]
        AS
        SELECT    DISTINCT pwrmgmtlaptopdriftscore.hwuuid,        
        pwrmgmtlaptopdriftscore.pwrmgmtdrift
        FROM    dbo.pwrmgmtlaptopdriftscore
        
        UNION
        SELECT    DISTINCT pwrmgmtdesktopdriftscore.hwuuid,        
        pwrmgmtdesktopdriftscore.pwrmgmtdrift
        FROM    pwrmgmtdesktopdriftscore
        
        UNION
        SELECT    DISTINCT pwrmgmtserverdriftscore.hwuuid,        
        pwrmgmtserverdriftscore.pwrmgmtdrift
        FROM pwrmgmtserverdriftscore;
GO
GRANT SELECT ON  [dbo].[allcomputerspwrmgmtdriftscore] TO [aiadmin]
GRANT INSERT ON  [dbo].[allcomputerspwrmgmtdriftscore] TO [aiadmin]
GRANT DELETE ON  [dbo].[allcomputerspwrmgmtdriftscore] TO [aiadmin]
GRANT UPDATE ON  [dbo].[allcomputerspwrmgmtdriftscore] TO [aiadmin]
GRANT SELECT ON  [dbo].[allcomputerspwrmgmtdriftscore] TO [aipublic]
GO