Page History

Use the reports utility to deploy reports on Your SQL Inventory Manger installation includes the IDERA Reports Utility. You can use this tool to deploy the included reports on your SSRS Instances. The report utility is a windows application included with the SQL Inventory Manger installer.

You can also use the IDERA Reports Utility to deploy other custom reports.

...

Accessing the report deploy utility

You can access the report utility clicking on Deploy Reports under the Reporting  section on the Administration tab of IDERA Dashborad.

To access the  IDERA Report Utility go to the ReportUtility folder inside the SQL Inventory Manager installation path. The default location for the IDERA Reports Utility is  C:\Program Files\Idera\SQLInventoryManager\ReportUtility

Deploying reports

Deploying reports To deploy reports on your instances follow these steps:

1. Open

...

1. IDERA Report Utility. 
   
   Image Added
   
   
2. Type the required information.
   • Report Server Web Service URL: The location of the report server.
   • Target SQL Server: The

...

1. • server that hosts the SQL Inventory Manager repository database.
   • SQL Database: The

...

1. • SQL Inventory Manager repository database, the default name is SQLInventoryManagerRepository.
   • Login ID:

...

1. • A user ID with access rights to the Inventory Manager repository database.
   • Password:

...

1. • A valid password for the previous user ID.
2. Click Next.
3. Select the reports you want to deploy and click Next.
   

...

1. 
   Image Added
   
   
2. Click Finish to close the window.
   
   Image Added

Adding custom reports

You can also add customs reports to your installation. To add custom reports go to the Reports Utility folder, the default location is C:\Program Files\Idera\SQLInventoryManager\ReportUtility, and follow these steps.

1. Place the reports you want to install inside the Reports folder.
2. Open the file rdl.xml located in the same folder as the Reports Utility. 

3. Add and customize the following code, make sure to add it before the </folder> tag.

   Code Block
   language xml
   <reportfile> <name>The name of a Report</name> <file>Reports\filename.rdl</file> <description>Enter a description for your report.</description> </reportfile>

4. Save the file and close it.
5. Run the IDERA Reports Utility

...