SharePoint 2010/2013 Powershell: Get SP User Properties of all the Site User or a Using Loginname

Here is how you fetch  user properties/info using powershell. Normally to do that we use the following Powershell command but this required a SPUserPipeBind user identity which looks like this i:0#.w|domain\username

Get-SPUser [[-Identity] ] -Web  [-AssignmentCollection ] [-Group ] [-Limit ]

But incase you dont have SPUserPipeBind you can use the following script.

Now here comes the compelete script which took me couple of hours to build. For instance you are required to fetch all the users of the site along with their managers, following script is going to do the magic for you. What it does is to
  • Fetch all the User of a specific site collection.  
  • Loop through all the user and fetch each user's Manager 
  • Using $web.EnsureUser fetches Manager's Display name since Login Name is not that user friendly. 
  • At the end it takes all the users along with their respective Managers and sends them to a text file.
  • Since the user names were in german in my case so the text file was encoded to  [System.Text.Encoding]::Unicode. You can leave out the third argument while outputting things to text file if you don't need that. 


Disclaimer: I don't completely own this script and the bad new is that I could not keep track of all the sources I followed. Still following are few of them:

http://stackoverflow.com/questions/3896258/how-to-output-text-without-newline-in-powershell
http://blog.incworx.com/blog/sharepoint-administrators-blog/get-a-users-id-using-powershell
http://sharepoint.stackexchange.com/questions/92017/get-user-by-loginname-using-powershell



Vaqar Hyder
E: vaqar.hyder3567@gmail.com
A:
Siebenbürgen Straße 2/1, Korntal-Münchingen, 70825, PK
Hire me on Freelancer.com

Comments

Post a Comment

Popular posts from this blog

SharePoint 2010 Migration Woes: Importing and exporting lists template between different SP2010 Servers

Image
Migrations of SharePoint contents from one server to another can be a big PITA. Once I came across a  scenario  where I had to export a couple of lists from SharePoint online i.e. Office 365 to the SharePoint 2010 on my local server.  What I did is to copy the required lists along with content by creating a list template i.e. via .stp file. Then I upload it to my local SharePoint 2010 server's list template gallery. Later I  successfully  created a new list with the uploaded template. For that I took the following steps: Open your SharePoint site in the SharePoint designer 2010. Select Lists and libraries. Select you desire list and the click on the "Save as Template" from the ribbon. You'll be redirected to the SharePoint site and there after filling in the required fields and pressing OK , .stp will be created. This template can be viewed in Site Action -> Site Setting -> Galleries ->List Template. Select the list template and then from the ribbon&
Read more

How to Stop People From Reading Your Mind and Judging You

Image
Wow look what I've found today. That's absolutely fascinating. Well let me clear what was I up to and what I bumped into ;). I know a person who is freaking awesome in getting into you bloody head and read your bleeding mind. May be he wasn't that good but he knew me so well that he could actually tell what I was thinking and honestly, I was slightly pissed of sometimes. So I started googling about how to stop people from reading your mind.  The first thing I deduced is to get familiar with your emotions and totally be in control of your thoughts. Always make your words match your perception  This will result in a mark clarity in your communication.  As I said get familiar with your emotions, we know that there can be zillions of different ways you can feel, specially  when it comes to the curious cases of poor women. But psychologists have made life easier for us by categorizing the complicated plethora of emotions into tiny fractals such as:  As mentioned
Read more

Powershell: Filling up an Existing Excel Sheet with data from SQL Server

Situation: The client required to have data from their SQL Server 2012 Database filled in to an existing Excel Sheet. This sheet had a table with around 40 columns of which 12 where to be filled by us and rest from different departments. I tried different solution for that since the requirements were not initially clear. Forexample OPENROWSET was tried. In this regards this link really helpful. Although this requires few configuration to be made on the server or to install e.g. ACE.OLEDB driver on server which was not possible in our case. So we decided to write a Powershell script and access SQL Now about the script: Take the file TestExcel.xlsx from C:\Temp folder Create its copy with the current date appended to its name.  Start reading the Excel file from Sheet "Specified Sheet Name" From Columns 1, it will take the name of the system.  Based on the name fill the excel sheet by executing the queries, here are the columns that are going to be filled:  #   
Read more