It was suggested I check out IT Analytics, so I was following this to try to get started
https://www-secure.symantec.com/connect/articles/installing-and-configuring-it-analytics-71-client-server-management-pack
I didn't get very far, though, because I couldn't get the analysis server to verify its connection. I have a main CMS server and a separate SQL server, tried both, no dice.
I put a ticket in with Symantec, and they said it's because I didn't set up analysis and reporting services on the SQL server, and I should do that.
Is this part of the Symantec documentation somewhere on exactly what I should be doing? Symantec said I should work with our DB admin, we are a school district and there's no expert here I can go to for that. I'm googling around but don't want to do the wrong thing and risk anything with the SQL server.
I'm running CMS 7.1 SP2 and MS SQL server 2008 r2 64 bit.
Thanks for any advice.