How do I recover my existing custom reports, queries, and audit history after upgrading to Directory (NETIQKB49896)

  • Document ID:7749896
  • Creation Date:02-Feb-2007
  • Modified Date:19-Jun-2007
    • Micro Focus Products:
      Directory and Resource Administrator

Resolution

goal
How do I recover my existing custom reports, queries, and audit history after upgrading to Directory and Resource Administrator 7.5?

goal
Does upgrading preserve my existing custom reports, queries, and audit history?

goal
How do I migrate custom queries, custom reports, and audit history?

fact
Directory and Resource Administrator 7.x

symptom
After upgrading to DRA 7.5, audit history, custom reports, and custom queries are missing.

cause
During the upgrade, the upgrade process moves existing reporting files from the Reporting folder to a folder called OldReporting.

fix

You can copy and paste the custom reports and queries from the old OaRept.mdb Access database file to the new OaRept.mdb Access database file. To view historic audit data, run reports from your new DRA installation against the database from the old installation.

To migrate custom queries:

  1. Start Microsoft Access from the Microsoft Office program group.

  2. Open the OaRept.mdb file in the installation folder\NetIQ\DRA\Reporting folder.

  3. Open the OaRept.mdb file in the installation folder\NetIQ\DRA\OldReporting folder.

  4. Enter Design Mode in both databases.

  5. In the left panel of the old database, click Queries.

  6. Select a custom query.

  7. Right click the query, and then click Copy.

  8. In the left panel of the new database, click Queries.

  9. Right click the right panel, and then click Paste.

  10. Repeat Steps 5 through 9 for each custom query.

  11. Save the new OaRept.mdb file.

To migrate custom reports:

  1. Start Microsoft Access from the Microsoft Office program group.

  2. Open the OaRept.mdb file in the installation folder\NetIQ\DRA\Reporting folder.

  3. Open the OaRept.mdb file in the installation folder\NetIQ\DRA\OldReporting folder.

  4. Enter Design Mode in both databases.

  5. In the left panel of the old database, click Reports.

  6. Select a custom report.

  7. Right click the report, and then click Copy.

  8. In the left panel of the new database, click Reports.

  9. Right click the right panel, and then click Paste.

  10. Repeat Steps 5 through 9 for each custom report.

  11. Save the new OaRept.mdb file.

To connect to the old database to view historic audit history:

  1. Log on to the Account and Resource Management Console computer.

  2. Start the Account and Resource Management Console.

  3. Click Select Import Database on the File menu.

  4. Browse to the location of the old database, and then select the database file.

  5. Click Open.

  6. Click OK.

  7. Run your operation and usage history reports against the old database to view historic data.



Additional Information

Formerly known as NETIQKB49896