SCCM/SMS Integration Package

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

Transformations

Following is the list of transformations that are applied to values when they are transferred to or from the SCCM/SMS database:

CMDB Class	Attribute	Transformation
windows	nt_servicepack	Represents number of the Windows service pack. SCCM/SMS DB: Service Pack 2 UCMDB: 2.0 Transformer: standard GenericEnumTransformer, mapped in the nt.nt_servicepack.transformer.xml file.
node	host_isdesktop	A Boolean value that determines whether a machine is a desktop or a server. SCCM/SMS DB: Workstation or Server UCMDB: true or false Transformer: standard GenericEnumTransformer, mapped in the node.host_isdesktop.transformer.xml file.
node	host_os	Represents the node's operation system. SCCM/SMS DB. Microsoft Windows XP Professional UCMDB. Windows XP Transformer. Standard GenericEnumTransformer, mapped in the node.discovered_os_name.transformer.xml file. If the SCCM/SMS operation system value is not listed in the transformer.xml file, the original value is sent to UCMDB. By default, only Windows operating systems are mapped.
node	host_osinstalltype	Represents the Windows OS edition. SCCM/SMS DB. Microsoft Windows XP Professional UCMDB. Professional Transformer. Standard GenericEnumTransformer, mapped in the host.host_osinstalltype.transformer.xml file. Note: The same column in the SCCM/SMS database is mapped to two different UCMDB attributes, using different transformers.
disk device	name	Represents the partition name. SCCM/SMS DB. C: UCMDB. C Transformer. standard AdapterToCmdbRemoveSuffixTransformer that removes the colon.
interface	interface_macaddr	Represents the MAC address of NIC. SCCM/SMS DB. AB:CD:EF:01:23:45 UCMDB. ABCDEF012345 Transformer. custom SmsMacAddressTransformer that removes the colons from the SCCM/SMS MAC address while making it compatible with the UCMDB MAC addresses.

SCCM/SMS Plug-in

The SmsReplicationPlugin provides enhanced functions to those found in the Generic Database Adapter. It is called when:

full topology is requested (getFullTopology) – this returns all the CIs that were found in the external SCCM/SMS database.
topology layout is requested (getLayout)
topology of changes is requested (getChangesTopology) – this returns only the CIs that are modified or added after a specific time. The topology of the changes is calculated as follows:
- There is a specific date (fromDate) after which all changes are requested.
- Most of the entities in the SCCM/SMS database contain a Timestamp column that contains the date and time of the last modification. This Timestamp column is mapped to the root_updatetime attribute of a CI. Currently, some entities do not contain any creation time information. The entities that have a timestamp column must be listed in the replication_config.txt file.
- In the integration TQL query, the node CI is named Root.
- Using the plug-in, the integration TQL query is dynamically modified so that each Root entity and all entities that are listed in the replication_config.txt file have an additional condition causing the value of the root_updatetime attribute to be greater than or equal to the fromDate value.
- This modified TQL query is then used to obtain the data.