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

[Bert Reynolds]

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]

You may not need a view.  Since a field like caller field is a reference you should be able to get to caller.created.  To do this click on the condition drop down and show related fields.

Once you do this click on the drop down again and you will see caller > user fields.  Once you click on that you will be able to see all the user fields.

[Brian Lancaster · Accepted solution]

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.

[venkat tummala]

show related fields drop down is not present ? any other way to achieve this

[venkat tummala]

show related fields drop down is not present ? any other way to achieve this