Page History
...
Your SQL Inventory Manger installation includes the IDERA Reports Utility. You can use this tool to deploy the included reports on your SSRS Instances. You can also use the IDERA Reports Utility to deploy other custom reports, to learn how to do it refer to Adding custom reports.Use the IDERA Reports Utility to deploy custom reports on your SSRS Instances. This utility is already included in your SQL Inventory Manger installation.
Info | ||
---|---|---|
| ||
IDERA Reports Utility needs to be present on the same server as the SIM services. |
...
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
You Note: You may need to run it as Admin in some cases
Deploying reports
To deploy reports on your instances follow these steps:
- Open IDERA Report Utility.
- Type the required information.
- Report Server Web Service URL: The location of the report server.
- Target SQL Server: The server that hosts the SSRS serviceSQL Inventory Manager repository database.
- SQL Database: The SQL Inventory Manager repository database, the default name is SQLInventoryManagerRepository.
- Login ID: A user ID with access rights to the Report ServerInventory Manager repository database.
- Password: A valid password for the previous user ID.
- Click Next.
- Select the reports you want to deploy and click Next.
- Click Finish to close the window.
...
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.
- Place the reports inside the Reports folder
...
- .
- Open the
...
- file rdl.xml located
...
- in the same folder as the Reports Utility.
At the end of the file add and customize the following code
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> </folder>
- Save the file and close it.
- Run the IDERA Reports Utility
Excerpt |
---|
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
...