Service Desk Practitioners Forum

Unreadable data Fields when exporting

Juan J Padilla
Trusted Contributor.

Unreadable data Fields when exporting

Hi All,

I'm using OV 4.5 (SP12).

When i'm exporting data from the database - via SQL statements - I'm getting certain fields with a weird format. An example:

When extracting the field "Item_Type", instead of, for example, "Problem", we get a number like "717488173". I guess it would be the same, but with a different number when trying to get Service Calls.

Is there a specific table which I have to use in order to get the proper information extracted?