Skip to main content
September 2, 2024

Audit data for cubeview last run date

  • September 2, 2024
  • 1 reply
  • 0 views

I've been hunting around for information on the last run date for cubeviews, I may not be looking hard enough but I don't think it's stored anywhere outside of taskactivity? If this information is out there somewhere in an easier to grab format please do point me in the right direction, otherwise is my only option to query this information from the TaskActivity DB myself and hope that it hasn't been cleared in the timeframe I'm looking to query?

As a bit of background we have hundreds of cubeviews at this point and I'd like to clear up the estate. Ideally I'd be starting with data on when each cubeview was last run (possibly supplemented with how many times it has been run in the past year), followed by querying with the relevant departments whether the cubeviews are needed  based on this data. 

1 reply

September 2, 2024

I was kindly informed by Jarrod Amer that there is an openplace solution for cubeview run count and cubeview last run date/time - Run Statistics

November 12, 2024

Hi Lee,

Do you have the link for this utility? I am having issues locating this in OpenPlace.

 

November 13, 2024

Hey Nidhi,

I couldn't link from OpenPlace due to the way the navigator works but you're looking for Run Statistics as part of the Productivity category. It's available for 7.1.0 and 7.4.0 up and so this might be another reason you're not seeing it if you're searching for earlier versions?

Many thanks

Lee