Jira Data Manager - Cleansing People Data

[alan_macdonald]

Hello Folks, 

We are exploring Jira Assets and Data Manager, both of which I am new to as of the last 24 hours so apologies if im asking something obvious. 

I have set up a number of the Adapters in Data Manager (Intune, Jamf, Entra - Users) which I am then cleansing and using for Jira Assets. 

The main one I am struggling with is Entra. Ive pulled in the data (some 5000 records) however I only want our actual users which should be less than 2k. The rest is things like shared mailboxes or guest accounts. 

The problem im facing is being able to cleanse it down to the right level. Ive managed to get rid of guest accounts by excluding anything that doesnt have our domain in the email. Im struggling now to get rid of shared mailboxes as these contain our domain in the email. 

I see there is an option to exclude any PK values that are null. I am surprised there isnt an option to do that for any column, seems I can only do it for the PK? Our Shared mailboxes dont have a given name so I was able to get close to setting given name to the PK. But then that doesnt work because a PK cant have duplicates. 

I see options for filtering out but im not sure how that works. If I do filter out anything with a given name column null it doesnt seem to affect my numbers. 

What am I doing wrong? Appreciate any advice. 

[Jehan Bhathena]

Hi @alan_macdonald ,

Usually Shared Mailboxes have a few entity properties empty, you can use AQL to search for all the Objects with the Empty values and bulk delete those:

Reference:

• https://support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/
• https://support.atlassian.com/jira-service-management-cloud/docs/delete-multiple-objects/