martp

Comments

  • TerryHarding That's perfect thank you. I don't know how I missed the ReportedJobs table when looking through the tables- a simple query should do the trick Heres a quick query for anyone else looking for the same solution: select * from dbo.ReportJobs where LastRun <= Convert(datetime, '2019-01-01')
  • mesverrum​ thankyou for your query it is a massive help. Any chance someone would be kind enough to point out where I change this query to only display nodes with a specific custom peoperty (e.g. System). Baiscally adding a filter so we can target certain areas of the business?