Service Desk Practitioners Forum
cancel

Servicedesk 4.5 database tables

Highlighted
Srilakshmi
Contributor.

Servicedesk 4.5 database tables

I want the details about servicedesk 4.5 database tables i.e what are the database coulmn names corresponding to field names in servicedesk forms.

hw to find the parent child relation ship between the items in the classification field i.e for one parent list of childs are linked and in trun child is linked with list of subchilds.What is the relation table name which links parent with child and subchild.
5 REPLIES
Mohammed Albust
Honored Contributor.

Re: Servicedesk 4.5 database tables

If you are using SQL database, go to enterprise manager, databases, select the database for servicedesk, go to tables. you will find all the tables you're looking for.
Srilakshmi
Contributor.

Re: Servicedesk 4.5 database tables

ya I have the tables bt what i am looking at is the table which gives the information of parent and child relation of items listed in one classification
eg
First level classification is Network in that i have 1)router
2)switch
in router i have 1)cisco
2)nortel
in that i have sub classification as
problem with software
hardware problem

Network
Router
Cisco
problem with software
hardware problem
Nortel
problem with software
hardware problem
Switch
abc
problem with software
hardware problem
xyz
problem with software
hardware problem


I want to know where can i get the table which gives the information on the relation of this parent node with child, subchild,susub child so that i can filter the tickets which are classified under 4level classification with the SQL queries
Alexey Dukov
Outstanding Contributor.

Re: Servicedesk 4.5 database tables

Hi Srilakshmi!!!
If you give your email adress i send you visio files with structure or sd 4.5 database. There you can find all fields,avaliable in Service Desk.

Also if you need build directory like tree in SD, use a field lice Category.
In system--> data--> custom fields. Then find field 'category'.

Hope this help.

Best regards,
Alexey.
Irina Bochaeva
New Member.

Re: Servicedesk 4.5 database tables

Hello. On the SD4.5 disk you can find a document titled "HP OpenView Service Desk Data Dictionary Tables". The path to the file is \doc\Data Dictionary\html\Data_Dictionary_Tables.htm Contains table names, field names, corresponding attribute names, related tables names. Good Luck!
Loys
Outstanding Contributor.

Re: Servicedesk 4.5 database tables

Hi Srilakshmi,

The below query would give you the 4 level classification:

select 'level 1'=e.cdl_name,a.cod_oid,'level 2'=f.cdl_name,b.cod_oid,'level 3'=g.cdl_name,c.cod_oid,'level 4'=h.cdl_name,d.cod_oid from itsm_codes a
left join itsm_codes b on b.cod_cod_oid=a.cod_oid
left join itsm_codes c on c.cod_cod_oid=b.cod_oid
left join itsm_codes d on d.cod_cod_oid=c.cod_oid
left join itsm_codes_locale e on a.cod_oid=e.cdl_cod_oid
left join itsm_codes_locale f on b.cod_oid=f.cdl_cod_oid
left join itsm_codes_locale g on c.cod_oid=g.cdl_cod_oid
left join itsm_codes_locale h on d.cod_oid=h.cdl_cod_oid
where
a.cod_subtype=(select ent_oid from ifc_entities where ent_name='Service call Classification')
and a.cod_cod_oid is NULL
and b.cod_oid is not null
and c.cod_oid is not null
and d.cod_oid is not null

----------------------

And the below give the first level coressponding to fourth level


select 'level 1'=e.cdl_name,a.cod_oid,'level 2'=f.cdl_name,b.cod_oid,'level 3'=g.cdl_name,c.cod_oid,'level 4'=h.cdl_name,d.cod_oid from itsm_codes a
left join itsm_codes b on b.cod_cod_oid=a.cod_oid
left join itsm_codes c on c.cod_cod_oid=b.cod_oid
left join itsm_codes d on d.cod_cod_oid=c.cod_oid
left join itsm_codes_locale e on a.cod_oid=e.cdl_cod_oid
left join itsm_codes_locale f on b.cod_oid=f.cdl_cod_oid
left join itsm_codes_locale g on c.cod_oid=g.cdl_cod_oid
left join itsm_codes_locale h on d.cod_oid=h.cdl_cod_oid
where
a.cod_subtype=(select ent_oid from ifc_entities where ent_name='Service call Classification') -- Change for different Code name
and a.cod_cod_oid is NULL
and b.cod_oid is not null
and c.cod_oid is not null
and d.cod_oid is not null
and h.cdl_name ='Test Child2' --Give the fourth level value to get the first level oid and name


hope this helps ...

thanks
Loys