How to view all key requests?

[Lwl]

How to view all key requests defined in the environment. And then I can export it

[Lwl]

It is best to have a corresponding service name

[AntonPineiro · Accepted solution]

Hi,

One option can be from multidimensional analysis:

1. Filter only key requests.
2. Add service name in split dimension.
3. Going down right and Export table.

Or using data explorer with table visualization, for example this query:

builtin:service.keyRequest.response.time:splitBy("dt.entity.service_method"):sort(value(auto,descending))

Best regards

[Lwl]

Thank you very much, but this does not reach the final result I want. What I want is the key request of the whole environment, and I can only get a part of it through your method, which does not meet my expectations. Thank you very much for your reply.

[Lwl]

Thank you very much, your following example is what I want, if can attach the corresponding Srevice name, it would be best

[AntonPineiro · Accepted solution]

Hi,

You can add "parents" and service name appears in another column:

builtin:service.keyRequest.response.time:splitBy("dt.entity.service_method"):sort(value(auto,descending)):parents

You can export it as CSV:

Best regards

[JhonKenneth]

Is this showing only the top 100 key request?

[Lwl]

Yes, this method can only see 100, but the text at the bottom can see all of them

[zietho]

no, if there is no limit attached (in advanced mode) for a table then there should no limit apply and the result should show all tuples of service + request pairs. Potentially 1000+ 
e.g. I removed it here and the count jumped from 20 to 48. So in this environment, I have 48 defined key requests. 

[Lwl · Accepted solution]

builtin:service.keyRequest.response.time:parents:splitBy("dt.entity.service_method","dt.entity.service"):sort(value(auto,descending)):limit(500)

[JhonKenneth]

Is there a way to adjust the limit? currently maximum is 100 as defined.

[zietho · Accepted solution]

TLTR: please switch to Table or Honeycomb, then you can change/remove the limit.

These are the two we believe are scalable with 1000+ items. All others would either suffer in terms of GUI performance or would often (e.g. graph) not make sense with more than 100 different lines, slices,... you would just not perceive any differences anymore. 

A graph with 10 metrics (limit) would result in 1000 lines, which means you see almost nothing anymore. The visualization becomes meaningless. 

[Lwl]

[Kenny_Gillette · Accepted solution]

Are you on managed?  I am guessing so and less than 1.266?  

1.266 removes this limit.

Managed release notes: https://www.dynatrace.com/support/help/whats-new/release-notes/managed/sprint-266

SaaS release notes: https://www.dynatrace.com/support/help/whats-new/release-notes/saas/sprint-266

Data explorer and dashboard table enhancements

Platform | Data explorer

We have made the following improvements to the table visualization:

• Columns: In the Data explorer table visualization, use the checkboxes in the Columns section to enable and disable the display of columns. These selections are reflected in the resulting dashboard tiles.
• Rows: In the Data explorer, you can remove the limit to see more than 100 rows.
• Pages: In the Data explorer and resulting dashboard table tiles, tables are automatically paginated. Use the controls under the table to page through tables.

[JhonKenneth]

This might be the reason why i am still getting the limit of 100. Our Manage Nodes are 3 updates away to 1.266 version.

[Kenny_Gillette]

Yes, that would be it.  Work with team to update to 266 or above.  Some great new items that are beneficial.  

[Kenny_Gillette · Accepted solution]

create a dashboard.  I did this and copied the dashboard to each environment.  i have added mine dashboard to this so you can use.

[Lwl]

Thank you for your reply. Thank you

[Lwl]

What a great dashboard you made! Can you share something else? Look forward to it

[Kenny_Gillette]

Share something else?  what you need?

[Lwl]

Sorry for not replying to your message in time. You made a great dashboard. I don't have any specific needs at the moment, I just want other refined and simple dashboards. Of course, if it's too much trouble, don't. Thank you very much for your reply.

[Kenny_Gillette · Accepted solution]

No worries, just trying to help where I can.  They do have a lot of dashboards pre built that you can pull at https://dynatrace.github.io/BizOpsConfigurator/#home

I have used that for many dashboards.