[dbo].[arg_entitlement_summary_view]
SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_entitlement_summary_view
AS
SELECT own_resource_uuid, isnull(b.license_count, 0) license_count, isnull(c.entitlement_count, 0) entitlement_count, isnull(b.license_count, 0) - isnull(c.entitlement_count, 0) variance
FROM ca_owned_resource a left outer join ca_software_license b on a.license_uuid=b.license_uuid left outer join arg_entitlement_count_view as c on a.own_resource_uuid = c.object_uuid
GO
GRANT SELECT ON [dbo].[arg_entitlement_summary_view] TO [swcmadmin]
GRANT SELECT ON [dbo].[arg_entitlement_summary_view] TO [uapmadmin]
GRANT SELECT ON [dbo].[arg_entitlement_summary_view] TO [uapmadmin_group]
GRANT SELECT ON [dbo].[arg_entitlement_summary_view] TO [uapmbatch]
GRANT SELECT ON [dbo].[arg_entitlement_summary_view] TO [uapmbatch_group]
GRANT SELECT ON [dbo].[arg_entitlement_summary_view] TO [uapmreporting]
GRANT SELECT ON [dbo].[arg_entitlement_summary_view] TO [uapmreporting_group]
GO
