SQL Size ships with a default template for the reports, and is formatted as follows:

You can create a new template based off this default template, and use your customized template for the reports.

The report elements are represented by tags e.g. [INSTANCE], [DATABASE], [DBFILES] etc. They must be displayed in a hierarchical order as follows:

1.

instance details

2.

database details

3.

database file details

Instance details

The following tags are available at the instance level:

[INSTANCE] The instance name. [INSTANCEDBCOUNT] The number of databases for this instance. [INSTANCETOTALDBSIZE] The size of all databases for this instance. [TIMESTAMPSTART] The earliest date size data is available for this instance, based on the date range you chose to report on. [TIMESTAMPEND] The latest date size data is available for this instance, based on the date range you chose to report on.

Database details

[SEQUENCE] The sequence number of the database for the current instance. [DATABASE] The database name. [DBSIZEELEMENTS] Displays a stacked bar chart made up of the data files, transaction log, and filestream components. [DBSIZEELEMENTSRELATIVE] Displays a stacked bar chart made up of the data files, transaction log, and filestream components, relative to the largest database for the current instance. [DBSIZETREND] Displays the database growth trend. [TOTALSIZE] Displays the database's size. [DATASIZE] Displays the database's data files size. [LOGSIZE] Displays the database's transaction log size. [FILESTREAMSIZE] Displays the database's filestream size.

Database file details

[DBFILES] Displays for each of the database's files, its logical file name. [DBFILESPHYSICALNAME] Displays for each of the database's files, its physical file name.

The [ADJUSTWIDTH] tag

This tag is used to indicate that SQL Size should adjust this column's width to display all its contents.