SMS Adapter Configuration Files

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

The adapter includes the following configuration files:

orm.xml. The Object Relational mapping file, which maps between SCCM/SMS database tables and columns, and UCMDB classes and attributes. Both CIs and links are mapped.

fixed_values.txt. Used by the Generic DB Adapter to set the ip_domain of IP Address CIs to DefaultDomain.

plugins.txt. Contains configuration information for the Generic DB Adapter. Also defines three plug-ins that are used during replication: getFullTopology, getChangesTopology, and getLayout.

transformations.txt. Contains the configuration for transformation of attribute values. For a list of the transformations, see Transformations.

node.discovered_os_name.transformer.xml. Mapping used by the transformer for the host_isdesktop attribute.

node.host_osinstalltype.transformer.xml. Mapping used by the transformer for the host_os attribute.

host.host_osinstalltype.transformer.xml. Mapping used by the transformer for the host_osinstalltype attribute.

nt.nt_servicepack.transformer.xml. Mapping used by the transformer for the nt_servicepack attribute.

replication_config.txt. Contains a comma-separated list of non-root CIs and relations types that have a timestamp condition in the SCCM/SMS database. This status condition indicates the last time the entity was updated.

reconciliation_types.txt. Defines the CI types that are used for reconciliation.

For details on adapter configuration, see "Developing Generic Database Adapters" in the HPE Universal CMDB Developer Reference Guide.