|
|
| |
|
Projects with no WSS Sites
The following query displays list of the projects which are not associated with SharePoint sites.
Note:The projects which are associated with SharePoint site will have WPROJ_ID value on WPROJ_DEFAULT_WPROJ_ID Column.
How to Run: Run the following query on SQL Query Analyzer, by selecting Project Server database.
SELECT WPROJ_ID, PROJ_NAME, WPROJ_DEFAULT_WPROJ_ID,
WPROJ_STS_SUBWEB_NAME
FROM MSP_WEB_PROJECTS
WHERE (WPROJ_STS_SUBWEB_NAME='NONE' OR WSTS_SERVER_ID=0 )
AND WPROJ_DEFAULT_WPROJ_ID=WPROJ_ID
ORDER BY PROJ_NAME
|
| |
|
