Anybody knows which is the name of the SharePoint table where the full URL of a web application is stored? for example
"http://myserver:9090" Is in Config DB or inside the content DB.
This is the Join community webpart
When you click on this button you become active member of the community. You can write in the newsfeed, make posts in the discussion lists etc. The problem is that I have a customized Webpart that must show all the communities where the user joined (inside Lists/Members/MembersAllItems.aspx) in a fast way.
If I fetch each web application, then all sites, and then check permissions for the current user, the process to get all the communities for this user would be extremely slow because we could have more than 500 communities. For that reason I was trying to create a Stored Procedure in a external DataBase to get the Titles and URL of the community.
This query works
SELECT distinct Webs.Title, Webs.SiteId, Webs.FullURL FROM AllUserData AS UserData LEFT OUTER LOOP JOIN AllUserData AS t2 ON (UserData.[int1]=t2.[tp_ID]) AND (UserData.[tp_RowOrdinal] = 0) AND (t2.[tp_RowOrdinal] = 0) AND ( (t2.tp_Level = 1) ) AND (t2.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (t2.[tp_CalculatedVersion] = 0 ) AND (t2.[tp_DeleteTransactionId] = 0x ) AND (UserData.[tp_IsCurrentVersion] = CONVERT(bit,1) ) AND (UserData.[tp_CalculatedVersion] = 0 ) AND (UserData.[tp_DeleteTransactionId] = 0x ) inner join Docs on UserData.tp_SiteId = Docs.siteId CROSS APPLY (SELECT TOP 1 deleted, Id FROM AllSites WHERE UserData.tp_SiteId = AllSites.Id) Sites CROSS APPLY (SELECT TOP 1 Title, SiteId, FullURL FROM AllWebs WHERE Sites.Id = AllWebs.SiteId) Webs WHERE (UserData.tp_Level = 1) AND (UserData.tp_RowOrdinal=0) AND ((UserData.[int2] = 1)) and t2.[nvarchar4] = 'firstname.lastname@example.org' and Docs.LeafName = 'MembersAllItems.aspx' and Sites.deleted = 0
But here the problem is what you say. That is not supported by Microsoft to query directly the SharePoint databases. I am desperated!!
Thank you anyway