I'm the primary Admin for our vaults. But others have the System Admin credentials and some users also have some admin rights. I keep a spreadsheet of users containing dates they are added - helps me with identifying those needing new user orientation, if they are leaving the company (date), email address, etc. I'm addressing the issue of who needs admin credentials and will adjust accordingly.
I want to find/create a PDM Report or SQL Query to identify new users added to the vault in the last 30 or 60 days. Would be great if the report/query could show who created the account, but I doubt that's possible. I checked the dbo.Users table in MSMS and I don't see a column for date added. Is a report or query like this possible? If so, how please?