11-27-2013 01:11 AM - edited 11-27-2013 01:16 AM
Im looking to run a report to tell me which of my users has created the most guest accounts? We permission our users by AD groups for guest account creation, so some people are allowed to batch create accounts for events. Id like to see who has created the most accounts, and maybe a report on the total number of guest accounts created since we went live
I can see how to report on guest accounts created each day, but not how to report against which people are creating them and to get a running total
Is Insight the tool for this?
Any pointers would be very helpful?
11-27-2013 03:08 AM
The best I have come up with is to create an Insight Report which filters on SponsorName IS NOT NULL. (see attached image).
This will produce a list of all accounts within the defined time period.
You can then download the .csv file after the report is ran and sort the data based on SponsorName.
You need to amend the Columns section and add SponsorName for this to be visible in the results.
ACDX #98 | ACMP | ACCP
11-28-2013 10:45 PM
The format you have for the colums is correct but If you have any without a sponsor name they will not show up in your report. You can just use the following format in the 2nd tab and then add the sponsor name in the colum section.
--Give Kudos: found something helpful, important, or cool? Click Kudos Star in a post.
--Problem Solved? Click "Accepted Solution" in a post.