Remedy Restore Tool Version 1.0

March 24th, 2010 by Venkat

For all the folks who are looking for a smooth transition from moving your AR Database from one server to another, or for some who wants to take dump from production and place it in development or even for some who just want to change the name on the AR server, here is the little tool developed by Carl Wilson

What it does?

It simply updates the server name in all the places that are needed.

Here is the detailed explanation:

This tool will update the forms and server settings with the server name entered. This can be used when restoring a Production DB to another environment, such as Pre-Production, where the server information needs to be updated to correctly reflect the current system.
The Tool performs the following

> Stops the Email Engine Service in Windows
> Disables Email Boxes in Remedy form “AR System Email Configuration”
> Updates the following Server Information:
– Default Web Path
– Server Name
– Server Alias
> Updates Report form entries with new Server Name
> Updates HelpFile URL pointers in “SHARE:Application_Properties” form
> Updates SRM settings, if SRM installed, to point to correct web path
> Updates Server Group information.
– Server Group Name
– Server Group Member
– Disable Admin Functions, where selected

This uses the .NET ARAPI7.1 and requires a minimum of V2.x of the Microsoft .NET framework to be installed.
This can be run remotely to the machine if the server name can be reached over a network, although the Email Service may not be stopped due to privileges.

Just unzip the files to a folder and run the application. Enter in the Required information and hit “Proceed”

Download it!!!

If you like the tool or faced any issues with it, please do report to Carl.

Advertisement

3 comments

  1. Carl Wilson says:

    Hi,
    Version 1.1 will be available on the Dev forum in a couple of days:

    Updated > Add the ability to specify a different Mid-Tier path as not all paths match the server and port. NOTE: You only need to specify the Mid-Tier path and port, not the fully qualified path as this is parsed and built within the program:

    e.g

    Server = RemedyS01

    Mid-Tier = RemedyS03.Company.com:8080

    ————————————————–
    Remedy Restore Tool Version 1.1
    ————————————————-

    This tool will update the forms and server settings with the server name entered. This can be used when restoring a Production DB to another environment, such as Pre-Production, where the server information needs to be updated to correctly reflect the current system.
    The Tool performs the following

    > Stops the Email Engine Service in Windows
    > Disables Email Boxes in Remedy form “AR System Email Configuration”
    > Updates the following Server Information:
    – Default Web Path
    – Server Name
    – Server Alias
    > Updates Report form entries with new Server Name (@@ = current server)
    > Updates HelpFile URL pointers in “SHARE:Application_Properties” form
    > Updates Survey URL in SYS:Application form
    > Updates CAI:AppRegistry records
    > Updates BMC.CORE.CONFIG:BMC_FederatedInterface records
    > Updates SRM settings, if SRM installed, to point to correct web path
    > Updates Server Group information.
    – Server Group Name
    – Server Group Member
    – Disable Admin Functions, where selected

    This uses the .NET ARAPI7.5 and requires a minimum of V2.x of the Microsoft .NET framework to be installed.
    This can be run remotely to the machine if the server name can be reached over a network, although the Email Service may not be stopped due to privileges.

    • Venkat says:

      Thanks Carl, for the update about the new version.

      This information will def. help many people

  2. Vishnu says:

    Great job!! Carl..
    This would be really helpful ..

%d bloggers like this: