How to filter for lists of Recently Created Users.

1) Login to quixotic

2) Search for AD Reports-recently created users in the page using CTRL + F

3) of Download the CSV and filte for AD Reports-recently created users in Excel see below:

 

AD Reports-recently created users

 

 

Then copy the list of ticket numbers

 

Copy filterd list of tickets to a new worksheet

Concatenate URL =CONCATENATE("https://quixotic.androgogic.com.au/tickets/view/",A1)

https://quixotic.androgogic.com.au/tickets/view/231054

236177 https://quixotic.androgogic.com.au/tickets/view/236177
236112 https://quixotic.androgogic.com.au/tickets/view/236112
236070 https://quixotic.androgogic.com.au/tickets/view/236070
236035 https://quixotic.androgogic.com.au/tickets/view/236035
235977 https://quixotic.androgogic.com.au/tickets/view/235977
235814 https://quixotic.androgogic.com.au/tickets/view/235814
235774 https://quixotic.androgogic.com.au/tickets/view/235774
235684 https://quixotic.androgogic.com.au/tickets/view/235684
235641 https://quixotic.androgogic.com.au/tickets/view/235641
235283 https://quixotic.androgogic.com.au/tickets/view/235283
233405 https://quixotic.androgogic.com.au/tickets/view/233405
231054 https://quixotic.androgogic.com.au/tickets/view/231054

 

 

 

236177 https://quixotic.androgogic.com.au/tickets/view/236177
236112 https://quixotic.androgogic.com.au/tickets/view/236112
236070 https://quixotic.androgogic.com.au/tickets/view/236070
236035 https://quixotic.androgogic.com.au/tickets/view/236035
235977 https://quixotic.androgogic.com.au/tickets/view/235977
235814 https://quixotic.androgogic.com.au/tickets/view/235814
235774 https://quixotic.androgogic.com.au/tickets/view/235774
235684 https://quixotic.androgogic.com.au/tickets/view/235684
235641 https://quixotic.androgogic.com.au/tickets/view/235641
235283 https://quixotic.androgogic.com.au/tickets/view/235283
233405 https://quixotic.androgogic.com.au/tickets/view/233405
231054 https://quixotic.androgogic.com.au/tickets/view/231054

 

 

236177 https://quixotic.androgogic.com.au/tickets/view/236177
236112 https://quixotic.androgogic.com.au/tickets/view/236112
236070 https://quixotic.androgogic.com.au/tickets/view/236070
236035 https://quixotic.androgogic.com.au/tickets/view/236035
235977 https://quixotic.androgogic.com.au/tickets/view/235977
235814 https://quixotic.androgogic.com.au/tickets/view/235814
235774 https://quixotic.androgogic.com.au/tickets/view/235774
235684 https://quixotic.androgogic.com.au/tickets/view/235684
235641 https://quixotic.androgogic.com.au/tickets/view/235641
235283 https://quixotic.androgogic.com.au/tickets/view/235283
233405 https://quixotic.androgogic.com.au/tickets/view/233405
231054 https://quixotic.androgogic.com.au/tickets/view/231054