|
|
| |
|
SharePoint site items
The following query displays all the WSS site names and associated items (Shared Documents, Document Library names. Contacts, custom created list names etc.) and date created.
How to Run: Run the following query on SQL Query Analyzer, by selecting SharePoint database.
SELECT DISTINCT Webs.Title AS WSSName, Lists.tp_Title AS ItemName,
Webs.TimeCreated AS DtCreated
FROM Webs INNER JOIN
Sites ON Webs.SiteId = Sites.Id INNER JOIN
UserData ON Sites.Id = UserData.tp_SiteId INNER JOIN
Lists ON UserData.tp_ListId = Lists.tp_ID
Sample Output:
|
| |
|
