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)

Leave a Reply

Sign up for Softvative Newsletter

Get notified about new articles and deals

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter