In LF 10.x I used to be able to access the Audit Trail data via PowerBI and made some very beneficial reports that showed access counts on a monthly basis, document view counts on a monthly basis and also the location of the Top 20 accessed files....
The rub is that I also had this for all time, since I could pull it through the db directly.
So.....anyone have an idea of how I can manage this now? I need a good solid overview in a BI tool!
If I can identify the cycle of data actually being stored in the AudtTrail tables I can easily set up SQL server jobs to copy out what I need on a daily/weekly/monthly cycle for my use, but I need to identify if that actually works.