Query to Check Publishing Status of Projects

Project Center views have a field ‘Last published’, which shows the date when the project was last published. Occasionally there is need to check which project plan XML file is currently getting processed by View Notification Service.

Following query tells you the publishing status of project plan XML files for the day.

-- Change the date or time
Select * from msp_view_service_publish_status
Where droptime > ‘2007-02-16 00:00:01:000’
Order by Status desc, droptime desc

(Contact your DBA &/or Project Administrator to run this query)