How can I view all incidents logged by users within two weeks of the user creation date?

Bert Reynolds · ‎01-29-2019

I'm going to preface this by saying i'm a complete novice with ServiceNow, so apologies in advance.

I'm interested in creating a report that shows me all tickets logged by users within two weeks of their creation/import date.

From what I've read, I think I need to user database views to combine two tables (incidents and users) but I'm quite lost with it.

Am I heading in the right direction here?

Brian Lancaster · ‎01-30-2019

Something like this should work for your conditions. I would also suggest grouping by user. The first created is the incident created and at the end of each line is the user created date.

View solution in original post

Brian Lancaster · ‎06-18-2021

If show related fields is not there do you see some like caller -> related caller fields?

Bert Reynolds · ‎01-30-2019

Cannot thank you enough Brian! Amazing! Worked a treat 🙂