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.
Thank you
EDIT
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] = '[email protected]'
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