Ever wondered which of your Classic Dashboards are actually being used? Who visited the page? How many times?
These are the questions this script aims to answer. I wrote this because we have an internal audit process where we evaluate the use of dashboards. Anything that doesn't get used yearly we look at reworking/updating/removing. This used to involve reaching out to customers individually to ask them if they still used certain dashboards... well now that we're storing the output of this script daily in an auxiliary database on our SW SQL server, we'll know for sure if Classic views are being used.
This script assumes that you're using domain accounts, and not local Orion accounts, but could be tweaked to work with those as well. For my environment, we only use those for scheduled reports and a few other actions, so I excluded them for this script.
In order to get things working, you will have to update line 18 (SolarWinds credential/authentication) and line 32. This is where you define what your domain usernames look like using regex, so the log parser knows what a valid username is.
Sample output:
Today was a holiday and I got a bit carried away looking at all the dashboards to validate the output so they all pretty much show my username, but you can see that the UniqueUserVisits column does have more censored names than my own. Also, the first and second entries were looked at by two different accounts of mine for testing purposes.