Service Desk Practitioners Forum
cancel

Table information in Service Desk

SOLVED
Go to solution
Highlighted
DAVID JIMENEZ_2
Respected Contributor.

Table information in Service Desk

Hello:

I'm working with Service Desk 4.5 SP24, installed on windows 2003 server. I'm doing a report through a business intelligence application above quality of service. I'm having problems to find a sql table with priority information. I need to find a table which relating the priority name (low, high, ..) with its ID. I've found a table called ITSM_PRIORITYIMPACTSETTINGS and other called ITSM_SERVICECALLS with the priority ID, but not with the priority name. Could anybody help me for this?

Thank you very much in advance,

David
5 REPLIES
Thorfinn Thomas
Super Contributor.

Re: Table information in Service Desk

Hi

In version 5.0, the table for priority text is called hpovsa.rep_codes_text.
I do not know v4.5, but I thought that the table name from 5.0 might help you identify the one you're looking for.

It is rep_codes_name.rct_name that holds the priority names.

Don't know if it helps, but it is what I have to offer.

regards,
Thorfinn
Thorfinn Thomas
Super Contributor.

Re: Table information in Service Desk

Hi again.

The second last patagraph should read:
"It is rep_codes_text.rct_name that holds the priority names."

Thorfinn
DAVID JIMENEZ_2
Respected Contributor.

Re: Table information in Service Desk

Hello everybody:

Thanks for your answers. I have been seeing and I've found many codes, but anything related with priority. In the other tables before mentioned, I found that the priority codes are the following one:

3094610072
3094610073
3094610074
3094610075
3094610076

These codes don't appear in this table or I don't see it (at least in 4.5 release). Any idea?

Best regards,

David
Thorfinn Thomas
Super Contributor.
Solution

Re: Table information in Service Desk

Hi again

It looks to me like ITSM_SERVICECALLS.SER_PRI_OID points to the priority in table ITSM_CODES, and that the text for that priority might be stored in ITSM_CODES_LOCALE, having ITSM_CODES_LOCALE.CDL_COD_OID pointing to the entry identified by ITSM_CODES.COD_OID.

Regards,
Thorfinn
DAVID JIMENEZ_2
Respected Contributor.

Re: Table information in Service Desk

Thank you very much to everybody (especially to Thorfinn).

David