Idea ID: 1645979

Make Database Schema (Guide) available for OMi like it is for OMl / OMu

Status : Under Consideration
Under Consideration
See status update history
over 3 years ago

Make Database Schema (Guide) available for OMi like it is for OMl / OMu.

Logging this here per the MicroFocus support group::

Hello xxx,

I hope you are doing great.

My name is xxx and I will continue assisting you on this case. I checked in our documentation and unfortunately, as xxx mentioned, there is no information available for Database Schema or details about OMi DB tables, the only information available is what you can see in OMi Database Guide. I talked to an upper level and he confirmed this situation.

What you can do is open a new “Idea” mentioning that it can be useful to have detailed information about OMi DB Schema, this can be done in the following link:

That’s the new way to handle the Enhancement Request. Please let me know if you have any other question.

  •  - Event is not the only data which is stored in database and rest web Service requires programming skills and does not help with ad hoc requests.

    Certificate Management has no webservice at all.

    there are several use cases where we Need to find Information in database but without Schema it is difficult to find right table and then meaning of columns. even somehow we figure out which table, relationship to other table is not known.

    recent example was that i wanted to find out duplicate assignemnts of particular aspect(s), wrote a query but result was not correct due to the fact that  a coumn called deleted has to be "0" but without documented Information one has no idea and it is more Trial and error which is time consuming and error-prone.

    another example, after a recent IP Change of OMi we still see on Firewall that OMi makes Connection to old IP (disaster recovery step was followed) but as there is no document i can not check possible table for this reference. raised a Support case and it has been more than 3 weeks and Support is playing ping pong between ucmdb and omi. if there is document available i am sure i could figure it out in few hours and no Need to spend time with poor Support.

    I do not remember exact case but on many Occasion we try to find table in both Event and mgmt data as we have no idea what could be where?

    as i see there are 25 votes, i hope other can comment too.


  • , Can you please describe for what use cases, do you need it? As I mentioned before, we do provide rest web service interface to access the event data, is that not sufficient?

    Thanks & Regards,


  •  - Idea does not mention anything about classic or Containerized version of OMi. Personally i am looking it for classic version of OMi.


  • Hi , please refer to my last comments, we already have the documented schema available for COSO data lake. Does that meet the requirement?

    Thanks & Regards,

    Moderator, OpsB IdeaX

  • For OpsB Container with central COSO data store, we plan to provide the database schema documentation in the upcoming releases. However, for OBM classic, we are not able to define a timeline, even though we are open to the idea of providing the schema documentation.

    Thanks & Regards,

    Moderator, OpsB IdeaX