SET QUOTED_IDENTIFIER OFF
GO

    CREATE VIEW arg_history_view AS
    SELECT
    'UAPM' as product, object_uuid, table_name, field_name, hsinstnc, object_type, hsaction, hstblbl, hsfddefi, hsfilbl, hsovalue, hsvalue, hsotext, hstext, hsadinfo, creation_user, creation_date, last_update_user, last_update_date, version_number
    FROM arg_history
    UNION
    SELECT
    'CMDB',                 /* product */
    com_par_id,         /* object_uuid */
    'ca_owned_resource',     /* table_name */
    attr_name,         /* field_name */
    0,            /* hsinstnc */
    11,            /* ojbect_type */
    'Update',        /* hsaction */
    'Asset',        /* hstblbl */
    -1,            /* hsfddefi */
    attr_name,        /* hsfilbl */
    NULL,            /* hsovalue */
    NULL,            /* hsvalue */
    old_value,        /* hsotext */
    new_value,        /* hstext */
    com_comment,        /* hsadinfo */
    'Not UAPM',        /* creation_user */
    NULL,            /* creation_date */
    com_userid,        /* last_update_user */
    com_dt,            /* last_update_date */
    0            /* version_number */
    FROM nr_com
GO
GRANT SELECT ON  [dbo].[arg_history_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_history_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_history_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_history_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_history_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_history_view] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_history_view] TO [uapmreporting_group]
GO