Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Where are all the Custom Fields in the database?

SOLVED
Go to solution
Highlighted
Envoy2064
Super Collector

Where are all the Custom Fields in the database?

Can anyone tell me where I can find all the custom fields in the database related to Configuration Items? (Table and column(s)). I'm trying to use SQL to extract certain custom field values directly from the database associated with Configuration Items... Thanks in advance!
3 REPLIES
Mihai Tita
Occasional Visitor
Solution

Re: Where are all the Custom Fields in the database?

Hi,

HPOVSD 4.5

ITSM_CIT_CUSTOM_FIELDS table

For columns use SELECT statemet

Regards,
Mihai
Envoy2064
Super Collector

Re: Where are all the Custom Fields in the database?

How do I tie the custom field data to a particular Configuration Item? Is the "user-entered" text in the same table?
Mihai Tita
Occasional Visitor

Re: Where are all the Custom Fields in the database?

Hi,

SELECT T1.*, T2.*
FROM itsm_configuration_items T1
INNER JOIN itsm_cit_custom_fields T2 ON (T2.ccf_cit_oid = T1.cit_oid)

Regards,
Mihai
//Add this to "OnDomLoad" event