BMC Communities Banner
Up to Discussions in BMC Remedy AR System

This Question is Answered

1 "helpful" answer available (5 pts)
11 Replies Last post: Feb 25, 2009 8:21 AM by giveme  
Carey Hollenbeck Participant
Carey Hollenbeck
10 posts since
Nov 18, 2008
Currently Being Moderated

Nov 18, 2008 10:32 AM

remedy oracle query for incidents

Hi

 

What table/s contain the incidents in remedy?  All Im looking to do is run a few oracle sql statemenst to retrieve incident information from remedy.

Nyall McCavitt Enthusiast
Nyall McCavitt
39 posts since
Jun 26, 2007
Currently Being Moderated
1. Nov 18, 2008 10:46 AM in response to: Carey Hollenbeck
Re: remedy oracle query for incidents

Hi,

 

The answer will depend on which version of the ITSM Suite you are running.

 

If you can provide the version then I'm sure that someone will be able to provide you with the relevant answer.

 

Thanks.

 

Nyall

 

Report Abuse
jlrubiofr Enthusiast
jlrubiofr
69 posts since
Jun 27, 2007
Currently Being Moderated
2. Nov 18, 2008 10:47 AM in response to: Carey Hollenbeck
Re: remedy oracle query for incidents

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,

Report Abuse
Carey Hollenbeck Participant
Carey Hollenbeck
10 posts since
Nov 18, 2008
Currently Being Moderated
3. Nov 18, 2008 12:15 PM in response to: Nyall McCavitt
Re: remedy oracle query for incidents

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 

Report Abuse
Carey Hollenbeck Participant
Carey Hollenbeck
10 posts since
Nov 18, 2008
Currently Being Moderated
4. Nov 18, 2008 12:16 PM in response to: jlrubiofr
Re: remedy oracle query for incidents

i will take a look at the

HPD_HPD_HelpDesk  HPD_HPD_Worklog and HPD_HPD_AssignmentLog.

Report Abuse
Carey Hollenbeck Participant
Carey Hollenbeck
10 posts since
Nov 18, 2008
Currently Being Moderated
5. Nov 18, 2008 12:48 PM in response to: Carey Hollenbeck
Re: remedy oracle query for incidents

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 

Report Abuse
Carey Hollenbeck Participant
Carey Hollenbeck
10 posts since
Nov 18, 2008
Currently Being Moderated
6. Nov 18, 2008 1:10 PM in response to: jlrubiofr
Re: remedy oracle query for incidents

Do you know where find the Incident NOTES column?

Report Abuse
jlrubiofr Enthusiast
jlrubiofr
69 posts since
Jun 27, 2007
Currently Being Moderated
7. Nov 18, 2008 1:23 PM in response to: Carey Hollenbeck
Re: remedy oracle query for incidents

Hi again,

 

HPD_Helpd_Desk.Detailed_Decription is Notes field.

 

Regards

 

Jose Luis Rubio

Report Abuse
Carey Hollenbeck Participant
Carey Hollenbeck
10 posts since
Nov 18, 2008
Currently Being Moderated
8. Nov 18, 2008 3:38 PM in response to: jlrubiofr
Re: remedy oracle query for incidents

I aplogize for so many questions...

 

do you know where attached documents are stored?

Report Abuse
jlrubiofr Enthusiast
jlrubiofr
69 posts since
Jun 27, 2007
Currently Being Moderated
9. Nov 18, 2008 3:44 PM in response to: Carey Hollenbeck
Re: remedy oracle query for incidents

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

Report Abuse
Jyoti Verma Enthusiast
Jyoti Verma
40 posts since
Sep 24, 2008
Currently Being Moderated
10. Nov 21, 2008 12:37 AM in response to: Carey Hollenbeck
Re: remedy oracle query for incidents

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

Report Abuse
giveme Participant
giveme
3 posts since
Feb 25, 2009
Currently Being Moderated
11. Feb 25, 2009 8:21 AM in response to: Jyoti Verma
Re: remedy oracle query for incidents

Hi,

 

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

Report Abuse

More Like This

  • Retrieving data ...