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

Information on SD Table/View

Highlighted
Syed Mazhar Has
Super Collector

Information on SD Table/View

Hi Guyz,

May i know view/table used by SD to store the values of number of service calls logged, time of creation etc..

Thanks in Advance..

Regards
Syed Mazhar Hasan
2 REPLIES
Anda Apine
Member

Re: Information on SD Table/View

Which version of Service Desk you have?

In 4.5 there was table ITSM_Servicecalls - or something like that.

Anda
George M. Meneg
Honored Contributor

Re: Information on SD Table/View

Hello,

The table where service call are stored is itsm_servicecalls. Custom fields are stored on itsm_ser_custom_fields.

You can find a visio file that displays service call relations at http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=448888
and on http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=448890

There is also the v_servicecalls view
menes fhtagn
//Add this to "OnDomLoad" event