To import the audit reports follow below steps:

1.    Locate the Admin Report.xml file on the BMC Remedy Smart Reporting server.
By default, this file is located in the installServer\installDirectory\BMC Software\ARSystem\reporting directory.

2.    Download it and save it in a temp location locally.



3.    Open Smart Reporting in the default organization with the super admin user, usually siadmin — To provide access to administrators of all companies.

4.    Go to Administration > Import.

 

5.    On the import screen, click Browse and locate the Admin Report.xml file on the temp location. 

  

6.    Select Custom and then Continue:

 

7.    From the list Select All and drag and drop all to the Import List section.

 

8.    From the Import Items list, click the gear icon in the Smart Reporting Repository DB.

9.    Update the connection details, enter the user password for the Smart Reporting database that was entered during installation, and test the connection:

 

10.    Click Import.

Note: Importing Audit Reports from the Default organization will allow the content to be displayed for all companies when Multi-tenancy is configured.

If 'Smart Reporting Repository DB' option is not displayed while importing, then it will be necessary to create an entry in the DB for Yellowfin repository connection. Post that it will be possible to import the "Admin Report.xml" file. Refer to knowledge article: 000385528-Remedy Smart Reporting - Yellowfin option is not listed in database type when trying to test connectivity with the database.

Audit reports read data from the reporting repository database. To be able to view the audit reports correctly, perform the additional steps for viewing audit reports:

1. Access the BMC Remedy Smart Reporting url, and login as the BMC Remedy Smart Reporting superadmin, usually siadmin.

2. On the BMC Smart Reporting Console, choose Administration Console > Roles.

3. Click on the role that you will update for Smart Reporting users, which need access to Audit reports (e.g. Corporate Writer).

4. Look for Data sources and views section.

5. Check the checkbox for permission Skip Schema Check.

6. Save the changes.