Gererate dat

[Swaroop]

HI Team,

My Manager is asking to generate below data in bulk way, Can you please confirm is there any way to find.

1) Login 

2)Project start date - We have only option is to find in Audit Log 

3) Project using type of board - Scrum / Kanban / or both 

4) Split of issue counts for each of Epic, User story, user story, Bug .. (We have 25 thousand issues in all projects)

5)Number of attachment's where applicable and if possible their sizes 

(Note: we can find 1,2,,3,4 points by project to project but we need as a bulk date in our JIRA for 5 th I dont no)

Thanks in advance 

[Nic Brough -Adaptavist-]

1. What do you mean by "login"?
2. Jira does not record when a project is created, apart from a line in the audit log.  Project creation is not necessarily the project start date either, that's probably something you want to record elsewhere (or have a rule to derive it, like "project start date = creation date of the first issue created in the project).  You'll need to write some report to get this out en-masse, and it depends on your rule for what the date is
3. You have to look at the project view for each one in turn, bearing in mind that boards are not project objects, they're independent, may include many projects, and a project may display many boards of different types
4. Create a filter that returns all your issues (blank, or just "order by created" will do it).  Save it, and use it in a "filter statistics" gadget.  If you select "issue type" as the grouping statistic, it will tell you how many issues of each type there are.
5. There's no reporting in Jira for this, but the easy way to do it is log into the server, go to the directory <Jira data>/attachments and use du -d1 to get the size of the attachments for each project (the attachments directory is split up by project, with each issue then having its own subdirectory), and find or ls to get lists of attachments so you can get the counts out.

May we ask what you are trying to do this for?  What problem do you have that makes your managers ask for this data?

[Swaroop]

HI Nic,

Thanks for your quick response, 

1) login ID means lead USER ID (When we create JIRA account that time we will create user Email and and USER ID )

When I told to my Manger it is not possible he was saying connect with db ang get the data 

We are using POST GRESS SQL, Can you please send the query how to check the DB 

Thanks 

[Nic Brough -Adaptavist-]

Ok, so you're not going to get the "login".  You can read for user id, but Jira doesn't store the date of creation.  If you're not using the internal user directory, you'll need to check your directory system - some of them do record when users are created.

I can't give you SQL for any of your questions, I don't have the time or energy to work out the hideously messy non-performant SQL would be.  It is going to be far quicker, and probably more informative, to do it by hand, as I've suggested in answers 2-5.