Query to Check Publishing Status of Projects

Share on facebook
Share on twitter
Share on linkedin

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

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter

Get notified about new articles

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest