Hi all, are Daily Schedule Backups stored somewhere on the ProjectWebApp database?

I'm looking to create a SSRS report that will compare a schedule with it's current backup version. The idea is to look if dates shifted.

If there is a better way to do this, please let me know. Thanks so much!

Hello,

This data is stored in the archive schema (.ver) in the ProjectWebApp database but it is not supported to query this schema (or .draft or .pub) directly with T-SQL - you will need to use the API's to get this data. See the article here: https://msdn.microsoft.com/en-us/library/office/ee767687.aspx?f=255&MSPPError=-2147217396#pj15_Architecture_DAL

The APIs are either the PSI or CSOM:

https://msdn.microsoft.com/en-us/library/office/ee767687.aspx?f=255&MSPPError=-2147217396#pj15_Architecture_PSI

PSI: https://msdn.microsoft.com/en-us/library/office/ms488627.aspx

CSOM: https://msdn.microsoft.com/en-us/library/office/jj163123.aspx

Paul