Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 737
  • Last Modified:

Create\Update timestamps on SharePoint 2010 user profile Database

This might be a simple question but I am hoping to save time here. I want to build a report to show User Profile creation by month. Using SSRS and SQL.

I assumed that SharePoint would have all the create\update timestamps that I would need but it is not the case.

I looked at a few Log tables but I can't find for sure the right place to know when a user profile got created.

Does anyone know the actually place in the DB where the create date might be? if it is in a log table, please comment on the data retention of that table.

Thanks!

Vincent
0
larchevv
Asked:
larchevv
1 Solution
 
sharepointguru14Commented:
I'm not in a position to check myself right now, but I believe you can find a created date in the ProfileDB and the UserProfile_Full table.

I can check later if you need help confirming
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now