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, ASSETITEM.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