SharePoint: all document from all lists availabe in WebApplication

SELECT AllDocs.Leafname AS ‘FileName’,
AllDOcs.Dirname AS ‘Folder Path’,
AllLists.tp_Title AS ‘List Title’,
Webs.Title AS ‘Web Title’,
AllDocs.Size AS ‘Size’
FROM AllDocs
JOIN AllLists
ON
AllLists.tp_Id=AllDocs.ListId
JOIN Webs
ON
Webs.Id=AllLists.tp_WebId
ORDER BY AllDocs.Size
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: