Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

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

Larry Brock
Larry Brock
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
November 13, 2017

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?

Answer
Watch
Like Be the first to like this
572 views

1 answer

1 accepted

3 votes
Answer accepted
Lenard Lee
Lenard Lee
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 14, 2017

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

View More Comments
Susan Hauth _Jira Queen_
Susan Hauth _Jira Queen_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
November 14, 2017

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

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira Service Desk
Jira Service Management
TAGS
AUG Leaders

Atlassian Community Events

    See all events