Friday, July 22, 2011

How find info regarding MOSS 2007 metadata


Sharepoint_config database stores metadata information related to sharepoint websites and content.  While I did my own digging through the tables i found the below SQL statement from Bert Van Landeghem's blog:
SELECT [Id]
,[ClassId]
,[ParentId]
,[Name]
,[Status]
,[Version]
,[Properties]
FROM [Sharepoint_Config].[dbo].[Objects]
WHERE properties LIKE '
ORDER BY [Name]
/*
WHERE properties LIKE '
WHERE properties LIKE '
WHERE properties LIKE '
WHERE properties LIKE '
WHERE properties LIKE '
WHERE properties LIKE '
*/

No comments: