Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
05-17-2022 08:10 AM
05-17-2022 09:13 AM
Hi @Juraj.Papic,
Please let me know if this documentation helps you out: https://docs.appdynamics.com/22.5/en/appdynamics-essentials/dashboards-and-reports/reports
Thanks,
Ryan, Cisco AppDynamics Community Manager
Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
07-28-2022 07:59 AM
Hi, you can use :
select id as node_id, name as node_name, last_known_tier_app_config as app_and_tier from application_component_node where id in (select distinct(node_id) from metricdata_hour where ts_min > ((select max(ts_min) from metricdata_hour)) - 60*2);
SELECT a.name AccountName, agj.type AgentType,agj.agent_version AgentVersion, agj.app_and_tier ApplicationAndTier,agj.node_name NodeName FROM (SELECT DISTINCT(node_id) AS node_id FROM metricdata_min WHERE ts_min > ((SELECT max(ts_min) FROM metricdata_min) - 10) ) mdm, (SELECT ag.type type, ag.agent_version agent_version, acn.name node_name,acn.last_known_tier_app_config AS app_and_tier, acnam.application_component_node_id node_id, ag.account_id account_id FROM agent ag, application_component_node_agent_mapping acnam,application_component_node acn WHERE acnam.agent_id = ag.id AND acn.id=acnam.application_component_node_id UNION DISTINCT SELECT ag.type type, ag.agent_version agent_version,acn.name node_name,acn.last_known_tier_app_config AS app_and_tier, acn.id, ag.account_id FROM agent ag, application_component_node acn, machine_instance_agent_mapping miam, machine_instance mi WHERE miam.machine_instance_id = mi.id AND miam.agent_id = ag.id AND acn.machine_instance_id = mi.id) agj, account a WHERE mdm.node_id = agj.node_id AND a.id = agj.account_id ORDER BY AccountName,AgentType,ApplicationAndTier,NodeName INTO OUTFILE 'PATH TO YOUR FILE.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
User | Count |
---|---|
4 | |
3 | |
3 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form