Kaseya Community

Most Frequently Executed Agent Procedures

This question is answered

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?

Verified Answer
  • Try this query from SQL Studio.  Simply modify the date range and you'll have the counts you're looking for.

    USE ksubscribers

    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

All Replies
  • Try this query from SQL Studio.  Simply modify the date range and you'll have the counts you're looking for.

    USE ksubscribers

    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