Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Not a customer? Start a free trial
Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.
AppDynamics customers and established members should click the sign in button to authenticate.
kyzhou
Builder
04-28-2018
since
02-08-2018
Discussion Feed
04-17-2018
10:01 AM
No, I do not have an EUM license. I was asking for Analytics tables in general.
How should we structure a search to select from multiple tables? Do they need to share the exact same rows, or just a subset?
... View more
04-16-2018
09:35 AM
The tables I wish to select from are custom event schema created through the Analytics API.
Both synth_session_records and browser_records give the same error: Failed to receive query results [HTTP 401 Unauthorized].
I can only select results from transactions.
... View more
04-12-2018
01:34 PM
I am still told that the query is unauthorized.
Perhaps the query you have given does not work for on-premise Controllers?
I copied and pasted the query you provided and tried for the pageurl:
<domain>:8090
<domain>:8090/controller
<domain>:9080
But none return any results.
In general, what criteria do you need to satisfy to be able to select from multiple tables? For example, does synth_session_records also have matching fields for pagename and metrics.`End User Response Time (ms)`?
... View more
04-11-2018
04:22 PM
Is it possible to manually change the colors in a graph created through the custom widget builder?
I would like to change some of the bars to red to indicate that they represent errors occuring.
... View more
03-23-2018
10:14 AM
Analytics is usable for me.. queries to my custom schema work as expected.
This only occurs for the two tables involved in the query example that was provided above.
... View more
03-22-2018
10:47 AM
Hello Chitra,
Could you explain a little further on how to select from two different tables? I tried on my existing two tables a query:
SELECT nameTable.id, nameTable.names FROM dataTable WHERE nameTable.id = "1"
but was given an error: Unrecognized field [nameTable.names] not found in schema
Also, I could not query the synth_session_records, I was given a 401 unauthorized.
... View more
03-21-2018
05:25 PM
I have a table of IDs to Names:
id: name
1: user1
2: user2
3: user3
and another table of more data:
id: edu : ......
1 : bachelor : ....
2 : master : ....
3 : phd : ....
Is it possible to use AQL to join these two together so I can display the name corresponding to an id in a search?
... View more
03-14-2018
04:21 PM
Also, the documentation states that an analytics search metric will execute once per minute. Is it possible to schedule a query to run more frequently than once per minute?
... View more
03-14-2018
02:28 PM
Another question, if we update an existing schema to include more fields, what would happen to our existing data?
Would it be treated as if we had deleted the old schema and created a new one, removing all of our prior data, or would they continue to be stored?
Likewise, if we updated a schema to delete fields, what would happen to the events we already ingested?
... View more
03-13-2018
05:28 PM
Thanks, once I published some events I could see the schema showing up as an additional table. In the UI would we also be able to delete the table, or must that be done through the API as well?
... View more
Latest Activity
- Posted Re: Is it possible to join tables using AQL? on Business iQ (Analytics). 04-17-2018 10:01 AM
- Posted Re: Is it possible to join tables using AQL? on Business iQ (Analytics). 04-16-2018 09:35 AM
- Posted Re: Is it possible to join tables using AQL? on Business iQ (Analytics). 04-12-2018 01:34 PM
- Posted Is it possible to manually set colors for custom widgets? on End User Monitoring (EUM). 04-11-2018 04:22 PM
- Posted Re: Is it possible to join tables using AQL? on Business iQ (Analytics). 03-23-2018 10:14 AM
- Posted Re: Is it possible to join tables using AQL? on Business iQ (Analytics). 03-22-2018 10:47 AM
- Posted Is it possible to join tables using AQL? on Business iQ (Analytics). 03-21-2018 05:25 PM
- Posted Re: Where can I find custom event schema in the Controller UI? on Business iQ (Analytics). 03-14-2018 04:21 PM
- Posted Re: Where can I find custom event schema in the Controller UI? on Business iQ (Analytics). 03-14-2018 02:28 PM
- Posted Re: Where can I find custom event schema in the Controller UI? on Business iQ (Analytics). 03-13-2018 05:28 PM
- Posted Where can I find custom event schema in the Controller UI? on Business iQ (Analytics). 03-09-2018 01:28 PM
- Got a Kudo for Re: AppDynamics not detecting standalone windows service. 03-09-2018 02:53 AM
- Posted Re: Trouble registering .NET method as business transaction on NET (Agent, Installation). 02-27-2018 04:51 PM
- Posted Re: Trouble registering .NET method as business transaction on NET (Agent, Installation). 02-22-2018 05:11 PM
- Posted Trouble registering method as business transaction on NET (Agent, Installation). 02-22-2018 02:37 PM
- Posted Trouble registering .NET method as business transaction on NET (Agent, Installation). 02-22-2018 02:37 PM
- Posted Transactions not registering on NET (Agent, Installation). 02-13-2018 10:53 AM
- Posted Re: AppDynamics not detecting standalone windows service on NET (Agent, Installation). 02-12-2018 04:06 PM
- Posted Re: AppDynamics not detecting standalone windows service on NET (Agent, Installation). 02-09-2018 03:08 PM
- Posted Re: AppDynamics not detecting standalone windows service on NET (Agent, Installation). 02-09-2018 02:12 PM
Community Stats
| Date Registered | 02-08-2018 11:13 AM |
| Date Last Visited | 04-28-2018 11:01 AM |
| Total Messages Posted | 30 |
| Total Kudos Received | 1 |
Subscribe to our mailing list
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form
By clicking subscribe, I have read and understood the Privacy Policy and Terms of Use.