Asset Reporting - Databases

 

Use this report to view information about the databases within your environment. Some of the following fields are not available for all RDBMSs:

Database Information tab

Field Name

Description

Name

name of a database

Owner

owner of a database

RDBMS Type

RDBMS to which a database belongs (e.g., Sybase, Oracle, SQL Server, etc.)

Status

indicates whether a database is online or offline

Total Size of All Storage

total amount of storage space consumed by a database

Free Space of Data Files

amount of free space available in the data file(s) associated with a database

Mirror Overhead

amount of storage space allocated to the mirrored devices in an Instance

Data Freespace

amount of free space available in a database

Total Size of Empty Used Space

total size of storage allocated to a database but is not currently being used

Total Log Size

total size of a database log

Log Freespace

amount of freespace available in a database log

Number of Devices

number of devices on which a database resides

Number of Data Files

number of data files associated with a database

Number of Fragments

number of fragments associated with a database

Number of Tables

number of tables associated with a database

Number of Indexes

number of indexes associated with a database

Number of Other Objects

number of user-created objects that are not tables or indexes, such as rollback segments

Page Size

size of the pages associated with the database

Discovered Time

date/time when a database was discovered

Scan Time

date/time when a database was last scanned

Dropped Time

date/time when a database was dropped

 

 

Data File Information tab (SQL Server)

Use this tab to view information about the data files associated with a database.

Field Name

Description

Computer

name of the computer on which the data file resides

RDBMS Instance

name of the Instance on which a data file resides

Database

name of the database with which a data file is associated

Data File Path

fully-qualified path to the physical data file

Used Space

amount of storage space consumed by a data file

Percent Used

percentage of allocated space that a data file is consuming

Free Space

amount of free space available in a data file

Total Size

total size of a data file (Used Space + Freespace)

Auto Extend

indicates whether SQL Server should automatically increase the size of data files when they fill up with data

Growth

percentage that a data file will grow if it becomes full

Maximum Size

maximum size to which SQL Server will auto extend a data file

Create Time

date/time when a data file was created

Discovered Time

date/time when a data file was discovered

 

Log File Information tab (SQL Server)

Use this tab to view information about the log files associated with a database.

Field Name

Description

Computer

name of the computer on which a log file resides

RDBMS Instance

name of the Instance on which a log file resides

Database

name of the database to which a log file is associated

Log File Path

fully-qualified path to the physical log file

Total Size

total size of a log file (Used Space + Freespace)

Auto Extend

indicates whether SQL Server should automatically increase the size of log files when they fill up with data

Growth

percentage that a log file will grow if it becomes full

Maximum Size

maximum size to which SQL Server will auto extend a log file

Create Time

date/time when a log file was created

Discovered Time

date/time when a log file was discovered

 

Device Detail Information tab (Sybase)

Use this tab to view information about the devices associated with a database.

Field Name

Description

Device Name

name of the device(s) associated with a database

Computer

name of the computer on which a device resides

RDBMS Instance

name of the Instance on which a device resides

Device Path

fully-qualified path to the physical device file

Free Space

amount of free space available in the data file

Percent Free

percentage of allocated space for a device that is unused

Used Space

amount of storage consumed by a device

Total Size

total size of a device (Used Space + Freespace)

Fragments

number of fragments associated with the device

Low

low page number in a device. This number is derived from the Sybase system table sysdevices.

High

high page number in a device. This number is derived from the Sybase system table sysdevices.

Mirror Path

fully-qualified path to device mirror

Discovered Time

date/time when a device was discovered

Dropped Time

date/time when a device was dropped

 

Fragment Detail Information tab (Sybase)

Use this tab to view information about the fragments associated with a database.

Field Name

Description

Computer

name of the computer on which a fragment resides

RDBMS Instance

name of the Instance on which a fragment resides

Fragment Path

fully-qualified path to the physical fragment file

Used Space

amount of storage consumed by a device

Percent Used

percentage of allocated space that a fragment is consuming

Free Space

amount of free space available in the fragment

Total Size

total size of a fragment (Used Space + Freespace)

Data Type

indicates if a fragment is used to store Log Data, Object Data, or both

Create Time

date/time when a fragment was created

Discovered Time

date/time when a fragment was discovered