CREATE VIEW dbo.UCAPMR_TierCalculation AS SELECT DISTINCT "at".own_resource_uuid AS "assetlookup.assetid", "at".resource_name AS "assetlookup.assetname", "at".host_name AS "assetlookup.hostname", "at.it".name AS "assetlookup.item.itemname", "at.it".abbreviation AS "assetlookup.item.abbreviatedname", "at".processor_count AS "assetlookup.processorcount", "at".processor_speed AS "assetlookup.processorspeed" FROM dbo.ca_owned_resource "at" LEFT OUTER JOIN dbo.ca_model_def "at.it"  ON "at".model_uuid="at.it".model_uuid LEFT OUTER JOIN dbo.ca_resource_family "at.atty"  ON "at".resource_family="at.atty".id WHERE (("at.atty".name = 'Hardware'))
GO
GRANT SELECT ON  [dbo].[UCAPMR_TierCalculation] TO [uapmadmin]
GRANT SELECT ON  [dbo].[UCAPMR_TierCalculation] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[UCAPMR_TierCalculation] TO [uapmbatch]
GRANT SELECT ON  [dbo].[UCAPMR_TierCalculation] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[UCAPMR_TierCalculation] TO [uapmreporting]
GRANT SELECT ON  [dbo].[UCAPMR_TierCalculation] TO [uapmreporting_group]
GO