CREATE VIEW dbo.UCAPMR_sw_count AS SELECT DISTINCT "at".own_resource_uuid AS "assetlookup.assetid", "at".resource_name AS "assetlookup.assetname", "at.li".license_count AS "assetlookup.softwarelicense.licensecount", "at.li.lt".name AS "assetlookup.softwarelicense.licensetype.value", "at.av.iv".ivname AS "assetlookup.assetversion.itemversion.versionname" FROM dbo.ca_owned_resource "at" LEFT OUTER JOIN dbo.ca_software_license "at.li"  ON "at".license_uuid="at.li".license_uuid LEFT OUTER JOIN dbo.ca_license_type "at.li.lt"  ON "at.li".license_type_id="at.li.lt".id LEFT OUTER JOIN dbo.arg_assetver "at.av"  ON "at".own_resource_uuid="at.av".own_resource_uuid LEFT OUTER JOIN dbo.arg_itemver "at.av.iv"  ON "at.av".model_uuid="at.av.iv".model_uuid AND "at.av".avivid="at.av.iv".ivid LEFT OUTER JOIN dbo.ca_resource_family "at.atty"  ON "at".resource_family="at.atty".id WHERE (("at.atty".name = 'Software'))
GO
GRANT SELECT ON  [dbo].[UCAPMR_sw_count] TO [uapmadmin]
GRANT SELECT ON  [dbo].[UCAPMR_sw_count] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[UCAPMR_sw_count] TO [uapmbatch]
GRANT SELECT ON  [dbo].[UCAPMR_sw_count] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[UCAPMR_sw_count] TO [uapmreporting]
GRANT SELECT ON  [dbo].[UCAPMR_sw_count] TO [uapmreporting_group]
GO