Thursday 10 April 2014

Find User Information In SharePoint Content Data Base using SQL SERVER

****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [tp_SiteID]
      ,[tp_ID]
      ,[tp_DomainGroup]
      ,[tp_SystemID]
      ,[tp_Deleted]
      ,[tp_SiteAdmin]
      ,[tp_IsActive]
      ,[tp_Login]
      ,[tp_Title]
      ,[tp_Email]
      ,[tp_Notes]
      ,[tp_Token]
      ,[tp_ExternalToken]
      ,[tp_ExternalTokenLastUpdated]
      ,[tp_Locale]
      ,[tp_CalendarType]
      ,[tp_AdjustHijriDays]
      ,[tp_TimeZone]
      ,[tp_Time24]
      ,[tp_AltCalendarType]
      ,[tp_CalendarViewOptions]
      ,[tp_WorkDays]
      ,[tp_WorkDayStartHour]
      ,[tp_WorkDayEndHour]
      ,[tp_Mobile]
      ,[tp_Flags]
  FROM [WSS_Content_2010_Solar_Test_181213].[dbo].[UserInfo]

No comments:

Post a Comment