Query to get Lock Site Collection in SHarepoint 2007.

Query to get Lock Site Collection in SHarepoint 2007.

BitFlags-131072 For Read Only Site COllection
BitFlags-1 Adding Content Prevented
BitFlags-0 for None
BitFlags-3 for No Access





SELECT dbo.Webs.SiteID as SiteID,dbo.Webs.Id AS WebGuid,


dbo.Webs.Title AS WebTitle,

dbo.Webs.FullUrl AS WebUrl

FROM dbo.Webs INNER JOIN

dbo.Sites ON dbo.Webs.SiteId = dbo.Sites.Id AND dbo.Sites.BitFlags = 131072

AND dbo.Webs.ParentWebId is null