Agent Summary By Data Collector Type

[JGAbernethy]

Does anyone know if it is possible to generate this page as a report and if so how?

The page I am referring to is this:
settings > global settings > agent configuration > show all agent status > click on the particular agent > then click on "show agent summary"

[payners]

Try this out:


select

agentmoduleconfigurationproducthostname as 'Master Server',
case
when agentmoduleeventeventnumber='1' then 'Job'
when agentmoduleeventeventnumber='3' then 'Policy'
when agentmoduleeventeventnumber='7' then 'Tape Drive usage'
when agentmoduleeventeventnumber='8' then 'Media'
when agentmoduleeventeventnumber='13' then 'Image'
end as 'Event',
MAX(agentmoduleeventlasttime) as 'Last Event Success Time'

from

agentmoduleevent,
agentmodule,
agentproduct,
agentmoduleconfiguration

where

agentmoduleid=agentmoduleconfigurationagentmoduleid and
agentmoduleconfigurationid=agentmoduleeventagentmoduleconfigurationid and
agentmoduleid=agentproductagentmoduleid and
(agentmoduleeventeventnumber='1' or
agentmoduleeventeventnumber='3' or
agentmoduleeventeventnumber='7' or
agentmoduleeventeventnumber='8' or
agentmoduleeventeventnumber='13')


group by

agentmoduleconfigurationproducthostname,
agentmoduleeventeventnumber

order by

agentmoduleconfigurationproducthostname

[JGAbernethy]

thanks! that 's a good start and I can probably work with it eventually. I think what I'm looking for is something more like the "Agent summary by data type" display except broken out by data collector (if that makes sense).