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?
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.