BMC Communities: Message List - remedy oracle query for incidents

Re: remedy oracle query for incidents

forums@developer.bmc.com — Wed, 25 Feb 2009 14:21:49 GMT

Hi,

I've a question.. Does anyone know in which Table, Template is stored in Remedy?

Re: remedy oracle query for incidents

forums@developer.bmc.com — Fri, 21 Nov 2008 06:37:35 GMT

attached documents are saved in a different table:

T tables for data.

B Tables for Attachments.

H Tables for status history field.

Like in my database I have T185 for Heldpesk ticket data, B185 for attachments, H185 for status history.

Go to Entbase->Enterprise Manager-> Server-> database-> ARSystem-> ur table.

Let me know if this helps!!!!!!!!!!!

I can help u further.

Thanks

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 21:44:33 GMT

Carey,

For every Attachment field in the form, a separate table is created to store the attachment value. Please, read "BMC Remedy Action Request System 7.x Database Reference" document, on page 31 for more information.

Jose Luis Rubio

www.bmc.com

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 21:38:51 GMT

I aplogize for so many questions...

do you know where attached documents are stored?

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 19:23:19 GMT

Hi again,

HPD_Helpd_Desk.Detailed_Decription is Notes field.

Regards

Jose Luis Rubio

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 19:10:58 GMT

Do you know where find the Incident NOTES column?

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 18:48:08 GMT

THANks for your help...

These are the tables the way there named in my db...

HPD_HELP_DESK

HPD_WORKLOG

HPD_HELP_DESK_ASSIGNMENT_LOG

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 18:16:00 GMT

i will take a look at the

HPD_HPD_HelpDesk HPD_HPD_Worklog and HPD_HPD_AssignmentLog.

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 18:15:04 GMT

Is there a way to get the current version out of the oracle database?

The user version is:

BMC Remedy User
Version 7.0.01 Patch 006

Re: remedy oracle query for incidents

forums@developer.bmc.com — Tue, 18 Nov 2008 16:47:39 GMT

Hi Carey,

Main DB table is HPD_HPD_HelpDesk. It is contains information about all incidents registered on your ITSM system. Other important tables are HPD_HPD_Worklog and HPD_HPD_AssignmentLog.

Thanks and regards,