Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies reply
    1
  • Subscribers subscribers
    177
  • Views views
    193
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

join relationship returning not matches

Paul Meaders

I have a custom CI type (call it MyData for this question) that I am trying to use in an enrichment rule with the installed Software CIs.  The name attribute in MyData contains a Installed Software global id. The enrichment rule needs to match records where the MyData:Name equals Installed Software:Global id. The enrichment actions would update multiple Installed Software attributes based on the contents of the matching MYData CI.

I created an enrichment rule with a join relationship.  However when I calculate the results I get zero instances.  I have verified there are 30+ matches between the two CI types.

Is there something else I need to do?  I thought that was the purpose of the join relationship, to temporarily create a relationship between two CI types.

Thanks

Paul

  • 0

    I believe that I have resolved the issue, actually multiple issues.  First, the global ID is stored in the database using upper case letters and preceded by "0x".So I don't believe it is possible to use global id in the enrichment rule.  So I create a new attribute in installed software called "New Global ID" and an enrichment rule to populate it from the global id.  Checking in the database I verified that the contents of New Global ID were stored as a standard text string. The second issue was that MyData:Name had lower case checked in the attribute properties. So I created MyData:NewGlobalID and stored the global ID (using upper case) there.

    After making these changes my enrichment rule now works using a join between InstalledSoftware:NewGlobalID and MyData:NewGlobalID

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.