Page History
Users can deploy Chargeback reports
Chargeback report 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
...
:
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 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 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
...
Each custom inventory field should be a separate column with the label “Custom Inventory Field” + Numbering and with the name of the field Append to it. For example, “Custom Inventory Field #1: Department”
...
The value for the specific custom field will be populated for each record
...
Any
Tags for Instances
This should be a comma separated list of tags, allowed to word wrap
any
Database Information at instance level
...
Database Name
Database Type (user or system)
Data Size
Log Size
Custom Inventory Fields for Database
Each custom inventory field should be a separate column with the label “Custom Inventory Field” + Numbering and with the name of the field Append to it. For example, “Custom Inventory Field #1: Department”
Tags for Database
...
This should be a comma separated list of tags, allowed to word wrap
...
Decommissioned (yes/no)
Decommissioned status
...
Provide parameters for this report:
Instance Tags
SQL Server Version
Edition
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.
Excerpt |
---|
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
...