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

Idea ID 1645979

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

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: https://community.softwaregrp.com/t5/Operations-Bridge-Idea-Exchange/idb-p/OpsBridge_Idea_Exchange

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

8 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: New Idea

could you describe in detail why this is needed? OMi exposes some of its data through various REST webservice interfaces, is that not sufficient?

Thanks & Regards,

Mamta

Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
Micro Focus Expert
Micro Focus Expert
Status changed to: Under Consideration
 
Micro Focus Expert
Micro Focus Expert
Status changed to: Under Consideration

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

Micro Focus Expert
Micro Focus Expert

Hi @NetCodeMan , 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

Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

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

-KAKA-

Micro Focus Expert
Micro Focus Expert

@KAKA_2 , 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,

Mamta

Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

@Mgoyal - 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.

-KAKA-

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.