Service Desk Practitioners Forum
cancel

CMDB Data Model anywhere?

Highlighted
Himmel_1
New Member.

CMDB Data Model anywhere?

Hi all!

I'm trying to get familiar with the HP Openview CMDB. Is there a Physical or Logical Data Model out there? No matter which format...

Any help would be appreciated!
5 REPLIES
George M. Meneg
Acclaimed Contributor.

Re: CMDB Data Model anywhere?

Hello,

Execute this query to fetch all items, attributes and their relations. If you want to list only configuration item just add

"and tab.tab_name
in ('itsm_configuration_items', 'itsm_cit_custom_fields', 'itsm_cit_cft001')"

to the query.

select ent.ent_name, lal.lal_text as 'Label',
(lower (tab.tab_acronym) + '.' + col.col_name) as 'column', tab.tab_name,
atr.atr_name, atr.atr_computed as 'computed?', atr.atr_customfield as 'custom?',
atr.atr_custfieldact as 'activated?' ,att.att_name as 'type',
ent.ent_name as parent_ent, (lower (tab2.tab_acronym) + '.' + col2.col_name)as 'column',
tab2.tab_name
from ifc_columns col
inner join ifc_tables tab on col.col_tab_oid=tab.tab_oid
inner join ifc_attributes atr on col.col_atr_oid=atr.atr_oid
inner join ifc_attrib_types att on att.att_oid=atr.atr_att_oid
inner join rep_labels_locale lal on atr.atr_lbl_oid=lal.lal_lbl_oid
inner join ifc_entities ent on col.col_ent_ref=ent.ent_oid
inner join ifc_entities ent2 on atr.atr_ent_oid=ent2.ent_oid
left outer join ifc_columns col2 on col.rel_col_to=col2.col_oid
left outer join ifc_tables tab2 on col2.col_tab_oid=tab2.tab_oid
where lal.lal_lng_oid=1033
order by ent.ent_name asc, lal.lal_text asc
menes fhtagn
Guenther Schere
Honored Contributor.

Re: CMDB Data Model anywhere?

Hi Himmel,

I've got an overview somewhere from this forum.
Don't kown there is the link, so I try to attach it. I hope it's official.
Guenther Schere
Honored Contributor.

Re: CMDB Data Model anywhere?

Hi Himmel,

and the second.
Himmel_1
New Member.

Re: CMDB Data Model anywhere?

Hi!

Thanks! Great! That's what I was looking for!

I am evaluating Version 5, but I think the diagrams from Version 4.5 will help me in the first run!

Carol Hibbard
Acclaimed Contributor.

Re: CMDB Data Model anywhere?