tag:blogger.com,1999:blog-8991341388910781934.post3203770308032926005..comments2023-10-04T15:30:16.217+05:30Comments on Neal Mukundan: SharePoint 2010 - The content databases, tables and SQL queriesNeal Mukundanhttp://www.blogger.com/profile/06408084860378391975noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-8991341388910781934.post-33712004814293697932014-11-06T01:52:49.929+05:302014-11-06T01:52:49.929+05:30Great, Thanks!Great, Thanks!Karthikeyanhttps://www.blogger.com/profile/00051859907169930220noreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-71779796401876647832014-09-16T03:36:58.318+05:302014-09-16T03:36:58.318+05:30Hi Kim, looking for the same query, did you manage...Hi Kim, looking for the same query, did you manage to get it eventually?Anonymoushttps://www.blogger.com/profile/17775078973052763355noreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-39154532308927805412014-05-31T00:31:57.433+05:302014-05-31T00:31:57.433+05:30Does anyone have a script(s) that gets all users a...Does anyone have a script(s) that gets all users at a site level and what they have access to?Anonymoushttps://www.blogger.com/profile/10608389480782059960noreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-22727877892985712732014-05-13T17:27:59.272+05:302014-05-13T17:27:59.272+05:30unable to see the imagesunable to see the imagesthahahttps://www.blogger.com/profile/01467313736687222123noreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-23890180113152696392014-05-05T21:59:09.618+05:302014-05-05T21:59:09.618+05:30It's good to know the important tables and the...It's good to know the important tables and their queries for Sharepoint content databaseAnonymoushttps://www.blogger.com/profile/09038344499457735878noreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-82910220073317089602014-03-13T15:28:19.159+05:302014-03-13T15:28:19.159+05:30Hi Neal,
How to fetch all the documents from dbo....Hi Neal, <br />How to fetch all the documents from dbo.AllDocs based on Content Type Name. I have tried the below steps which wasn't worked out.<br />1. Get the ContentTypeId from dbo.ContenTypes Where Name is "MyContentTypeName"<br />2. From the Step 1 results, Tried to get the Document from AllDocsAnonymoushttps://www.blogger.com/profile/09146900581514925706noreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-50919995142543819382013-07-30T18:56:58.513+05:302013-07-30T18:56:58.513+05:30hi, you have a query that returns the values of a ...hi, you have a query that returns the values of a list and in that list a column have multiple values?<br /><br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-60020951455429710772013-07-11T13:55:12.480+05:302013-07-11T13:55:12.480+05:30I verified the query and indeed it works fine. I s...I verified the query and indeed it works fine. I shall make the necessary changes in the blog. Thank you very much! Appreciate your contribution!Neal Mukundanhttps://www.blogger.com/profile/06408084860378391975noreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-60300833912101703462013-07-09T03:13:40.284+05:302013-07-09T03:13:40.284+05:30Query 5 is not accurate if you will be looking for...Query 5 is not accurate if you will be looking for members of specific sharepoint group within that content db should be:<br />GroupMembership with (nolock) inner join Groups with (nolock) ON GroupMembership.GroupId = Groups.IDAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8991341388910781934.post-56659083387762776282013-05-08T18:44:47.375+05:302013-05-08T18:44:47.375+05:30great, thanks!great, thanks!Anonymousnoreply@blogger.com