To generate report for incident created before 6 months for achieve users and active users

[phr]

Hi All,

I have a requirement to create a report on incident table where the the condition is that "incident created before six months" and "impacted user.Regions starts with EMEA". The report is returning all incidents where the impacted user is active, but I'm not able to fetch the incidents where the impacted user is an achieve user. Please Help me out with the issue. 

[PVJShareKnowled]

@phr Hello, Good day! How do you differentiate achieve users in your sys_user table. Please share details.

[AndersBGS]

Hi @phr ,

Do you have an related conditions according to users? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[ShaunaB1]

Hi,

I read your issue and I got a suggestion for this issue. To include both active and archived users in your incident report, adjust the filters. Add a condition for archived users or use an ‘OR’ clause to include them alongside active users. Look for a field indicating user status and ensure it covers both active and archived statuses.

This way, your report will show all incidents from the EMEA region created over the past six months, regardless of the user’s current status. If you’re unsure how to change these settings, refer to the reporting tool’s guide or seek help from someone experienced with it.

I hope my suggestion will be helpful for you.