Click here to Skip to main content
15,867,885 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello,
I have a cite collection (in sharepoint 2003)with many sites and subsites.
I have to extract in sql a list of all the users for every site.
Could you help me or tell me which tables and colums I have to use to build the query?
Thank you very much in advance,
Alex
Posted
Comments
Maciej Los 27-Nov-14 17:51pm    
Sorry, who's the owner of sql database?
We can not see your mind and we can not read direct from your screen.
Please, improve your question and add more details.

First, I assume you are talking about SharePoint 2013 and not 2003.

Second, don't try to poke into SharePoint databases via SQL queries. The database structure is internal to SharePoint and is not documented for a reason.

You should be using the APIs available in SharePoint (CSOM, JSOM or even PowerShell).

Look at the links below to get started:

http://stackoverflow.com/questions/1205050/how-to-retrieve-the-list-of-sharepoint-sites-user-has-access-to-from-a-window[^]

http://sharepoint.stackexchange.com/questions/84168/sharepoint-2013-using-jsom-get-a-list-of-all-sites-user-has-access-too[^]

http://blogs.technet.com/b/lystavlen/archive/2012/04/23/my-company-portal-in-sharepoint-online-in-office-365.aspx[^]
 
Share this answer
 
find code by myself...............................................
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900