After installing BMC Decision Support for Server Automation at the primary BMC Server Automation site, you can add more sites for reporting by using the BMC Decision Support for Server Automation Console.
Before you begin
(For SQL Server only) Assign the sysadmin role to the reports data warehouse user. This user needs this role to create the linked server. You can revoke this role assignment when the site addition operation is complete.
To add a new site for reporting
- Launch the BMC Decision Support for Server Automation Console.
- From the Configuration menu, select Database Details.
- In the Site Details section, click the Add Site link.
On the Add New Site page, enter the required information.
Click the Add Site button.
The Last Task Details page confirms that the site has been added.
Click Revert to revert to the previous settings.
After you add a site, run the extract, transfer, and load (ETL) process to transfer data from the site to the reports data warehouse.