?
Solved

Create\Update timestamps on SharePoint 2010 user profile  Database

Posted on 2013-06-17
1
Medium Priority
?
678 Views
Last Modified: 2014-02-01
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
Comment
Question by:larchevv
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 1500 total points
ID: 39451167
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question