CREATE VIEW    [dbo].[workloadconfigurationthisyear]
AS
SELECT     workloadconfigurationall.hwuuid,    
           workloadconfigurationall.[Desktop],
           workloadconfigurationall.[Laptop],    
           workloadconfigurationall.[Server],    
           workloadconfigurationall.[Application Development],
           workloadconfigurationall.[Database Software],    
           workloadconfigurationall.[Graphics and Presentation],    
           workloadconfigurationall.[Internet and Information Servers],
           workloadconfigurationall.[Microsoft Office Software],    
           workloadconfigurationall.[Multimedia Tools and Utilities],
           workloadconfigurationall.[Web Development and Publishing],
           workloadconfigurationall.[hwprocspeed],
           workloadconfigurationall.[hwmem],
           workloadconfigurationall.[fssize]
FROM       dbo.workloadconfigurationall INNER JOIN dbo.allcomputersanalysis
         ON dbo.workloadconfigurationall.hwuuid = dbo.allcomputersanalysis.hwuuid
WHERE       dbo.allcomputersanalysis.instdate > DATEADD(yyyy, - 1, GETDATE())
GO
GRANT SELECT ON  [dbo].[workloadconfigurationthisyear] TO [aiadmin]
GRANT INSERT ON  [dbo].[workloadconfigurationthisyear] TO [aiadmin]
GRANT DELETE ON  [dbo].[workloadconfigurationthisyear] TO [aiadmin]
GRANT UPDATE ON  [dbo].[workloadconfigurationthisyear] TO [aiadmin]
GRANT SELECT ON  [dbo].[workloadconfigurationthisyear] TO [aipublic]
GO