This is not a perfect approach but I have come up with a way to track usage of our dashboards. More specifically, which users are logging in. Rather than getting this information from SiSense, I went through IIS. This approach will only work if you are hosting the dashboards through IIS.
A) Follow this link (http://www.microsoft.com/en-us/download/details.aspx?id=7211), download and install the Advanced Logging add-on to the server hosting your Prism Web site
B) Once installed, open IIS and click on your server name then double click on Advanced Logging. See attached screen1
C) Click on Add Log Definition. See attached screen2
D) From here you setup the log however you'd like. See attached screen3
- Enter the name you want for the log. Mine is Prism_Web
- Check Publish real-time events so you can get updates as people interact with your dashboards
- Schedule is for how often you'd like a new log file to be created. Daily would be a good choice if you have a large user environment, Weekly or Monthly if you only have a few users. You can select never if you'd like to convert it to a CSV and create a dashboard from the information (could link it with Google Analytics data).
- Click on 'Select Fields' to pick fields that show up in the log. The three most important for user tracking are 'Date-Local', 'Time-Local', and 'Username'. You can select any of the others if you'd like but these are the most important
E) Click apply in the top right corner under Actions and you are set. Click on 'View Log Files' to open the folder containing the logs.
I had an issue where the UserName field wasn't populating. Follow the steps below to resolve this quickly.
A) Copy and Paste this link into Windows Explorer - C:\Windows\System32\inetsrv\config\applicationHost.config
B) Find this line of code:
<field id="UserName" sourceName="UserName" sourceType="RequestHeader" logHeaderName="cs-username" category="Default" loggingDataType="TypeLPCSTR" />
C) Change sourceType="RequestHeader" to sourceType="BuiltIn"
D) Save the file
Hope this helps everyone out. I implemented this a few weeks ago and I can already tell which departments are using my dashboards and which aren't. Good luck!
Please sign in to leave a comment.