There is a Suggestion that you can find at JSDSERVER-1247 that has a query that should help you find what you're looking for:
In JIRA Service Desk, it is possible to view through which channel an issue was created:
SELECT DISTINCT p.pkey, ep.json_value, COUNT(ep.json_value) FROM entity_property ep JOIN jiraissue ji ON ep.entity_id = ji.id JOIN project p ON p.id = ji.project WHERE ep.property_key = 'request.channel.type' GROUP BY ep.json_value, p.id;
We normally test in Postgres so you will most likely need to modify the query for MSSQL, however, that should provide you a great starting point!
We have some issues (imported from Excel files) with "Channel: Unknown". In the database table entity_property there are no entries with PROPERTY_KEY = 'request.channel.type' for those issues.
Would you recommend to add them manually to the database table? I tried to add it for one issue and it seemed to work, but I didn't want to add all the entries before I am sure nothing will break.
By the way, we have to set the channel somehow because otherwise the requests are not shown in the Customer Portal (at least we think this is the reason, because the request type and everything else is set correctly).
Thanks in advance.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot