I'm looking for a way to run a report that tells me which Agent Procedures are used most frequently. I'd love to be able to separate out execution of System Procedures from those executed by VSA admins... Anyone done this before or have any suggestions?
Try this query from SQL Studio. Simply modify the date range and you'll have the counts you're looking for.
select a.scriptname, left(a.description,50), count(a.agentguid)
from scriptlog a, machnametab b
where a.agentguid = b.agentguid
and a.eventTime between '2013/07/14 00:00:00' and '2013/07/14 23:59:59'
GROUP BY a.scriptName, LEFT(a.description, 50)
ORDER BY COUNT(a.agentguid) desc