SQL Inventory Manager lets you see the details of the databases of your monitored instances. In order to access this information, go to the respective Instance details view, then go to the bottom section of this view to the list of databases and click the name of the respective database.
The Database details window opens and you can see the following information:
- Database details: instance and database name.
- Comments: You can use this field to type in comments that help you identify your database. Click the pencil icon first to start typing in the box.
- Tags: In this section you can view those tags assigned to your database. Click the pencil icon to edit these tags or add new ones.
- Database information: State, date created, data size, log size, last full backup, last log backup, last differential backup, last DBCC checkup, if it is a system database, compatibility level, owner, and the recovery model of the database (Simple, Full, Bulk logged).
- Database files: a list of all files in this database, their type, size, autogrowth settings, maximum size, and file paths.