Solved

Create\Update timestamps on SharePoint 2010 user profile  Database

Posted on 2013-06-17
1
648 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 500 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying 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…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

622 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