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)`

Operations Manager i10.62

Develop > Service Health > Service Health External APIs > Service Health Database Query API

Service Health Database Query API

You can use the Service Health API to query the database and return a list of views in XML format.

Tip You can use XSLT to convert the XML output into any other format (commonly text or HTML). For example, using basic XSLT transformations, you can produce HTML reports that are formatted to fit on mobile devices. These reports can be served via a mobile portal to display critical Operations Manager i views on users' mobile phones.

Main Parameters Used in the Query

The following table lists the parameters that must be defined in the query.

Parameter	Description
customerID	OMi customers should specify 1.
userName	Specify a user name defined in OMi. The query does not encrypt the login credentials.
password	Specify the password for the user name provided. The query does not encrypt the login credentials.
command	Specify one of the following values: getViews – Specify to retrieve all views from the Run-time Service Model (RTSM). No other parameters are required. getNodes – Specify to retrieve all child nodes of a specified view (you must also specify the view for which to retrieve child nodes in the viewName parameter); if using this command parameter you can also set the following parameters: showTooltip, depth, layout, xsltURL, responseContentType
viewName	If the getNodes command parameter is defined, include this parameter in the query and specify the view to retrieve. You can set the value to ticker_all_views to retrieve all views and their nodes.
showTooltip	If the getNodes command parameter is defined, you can include this parameter in the query to specify whether to display Service Health's KPI tooltip data, either true to display data or false to not. The default value is false.
depth	If the getNodes command parameter is defined, you can include this parameter in the query to specify the number of levels in the view to display. The default value is 1.
layout	If the getNodes command parameter is defined, you can include this parameter in the query to specify the layout for the query results, either hierarchical or flat. In flat mode all nodes are retrieved in a flat list, and in hierarchical mode nodes are retrieved in the same hierarchy as in the view. The default value is flat.
xsltURL	If the getNodes command parameter is defined, you can include this parameter in the query to specify a URL to an .xslt file that transforms the .xml-format result of the query.
responseContentType	If the getNodes command parameter is defined, and the xsltURL parameter is included in the query, you can include this parameter in the query to specify the response MIME type.

Send Help Center feedback