Page History
The Inventory report provides an overview of information from the Managed , Discovered , Decommissioned , and Ignored instances views. This report contains three sections, Managed Instances , Decommissioned Instances , and Unmananaged Instances . Refer to 26_Changes_IDERA This report displays chargeback information for managed instances and databases. Refer to Reports Utility for information on how to deploy or remove this report.
The chargeback report provides the following information is available on the Inventory Report.
Table of Contents | ||||
---|---|---|---|---|
|
Managed Instances
...
:
Instance Name
The
...
SQL Server instance name.
...
Version
The
...
SQL Instance version number.
Edition
The
...
SQL Server
...
Instance edition number.
Owner
The name set at Instance registration.
Data Center/Location
The location name se at instance registration.
Hostname
VM Vendor
Model
Operating System
The name of the OS running the
# of Databases
The number of databases on the SQL Server instance.
Size of Databases (MB)
The size of the databases on the SQL Server instance.
Owner
The owner name set during instance registration.
Location
The location name set during instance registration.
Clustered
Whether the instance is on a clustered environment or not.
Discovery Methods
The methods used for instance discovery.
Custom Inventory Fields for Instances
Any custom inventory fields assigned to an Instance.
Tags for Instances
Any tags assigened to an instance.
Decommissioned Instances
...
SQL Server instance.
OS Version
The version
...
of the OS running the SQL Server instance.
...
Physical Cores
The
...
number of
...
available physical cores on the server.
Logical Cores
The number of
...
Size of Databases (MB)
The size of the databases on the SQL Server instance.
Owner
The owner name set during instance registration.
Location
The location name set during instance registration.
Clustered
Whether the instance is on a clustered environment or not.
Discovery Methods
The methods used for instance discovery.
Discovered Instances
...
Version
The version number of the SQL Server instance.
Edition
The edition number of the SQL Server instance.
Discovery Date
The Timestamp at instance discovery.
Discovery Methods
The methods used for instance discovery.
Ignored Instances
...
Version
The version number of the SQL Server instance.
Edition
The edition number of the SQL Server instance.
...
available physical cores on the server.
Physical Memory
The total available physical memory on the server.
CPU Name
The name of the CPU on the server.
CPU Speed
The speed of the CPU.
Clustered
Wheter it is a clustered instance or not.
Total Size of Disks for Instance
The total Disk space allocated for the instance.
Database Count
The total number of databases in the instance.
Total Database Size
The total size of databases.
Disk Percent Used by Databases
The disk space databases use.
Custom Inventory Fields for Instances
Any
Tags for Instances
any
Database Information at instance level
Database Name
Database Type (user or system)
Data Size
Log Size
Custom Inventory Fields for Database
Tags for Database
Decommissioned status