EPM Central Project Server Tutorials
Home Deployment    MS Project PWA SharePoint Articles Administrators FAQs Consulting Search Site Map
  Error Messages

Project Server 2003

PWA Login DropDown

Inactive vs. Delete

Actual Work Protected

  2003 SQL Queries

  Enterprise Fields
    Project Fields
    Resource Fields
    Sample Queries

Admin Tools

Re-associate Site

Project Archival


Administration -> MS Project Server 2003 -> SQL Queries
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
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:

Copyright 2013. EPM Central. All rights reserved.