When the user exports an issue from Service desk to CSV(all fields) the "Customer Request type" do not show the actual name of the request type, instead it shows a code from it.
- Search for service desk issue that contains not default request types
- Click on Export Excel CSV (all fields)
On the exported csv, "Customer Request type" field shows the name of the request type.
Run this SQL query from the database:
NOTE this is written in PostgreSQL syntax and may need to be modified for for your database type:
Then base on the KEY to find the NAME.