How to generate a custom report with database name and the associated data size, data used size, dat (4331619)

How to generate a report with data that is found in the GUI portion of Foglight under the databases dashboard, SQL server databases, database home, selecting the data files, and selecting the "Investigate using the "File Groups" drilldown". The data listed on the dashboard indicates the database name and the associated data size, data used size, data free space, log size, log used size, log free size, # Tables, # Indexes, # File Groups( Like show below)

How

Here are the detailed instructions to generate report with data size, data used size, data free space, log size, log used size, log free size, # Tables, # Indexes, and # File Groups

1. Click “Add view”
2. Expand “Management Server”| “All Data” | “DBSS_Data_Model” |“SQL-Server Data Model” | “Clusters”
3. Expand appropriate agent <Agent name-Instance name> | “Instances” | Expand appropriate agent <Agent name-Instance name>
4. Expand “Databases” | Expand appropriate database | Expand “File Groups”
5. Select “Primary”, Make sure “Property View” is selected and click “Next”
6. Make sure “Name-Value List” is selected under view styles and Select “Total MB”( For “Data Size”) | | Select “File Used MB” (For “Data Used Size”) | Select “File Group Free MB”( For “Data Free Size”) | Select “File Count” (For “# of File Groups’) , Click next and finish.
7. Click “Add view”
8. Expand “Management Server”| “All Data” | “DBSS_Data_Model” |“SQL-Server Data Model” | “Clusters”
9. Expand appropriate agent <Agent name-Instance name> | “Instances” | Expand appropriate agent <Agent name-Instance name>
10. Expand “Databases” | Expand appropriate database | Expand “File Groups”
11. Select “Log”, Make sure “Property View” is selected and click “Next”
12. Make sure “Name-Value List” is selected under view styles and Select “Total MB” (For “Log Size’) | Select “File Used MB” (For “Log Used Size”) | Select “Total Group Free MB” (For “Log Free Size”) , Click next and finish.
13. Click “Add view”
14. Expand “Management Server”| “All Data” | “DBSS_Data_Model” |“SQL-Server Data Model” | “Clusters”
15. Expand appropriate agent <Agent name-Instance name> | “Instances” | Expand appropriate agent <Agent name-Instance name>
16. Expand “Databases” | Expand appropriate database
17. Select “Table Count”( For “# Tables”) , Click next and finish.
18. Click “Add view”
19. Expand “Management Server”| “All Data” | “DBSS_Data_Model” |“SQL-Server Data Model” | “Clusters”
20. Expand appropriate agent <Agent name-Instance name> | “Instances” | Expand appropriate agent <Agent name-Instance name>
21. Expand “Databases” | Expand appropriate database
22. Select “Index Count”( For “# Indexes”) , Click next and finish.
23. And click “Run report” on the mail report page to generate a report.

If you need any other metrics than above regarding a specific database you can find them all under

Dashboards > Configuration > Data > and

1. Expand “Management Server”| “All Data” | “DBSS_Data_Model” |“SQL-Server Data Model” | “Clusters”
2. Expand appropriate agent <Agent name-Instance name> | “Instances” | Expand appropriate agent <Agent name-Instance name>
3. Expand “Databases” | Expand appropriate database