Business iQ (Analytics)
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Is it possible to have "NOT LIKE" in ADQLs?

Hi,I understand below query is possible:SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName REGEXP "Test-job.*" But is this possible:SELECT count(*) FROM synth_sessi...

Resolved! How to get Throughput chart?

Hi, We recently switched to AppD and I am looking for a way to get a Throughput chart (hits/second) for specific Transaction records.   For example, I have a query: SELECT * FROM transactions WHERE segments.httpData.cookies.WeToken='WS757982604da45a8...

Screen Shot 2020-02-14 at 1.49.22 PM.png

Export and Import Business Journey

  I want to export the configuration and setup for a Business Journey from one controller to another. So far I have not found any methods for this neither inside AppDynamics nor in its API. Does anybody know how or do I have to recreate each journey ...

Log Analytics Timestamp

Hi All! We are using the syslog functionality of the analytics agent to collect data. The logs may be from the past so the creation timestamp is also in the past.   My problem is that AppD always considers the ingestion date as the "timestamp". We ca...

Resolved! BE (Business Event) analysis,

Hi, Suppose a company currently has a legacy logging and monitoring software that parses some BE events (in XML format),  from an application/service, and output the parsed data to a database. The "analysis" would then be done afterward by executing ...

Query to get time spend in a flow of pages

We have a shop flow consiting of a number of pages, and I need to track the sum of avg. response time for all pages in flow. E.g. the flow consists of: Page 1: avg. end use response time of 3 sec. Page 2: 4 sec. Page 3: 2 sec. So total time for flow ...

ADQL for doing UNION query

I need to compute the number of distinct users across both mobile and web application.    For web alone I get the number using this query - SELECT distinctcount(userdata.userId) FROM browser_records   And for mobile using this -  SELECT distinctcount...

Analytics Query Total Page #

Hello, I have been testing out our analytics feature and am having a problem. I’m trying to fetch a list of the top 20 EUM applications based on the total # of page requests outside of the U.S. for a duration of one year. I have figured out how to na...

Q1.png Q2.png

Resolved! Log Analytics

Hi All! I am trying to understand the log analytics features. Can I import any kind of log and do analytics on them? According to the link and picture below I can import networking (switches,routers) and VMware or even LDAP or Load balancer logs as w...

image.png

Why is the filter not being honored in ADQL?

This query should be limiting the data returned to items that have "*xpense*" in their url:   SELECT segments.httpData.url, userExperience, count(*) FROM transactions WHERE (transactionName like "*expense*" OR transactionname like "*Expense*") and us...