DB push adapter - get result from 2 Ci's and dump in to one table with respect to relation of CI's

Hi

 

I have tried to use the DBPush example, to extract selected CI's and their relation.

 

I have tried to use the xml mapping file, to define two CI's to pull data from to one target.

My result is at best a line for each CI (objectID) in the Database.

 

As far as I understand, this is the key challenge for me. the objectID, I can't seem to get any function out of changing the primarykey in the mapping, the ID related to the COUNTER seem to stick. (the jython script also uses hardcoded where clause on update, that uses the ID)

 

An example of my wanted result:

UCMDB CI's created for the TQL = nt(root) - containment - IpAddress

Mappings = nt(root) -> WindowsPrimary (SQL table manually created, WindowsGlobal_id) and IpAddress -> WindowsPrimary (SQL table manually created, with attribute IpAddressGlobal_id)

 

my log from the probe says it registers different objects, which gives different lines in the table, e.g.

ID   |   WindowsGlobal_id  | IpAddressGlobal_id

1          23kni h245o 225..               null

2            null                                  frg22 23fff4 df2...

 

Is there any way of getting the result    :

ID   |   WindowsGlobal_id  | IpAddressGlobal_id

1          23kni h245o 225..               frg22 23fff4 df2...

or  with a different table                              

 WindowsGlobal_id  | IpAddressGlobal_id

 23kni h245o 225..               frg22 23fff4 df2...

 

 

An alternative, as far as I can read in the developer guide, is to use the enhanced, but I cannot seem to find a working example within the packages available to UCMDB 10.10 CUP2.

 

 

Best

Daniel