Get All Draft Projects Saved in Project Server DB but not published

Often we need to know the projects which has been saved by PM’s but hasn’t been published, in order to check with PM’s if they forgot   to publish or intentionally they have saved the changes, all this is to make sure the correct data is reflected  🙂 , Make sure to run this against draft DB

Note: querying draft DB directly is not supported by MS, hence perform this at your own risk

So here is the query by which you can find out

select p.WPROJ_LAST_PUB, p.PROJ_LAST_SAVED, p.PROJ_NAME, p.Proj_UID from MSP_PROJECTS p where p.WPROJ_LAST_PUB < p.PROJ_LAST_SAVED