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
GO
[dbo].[UCAPMR_sw_count]