Discussion Feed

Stefan.Hermanek · ‎12-19-2018

Hello Brian, Thanks for reaching out on the AppDynamics Community. I am the Product Manager for ADQL and the Events Service (which ADQL ultimately ends up querying against). From your question, it sounds like there are two things you might be seeking two do: View all unique values for the respective field (say that field is responseTime, since it's numeric) View the cardinality of that field Case 1: View all unique values for the respective field You can view all the unique values for the respective field as such: SELECT distinct responseTime FROM transactions LIMIT 10000 Note that you can't use braces (I stumbled over this as well when I crafted this response, and it seems you may have encountered the same issue) in older Controller versions, but we fixed this limitation in the newest Controllers (which now work with braces as well.) Case 2: View the cardinality of a field In this case, you'd want to issue a query like such: SELECT distinctcount(responseTime) FROM transactions LIMIT 10000 This query will give you the cardinality of the numeric field, i.e. how many *unique* values exist in the Events Service over the specific time period. I hope this helps - please don't hesitate to reach out again on this thread should you require any further assistance. Happy ADQL-ing, Stefan

Stefan.Hermanek · ‎11-05-2018

Hello@Mohammad.Younis, Thank you for reaching out to us. I am a Product Manager at AppDynamics working on our Big Data Backend (we call it the "Events Service"). I can see two potential root causes behind why you may not see the data you'd expect in your environment. First, metrics are computed every minute, whereas Analytics searches can run over longer time ranges. I trust that you've adjusted the time-range to reflect that, which leads me to the second potential issue. Analytics Metrics are inherently dependent on timely ingestion of the data into the Events Service - after all, you can't query against data that's not "there" yet. Unfortunately, there have been very rare occasions where this has proven to not be the case in our SaaS environment and where we have experienced sustained lag in our system. Our Engg team is already working to build a more robust solution so this failure possibility is greatly reduced. Should you need further info, I will be happy to coordinate a call with your account manager and myself to discuss in more detail about this functionality. Thank you, Stefan

Stefan.Hermanek · ‎08-13-2018

[Deadline February 28, 2019] Apply to Participate in the Transaction Analytics Beta Program: Agentless Analytics on SaaS The Business iQ team is working diligently to empower more customers (like you) to unlock the business value of your application data. To achieve this end, we’d like to collaborate with a small group of customers to help us take additional steps forward to design solutions with the customer in mind. We’re embarking on a limited beta release of Agentless Analytics on SaaS. If you’re interested in kicking around this offering and providing valuable feedback, please apply for the beta program, fill out the 6-question intake application. Subsequently, if your application is a good fit for the beta program we will follow up with additional steps and more information. What is Agentless Analytics on SaaS? Agentless Analytics allows you to collect Transaction Analytics data with the press of a few buttons. Once this data reaches our SaaS data store, you will be able to: Build dashboards Track User Journeys Run ADQL queries Visualize long-running busin ess processes within Business Journeys Getting started with Business iQ has never been easier. By leveraging our existing application agents, you’re able to get the most out of Transaction Analytics and collect custom data. You may have already felt a few pain points around bringing Java-based analytics agents into your environment, particularly if you’re using .NET. Agentless Analytics can dramatically reduce your total cost of ownership by streamlining installation, maintenance, and monitoring of one or many analytics agents on top of existing application agents. Now you can confidently begin your journey with Business iQ. If this offering is relevant to your enterprise needs, we encourage you to apply for the Transaction Analytics Beta Program on Agentless Analytics by filling in this 6-question form. This community post mentions features that are currently beta. The development, release, and timing of any features or functionality described for AppDynamics' products remains at AppDynamics' sole discretion. AppDynamics reserves the right to change the features at any time before making them generally available as well as never making them generally available. Any buying decisions should be made based on features and products that are currently generally available.

Date Registered	‎01-26-2018 10:32 AM
Date Last Visited	‎12-20-2018 03:08 PM
Total Messages Posted	4
Total Kudos Received	5

Discussion Feed

Re: How to get report/list of custom user data val...

Re: Analytics search value is different than creat...

Apply to Participate in the Transaction Analytics ...