Dan's BI Braindump

Just another WordPress.com site

  • Home
  • About
Posts Comments
  • Work
  • Uncategorized
  • SQL Server BI
  • SharePoint
  • Mobile Technology

Extracting list of users from SharePoint 2010

July 4, 2014 Leave a comment

There are loads of ways you can do this with web services etc… but I have found the easiest way is to query the backend database.

Find you database for the user profiles (might be called something like ‘ProfileDB’), and in there you will find a table called UserProfile_Full.

In my case today I needed to obtain a list of all staff and their managers, so I ran the following query to get this…

SELECT a.PreferredName,

a.Email,

b.PreferredName as Manager

FROM dbo.UserProfile_Full a

left join dbo.UserProfile_Full b

ON a.Manager = b.NTName

Filed under SharePoint, Work Tagged with export, List, SharePoint 2010, User profile

Bulk uploading user profile pictures to SharePoint 2010

September 13, 2012 Leave a comment

So here’s the problem – I’ve got 330 user profiles which need pictures adding, I’ve got a folder full of pictures and if I were to add each one manually it would take me about 7 years (slight exaggeration!)

After a bit of googling I came across a great little tool created by djeeg on codeplex (http://spc3.codeplex.com/wikipage?title=ProfileImageUpload&referringTitle=Home)

The main thing here is to make sure you get the filenames of the photos correct so that the tool can match them with a user profile account.

In my case the usernames looked like domain\firstname.lastname – There is a section in the tool that asks for a regex filename format (the default is (\w+)_(\w+) ) – I changed this to (\w+) (\w+.\w+) and named my photos as follows: domain firstname.lastname.jpg

It worked like a charm and saved me 7 years of manual effort (ok probably a couple of days during which time I would have stabbed myself in the eye with my pencil out of sheer boredom)

Thanks djeeg!

http://stackoverflow.com/questions/4747110/desktop-bulk-upload-sharepoint-profile-images

Filed under SharePoint Tagged with photo, regex, sharepoint, User profile

December 2025
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Oct    

android BATCH BI BIDS Business Intelligence continuous integration database data warehouse institute delimited documentation edit excel export group by Kimball List MDX Multi Value NETBIOS Object ID Parameters Pause PDF photo prompt regex Reporting Services Resume Run Shared Schedules sharepoint SharePoint 2010 solution source control Split sql SQL Server SSAS SSRS string strings tfs UPDATE UPS User profile users varchar visual studio where Work xml
Follow Dan's BI Braindump on WordPress.com

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Dan's BI Braindump
    • Already have a WordPress.com account? Log in now.
    • Dan's BI Braindump
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar