SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_hwconfigurations_view AS SELECT DISTINCT arg_actiondf.adtext, arg_actiondf.ad1obty,
arg_actiondf.adprot, arg_actiondf.adtype,arg_actiondf.adsystem, arg_linkdef.ndtext, arg_linkdef.ndid,
arg_linkdef.nd2obty, arg_linkdef.nd2subty, arg_linkdef.ndreqd, arg_action.object_uuid, arg_action.acadid,
arg_action.ac1ivid, arg_action.last_update_user as ac_last_update_user, arg_action.last_update_date as
ac_last_update_date, actext1, arg_action.acint1, arg_action.acdate1, arg_action.accommnt, arg_action.acdatedt,
arg_action.actimetm, arg_actionlk.lkinstnc, arg_actionlk.lkcommnt, arg_actionlk.lkstrtdt, arg_actionlk.lkenddt,
arg_actionlk.last_update_user as lk_last_update_user, arg_actionlk.last_update_date as lk_last_update_date,
arg_actionlk.secondary_object_uuid, ca_model_def.name, ca_owned_resource.resource_name AS ASSETITNAME,
primary_asset.resource_name primary_asset_name FROM arg_actiondf INNER JOIN arg_action LEFT OUTER JOIN
arg_actionlk ON arg_action.acadid = arg_actionlk.lkacadid AND arg_action.ac1ivid = arg_actionlk.lkac1ivi AND
arg_action.object_uuid = arg_actionlk.primary_object_uuid AND arg_action.actimetm = arg_actionlk.lkactitm AND
arg_action.acdatedt = arg_actionlk.lkacdadt LEFT OUTER JOIN arg_linkdef ON arg_actionlk.lkacadid
= arg_linkdef.ndadid AND arg_actionlk.lkndid = arg_linkdef.ndid ON arg_actiondf.adid = arg_action.acadid
LEFT OUTER JOIN ca_model_def ON arg_actionlk.secondary_object_uuid = ca_model_def.model_uuid LEFT OUTER JOIN
ca_owned_resource INNER JOIN ca_model_def ASSETITEM ON ca_owned_resource.model_uuid = ASSETITEM.model_uuid
ON arg_actionlk.secondary_object_uuid = ca_owned_resource.own_resource_uuid LEFT OUTER JOIN
ca_owned_resource primary_asset ON arg_actionlk.primary_object_uuid = primary_asset.own_resource_uuid
WHERE (arg_actiondf.adtype=2);


GO
GRANT SELECT ON  [dbo].[arg_hwconfigurations_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_hwconfigurations_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_hwconfigurations_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_hwconfigurations_view] TO [uapmreporting_group]
GO