Need to find the user account

Question

Hi,

Please do help me on this. My organization JIRA account holds the user account which is not an employee's mail id but a team mail id.

For example if my user account is like "security.xx@yy.com" this mail id doesn'y belong to one employee it's team mail id and it is added as a user account in jira.

Is there any way to find out how many user accounts were like this under my jira account

Sunandha Rajamanickam Sekar · Answer

Hi Sreeni,

Happy to see your reply and contribution to my query. Thank you!!

In my organization there are 1.8K users in jira not every accounts are related to an individual employee.

If there is a security team they use security@yy.com as one account if there is a sales team they use sales@yy.com only some specific user accounts were not associated with any individual employee.

Is there any way to query my database(postgresql) and get the user names that were not an account that is holded by any individual.

I have come up with one idea that is querying my database with 'display_name' column from the cwd_user table and storing it in a text file and comparing each output line with the dictionary words.

My mindset is "No human names will be present in dictionary" but the common words can be found in dictionary which i mentioned in my example as 'security' & 'sales' so this comparison may help me out.

But i don't have enough clarity or query knowledge to proceed this. If you have any ideas please do suggest here @Sreenivasaraju P

Sreenivasaraju P · Answer

Hi  @Sunandha Rajamanickam Sekar,

Do you mean , you want to in how many user accounts, you are part of  (like "security.xx@yy.com" ).

security.xx@yy.com is Distribution list or normal user account?