Inventory and Usage Details

5 Inventory and Usage Details

This chapter describes the features and how to access the Inventory and Usage Details page (Figure 5-1) for the Microsoft SQL Server.

Figure 5-1 Microsoft SQL Server Inventory and Usage Details Page

With the Inventory and Usage Details page you can:

View inventory summaries for your Microsoft SQL Server databases.
View inventory summary information in the context of different dimensions such as version, platform, OS version and vendor, life cycle, department, location, and cost center.
Drill down multiple levels of inventory details.
View to a pie chart to break down the inventory data for the roll-up option by color-coded percentages.
Repeatedly revise selections to refresh chart and details based on new selections.
Export deployment and details tables as a .csv file.

To view inventory and usage details:

From the Enterprise menu, select Configuration, and then select Inventory and Usage Details.

Alternatively, you can click Details in the Inventory and Usage region of the Enterprise Summary page.
Select the entity you want to examine and choose a roll-up option. For example, show all deployed hosts rolled up by platform. The page refreshes automatically upon selection.
In any given row in the top table, there is a count bar next to the count that represents a percentage of the maximum count. For example, if the maximum number of hosts by platform is four, the bar for hosts represented on two platforms would be half as long. Click the bar to refresh the details table and chart for the row.

For further information, see the Working with Inventory and Usage Details section of the Oracle Enterprise Manager Lifecycle Management Administrator's Guide.