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 Verified Answer
  • Replies reply
    1
  • Subscribers subscribers
    179
  • Views views
    124
  • Users 0 members are here
  • +1 person also asked this people also asked this
Related
Options

How can We get Ci Details using IP Address

Ahmed Sobhy

Hello Opentext Experts 

we need to integrate the ucmdb with a compliance manger Application 

the use case is to get the Ci Details using the any IP Address which a belong to this CI , 

we're trying to  get he Ci details using the REST API  "POST /exposeCI/getInformation"  but you must pass the Ci ucmdb ID to the Endpoint header , we need to get the Ci information using any IP Address which belongs to the CI.

Any recommendations Please , if any one have a knowledge How can we get CI details Directly from the ucmdb External SQL database , please clarify ..?

thanks and Best Regards

Tags:

  • Verified Answer

    +1

    Dear Ahmed,

    If you will use SQL query instead of REST API, there should be VIEWs in the UCMDB's external database NODE_1, CONTAINMENT_1, IP_ADDRESS_1  and I think you can execute the following SQL query to get required information. You can modify the query as your requirements. 

    Hope it helps...

    SELECT NODE.A_NAME as hostname, IP.a_name as ip

    FROM NODE_1 NODE, CONTAINMENT_1 rel, IP_ADDRESS_1 IP

    WHERE IP.cmdb_id = rel.end2_id and NODE.cmdb_id = rel.end1_id

    Kind regards,

    Taylan

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.