Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

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





Scroll Ignore

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...

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 > >

...