Skip to Content

Creating remote views

Use this procedure to create remote views.

To create remote views

  1. On the BMC Remedy AR System server, run the cr_itm_remote_views_ora.bat script that can be found at C:\Program Files\BMC Software\BMCITBusinessManagement\Shared_Components\sql\hybrid\oracle. The syntax is as follows:
    cr_itm_remote_views_ora.bat <AR DB Oracle Service Name or SID><AR DB Schema User Name><AR DB Schema User Password><ITBM DB Oracle Service name or SID

    Information
    Example
    cr_itm_remote_views_ora.bat ORCL ARAdmin AR#Admin# ORCL_DV02

  2. On the BMC IT Business Management Suite server, run the cr_ar_dummy_views_ora.bat script that can be found at C:\Program Files\BMC Software\BMCITBusinessManagement\Shared_Components\sql\hybrid\oracle. The syntax is as follows:
    cr_ar_dummy_views_ora.bat <ITBM DB Oracle Service name or SID><ITBM DB Schema User Name><ITBM DB Schema User Password>

    Information
    Example
    cr_ar_dummy_views_ora.bat ORCL ARAdmin AR#Admin#

 

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC IT Business Management Suite 8.1