Power Shell Script to find and delete orphaned users from site

Power Shell  Script to get orphaned users from SharePoint Site.

Who are orphaned users?
Orphaned users are those who are disabled/removed from Active directory.

 avoid user to still exist in the SharePoint People picker.

If we want delete few users only then browse to following url of your site delete user from there.

http://<SharePoint Server Name>:<Port No>/_layouts/people.aspx?MembershipGroupId=0 
   
using above URL We get all the list of users who exist in Site Collection. We can even delete any user from this URL, but it will remove from the complete Site Collection 

We can also query the users alternatively from SQL server

 1 : Open SQL Server Management Studio

SELECT * FROM [Sharepoint_Content _DB].[dbo].[Detailed User information] WHERE tp_Login='DOMAIN\UserID'        


2: record the tp_Id value, based on this  we can get user reference.

3: Go to http://<Site_Collection_Address>_layouts/userdisp.aspx?ID=tp_ID,


Comments

Post a Comment

Popular posts from this blog

[Solved ] ...The product key entered does not match any of the Windows images available for installation. Enter a different product key

Step by step process to Make Pen drive as Bootable.    Enter into CMD Prompt.    Type - DISKPART.    Type - List DISK. Once we enter here it will list USB Disk Number. If your USB Disk Number is 1. Then Execute following Commands.    Select DISK 1    C lean    Create Partition Primary    Select Partition 1    Active    Format FS=NTFS Quick    Assign     Exit. Now insert DVD into DVD-Rom and Copy complete content of DVD into Removable Drive (Pen drive). Common Error for Windows 8 Based Computers. The product key entered does not match any of the Windows images available for installation. Enter a different product key. Please follow these steps to solve this error. Step -1 Create a file PID.TXT with following structure. Step -2 [PID] Value=XXXXX-XXXXX-XXXXX-XXXXX-XXXXX Step – 3 Place your windows 8/2012 Pro key in where the X's are and save the file to the /sources directory in the Bootable USB Drive .
Read more

SharePoint Search Service application content sources showing Paused

There may be many reasons for content sources to get into Paused  Below PowerShell script will help you c hecks status of Search Service application whether its running or Paused. If paused then returns the detailed information why its paused and asks input from user to resume  asnp "*sharepoint*" $searchserviceapps = Get-SPEnterpriseSearchServiceApplication foreach ($ssa in $searchserviceapps) {  Write-Host $ssa  -ForegroundColor Magenta $band = "0x" $band0 = "0x0" Function Details()     { $Detail = Read-Host "Do you want to see detailed reasons (Y/N) " If($Detail -eq "y")         { Write-Host " (band 0x01)          A change in the number of crawl components or crawl databases is in progress. (band 0x02)          A backup or restore procedure is in progress. (band 0x04)          A backup of the Volume Shadow Copy Service (VSS) is in progress. (band 0x08)          
Read more

User Profile Synchronization Service Struck on "Starting" - Fixed

Image
User profile Service Synchronization  service Struck on “ starting ” . In SharePoint 2010 it is very common problem that whenever user profile synchronization is started. It gets struck on “starting”. There were many cases where user profile synchronization struck on starting  from my experience I will list some cases. First stop user profile synchronization service by using SharePoint Management Shell. ·          Get-SpServiceInstance ·          It will list all services currently running on SharePoint Farm.           ·          Select Id of User profile service synchronization, you can select Id by Right click on command prompt now Mark ID of User profile service synchronization and Hit Enter , Now Id will be automatically copied. ·          Now, stop user profile synchronization service . ·          Stop-SpServiceInstance –ID  <User profile synchronization service -ID > ·          You will be prompted with yes or no. Enter “ Y” to confirm your
Read more