There's nothing in the hist_capabilities tables at this point, AFAIK. I imagine it would have to do with permissions.
Some of the items in the hist area do not appear implemented (yet?), and I feel like hist_capabilities is one of them.
The column named "duration" in the historical_events table is another currently unused element that springs to mind.
Thanks for confirming that Rick. Wanted to make sure it wasn't just happening in our installation.
However, have you determined what the difference (advantage or disadvantage) would be in using the non history tables to try to get that information (that is, seeing what workbooks are published with what roles/permissions)? Specifically, from what I've observed by using:
And is that even possible with those tables?
these non-hist tables that you refer to can be tapped into, however they will only have a current view snapshot.
As The specified item was not found. says, it's easy enough to get current permissions. See my Permissions workbook or one of the other good permissions workbooks out there.
Auditing permissions changes, however, is not currently possible as far as I know, outside of log parsing (which isn't straightforward). I'd love to permission change auditing in a future release.
So, let's create a feature request: Ability to audit permission changes
Thanks for the replies all. I have looked at your Permissions workbook Rick; it is helpful. I didn't think we could really view permissions history at this point, just wanted to confirm that I wasn't missing anything.