Forum Discussion

LeeMcCarthy's avatar
LeeMcCarthy
New Contributor II
4 months ago

Audit data for cubeview last run date

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. 

Cube View
  • LeeMcCarthy's avatar
    LeeMcCarthy
    New Contributor II
    4 months ago

    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

    • NidhiMangtani's avatar
      NidhiMangtani
      Contributor III
      2 months ago

      Hi Lee,

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

       

      • LeeMcCarthy's avatar
        LeeMcCarthy
        New Contributor II
        2 months ago

        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