Add an Inventory report for managed, discovered, decommissioned, and ignored instances. This report provides an inventory of both managed and unmanaged instances, the information is divided into three sections, Managed Instances, Decomissioned Instances, and Unmananfed Instances. Refere to........
The following information is available on the Health Report.
- Managed Instances
- SQL Server Name
- Status
- Version
- Edition
- # of Databases
- Size of Databases (MB)
- Owner
- Location
- Clustered
- Discovery Methods
- Custom Inventory Fields for Instances
- Tags for Instances
- Decommissioned Instances
- SQL Server Name
- Version
- Edition
- # of Databases
- Size of Databases (MB)
- Owner
- Location
- Clustered
- Discovery Methods
- Discovered Instances
- SQL Server Name
- Version
- Edition
- Discovery Date
- Discovery Methods
- Ignored Instances
- SQL Server Name
- Version
- Edition
- Discovery Date
Provide parameters for this report:
Instance Tags
SQL Server Version
Edition
Managed, Discovered, Ignored, Decommissioned
This parameters values should be displayed to the user and based on values in user’s repository for these fields. User can select multiple values for each parameters. Parameters are optionals.
This report should be located in reports directory for the Deploy Report Utility.