Another way you could do that is to export the name and instance ID of the CIs, put those two columns into your relationship spreadsheet, and use the Vlookup formula in Excel to match the instance IDs up with the names in the relationships. Then load that sheet into the appropriate CMDB relationship class.
Rick On Oct 14, 2015 8:42 AM, "Transform IT, Inc." <[email protected]> wrote: > ** > > Abhishek, > > > > You can just create a new transformation with two CMDBLookup steps, one > for the Computer Systems you just created, and one for the Product CIs you > just created. Find the CIs you just created in the previous > transformations and bring the Instance ID of those CIs. Note: You will > need to have a primary key field on each table to be able to relate the two > CIs together. From there, make a CMDBOutput step and have it create the > relationship CIs in the BMC.CORE:BMC_HostedSystemComponent class by mapping > the CI Instance IDs you just retrieved and mapping them to the Destination > Instance ID and Source Instance ID fields. > > > > Hope this helps. > > > > Chris > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Abhishek Chaturvedi > *Sent:* Wednesday, October 14, 2015 5:26 AM > *To:* [email protected] > *Subject:* Automatically create relationship for CI from custom AI jobs > > > > ** > > Hi Team, > > I have custom AI job which brings in computer sysytem and related product, > I would like to know how can I automatically create relationship between > them. > > Thanks, > Abhishek. > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
