The "Databases by Server" report does not show proper database sizes

Products

• IT Management Suite
• Inventory Solution

Issue/Introduction

Running the Inventory task to collect server inventory does not produce database sizes in the "Databases by Server" report.

Environment

ITMS 8.x

Inventory Solution 8.x

Cause

By default the Inventory task runs under the system account and may not have access to SQL server to obtain the desired inventory results.

Resolution

Configure the Inventory policy via the Advanced options to run the task under an account which has necessary rights to the SQL server.