Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Configuration Management System (CMS)2018.05

Use > Modeling > Modeling > Reports > Reports User Interface > Database Breakdown Report

Database Breakdown Report

This report displays the breakdown of database types and versions. You can view all databases deployed in the system or the databases deployed at a specific location.

Report Example

Click thumbnail to view full size image.

To access

Select Managers > Modeling > Reports. In the Custom Reports pane, do one of the following:

Click the Create New Report button and select Database Breakdown Report.
Under Breakdown:
- Double-click Database Breakdown Report.
- Right-click Database Breakdown Report and select Create New Report.
- Select Database Breakdown Report, and drag it onto the right pane.

Relevant tasks

How to Generate a Custom Report

User interface elements are described below (unlabeled elements are shown in angle brackets):

UI Element (A-Z)	Description
<Bar graph/Pie chart>	Each segment of the pie chart/column in a bar graph represents a different database. Click a slice/bar to view the database sorted by version, and then click again to drill down to see the version information in table format. When you hold the mouse over each segment/bar, a tooltip indicates the name of the database, the number of CI instances found for each database, the percentage of the pie it represents (when viewing the information in pie chart format), and the CI type the slice/bar represents. The legend below the pie chart provides the name of each CI, and on the lower level, their versions.
<Breadcrumbs>	Displays the levels through which you have navigated to get to the current level. Appears horizontally across the top of the chart. Note Each level in the list of breadcrumbs is a clickable link.
<Shortcut Menu>	Drill down to the level of individual CIs and right-click a CI in the report to access the IT Universe Manager shortcut menu. For details, see IT Universe Manager Shortcut Menu.
<Toolbar>	For details, see Report Toolbar Options.
City	Select the city for which you want to view database breakdown data, or select All to show the breakdown for all cities. Note This is only relevant for CITs that contain data in the City attribute.
Country or Province	Select the country or province for which you want to view database breakdown data, or select All to show the breakdown for all countries or provinces. Note This is only relevant for CITs that contain data in the Country or Province attribute.
Include All Integration Points	Select the check box to include federated CIs in the report. When the check box is cleared, only local CIs are included in the report.
State	Select the state for which you want to view database breakdown data, or select All to show the breakdown for all states. Note This is only relevant for CITs that contain data in the State attribute.

Send Help Center feedback