How do I determine the total number of JSD "request types" in my Jira Service Desk instance?

[Larry Brock]

For auditing and sizing considerations, I need to count the total number of "Request Types" across all JSD projects in my instance.  I've reviewed several system level reports with no luck.  Looks like this is going to be a direct database query so anyone know the table name containing the request types?

[Lenard Lee · Accepted solution]

Hi Larry,

If you are looking for a direct database query, perhaps the data from AO_54307E_VIEWPORTFORM table would be what you are looking for.

Regards,

Lenard

[Susan Hauth _Jira Queen_]

Hi Larry, Lenard,

That's really interesting that the db table name is "VIEWPORT..".  Here's some trivia, did you know that the original name for Service desk was "View Port"

Cheers

Susan