Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

Examples from Webinars


#1

I just watched the recording of the recent webinar “Dashboards for DevOps” https://www.newrelic.com/webinar/dashboards-DevOps-180912
It was mentioned that examples of the dashboards would be made available, but I can’t find where?
Any ideas where to look for these?

Are there similar resources/examples from other webinars?


#2

@ian.hodgetts - I’m not sure where resources for Webinars are kept, but I can reach out to Barry and @bgomes from that webinar to find out. :slight_smile:


#3

Thanks. Maybe it’s because I couldn’t actually “attend” at the time (just watched the recording)?


#4

@ian.hodgetts I have attached the raw JSON from each of our DevOps Dashboards 1-6 below.

Dashboard 1
{"title":"NR-DevOps View 1","icon":"bar-chart","grid_column_count":3,"filter":{"key_names":["appName","city","countryCode","duration","httpResponseCode","name","pageUrl","session","userAgentName","userAgentVersion"],"event_types":["Transaction","PageView"],"filter_first":false},"owner":{"email":"example@example.com"},"widgets":[{"title":"Active Users","nrql":"SELECT uniqueCount(username)*4.32 AS '' FROM Transaction SINCE 1 day ago COMPARE WITH 1 day ago","process_as":"billboard_comparison","width":1,"height":1,"row":1,"column":1,"event_types":["Transaction"],"facet":null,"customizations":null,"notes":null},{"title":"Average Transaction Time","nrql":"SELECT average(duration) AS '' FROM Transaction SINCE 1 day ago","process_as":"gauge","width":1,"height":1,"row":1,"column":2,"event_types":["Transaction"],"facet":null,"customizations":{"limit":0.3},"notes":null},{"title":"% Uptime","nrql":"SELECT percentage(count(*), WHERE result = 'SUCCESS') AS 'Availability' FROM SyntheticCheck SINCE 1 day ago COMPARE WITH 1 day ago","process_as":"billboard_comparison","width":1,"height":1,"row":1,"column":3,"event_types":["SyntheticCheck"],"facet":null,"customizations":null,"notes":null},{"title":"Page Load","nrql":"SELECT histogram(duration,5) FROM PageView SINCE 1 day ago","process_as":"histogram","width":1,"height":1,"row":2,"column":1,"event_types":["PageView"],"facet":null,"customizations":null,"notes":null},{"title":"User Journey","nrql":"SELECT funnel(session, WHERE pageUrl='http://webportal.telco.nrdemo.com/' AS 'Visited Home Page', WHERE pageUrl = 'http://webportal.telco.nrdemo.com/browse/phones' AS 'Search', WHERE pageUrl = 'http://webportal.telco.nrdemo.com/browse/phones/12324433' AS 'Select', WHERE pageUrl = 'http://webportal.telco.nrdemo.com/checkout' AS 'Checkout')  FROM PageView SINCE 1 day ago","process_as":"funnel","width":1,"height":1,"row":2,"column":2,"event_types":["PageView"],"facet":null,"customizations":null,"notes":null,"steps":null,"resource":null},{"title":"Application Response Codes","nrql":"SELECT count(*)/1000 AS '' FROM Transaction WHERE httpResponseCode NOT in ('101','200','201','204','206','301','302','303','304','307') SINCE 1 day ago FACET httpResponseCode","process_as":"facet_pie_chart","width":1,"height":1,"row":2,"column":3,"event_types":["Transaction"],"facet":"httpResponseCode","customizations":{"drilldown":{"dashboard_id":711108}},"notes":null},{"title":"Throughput","nrql":"SELECT count(*) FROM Transaction SINCE 1 minute ago TIMESERIES AUTO","process_as":"line_chart","width":1,"height":1,"row":3,"column":1,"event_types":["Transaction"],"facet":null,"customizations":null,"notes":null},{"title":"404","nrql":"SELECT count(*) FROM Transaction SINCE 1 minute ago TIMESERIES AUTO WHERE httpResponseCode = '404'","process_as":"line_chart","width":1,"height":1,"row":3,"column":2,"event_types":["Transaction"],"facet":null,"customizations":null,"notes":null},{"title":"404","nrql":"SELECT count(*) FROM Transaction SINCE 1 minute ago  WHERE httpResponseCode = '404' FACET name","process_as":"facet_pie_chart","width":1,"height":1,"row":3,"column":3,"event_types":["Transaction"],"facet":"name","customizations":{"drilldown":{"dashboard_id":711108}},"notes":null}],"dashboard_account_id":1606862}
Dashboard 2
{"title":"NR-DevOps View 2","icon":"bar-chart","grid_column_count":3,"filter":{"key_names":["appName","duration","session","userAgentName","countryCode","name","pageUrl","userAgentVersion"],"event_types":["Transaction","PageView"],"filter_first":false},"owner":{"email":"example@example.com"},"widgets":[{"title":"Highest Activity Applications","nrql":"SELECT count(*) FROM Transaction SINCE 1 day ago FACET appName LIMIT 3","process_as":"facet_pie_chart","width":1,"height":1,"row":1,"column":1,"event_types":["Transaction"],"facet":"appName","customizations":{"drilldown":{"dashboard_id":711248}},"notes":null},{"title":"Average Transaction Time","nrql":"SELECT average(duration) AS '' FROM Transaction since 1 day ago FACET appName LIMIT 3","process_as":"facet_bar_chart","width":1,"height":1,"row":1,"column":2,"event_types":["Transaction"],"facet":"appName","customizations":{"drilldown":{"dashboard_id":711248}},"notes":null},{"title":"Average Database Time","nrql":"SELECT average(databaseDuration) AS '' FROM Transaction SINCE 1 day ago COMPARE WITH 1 day ago","process_as":"billboard_comparison","width":1,"height":1,"row":1,"column":3,"event_types":["Transaction"],"facet":null,"customizations":null,"notes":null},{"title":"Application Throughput","nrql":"SELECT count(*) AS '' FROM Transaction SINCE 1 day ago TIMESERIES AUTO","process_as":"line_chart","width":1,"height":1,"row":2,"column":1,"event_types":["Transaction"],"facet":null,"customizations":null,"notes":null},{"title":"Average System Load","nrql":"SELECT average(loadAverageFiveMinute) FROM SystemSample TIMESERIES FACET `entityId` WHERE (`entityId` in ('375497644865145745', '1314561057018499173', '6178820121183345925', '4428002613725084755', '7454023453362287431')) LIMIT 100 SINCE 1 day ago","process_as":"faceted_line_chart","width":1,"height":1,"row":2,"column":2,"event_types":["SystemSample"],"facet":"entityId","customizations":null,"notes":null},{"title":"Memory Used","nrql":"SELECT average(memoryUsedBytes/memoryTotalBytes*100) FROM SystemSample TIMESERIES FACET `entityId` WHERE (`entityId` in ('375497644865145745', '1314561057018499173', '6178820121183345925', '4428002613725084755', '7454023453362287431')) LIMIT 100 SINCE 1 day ago","process_as":"faceted_line_chart","width":1,"height":1,"row":2,"column":3,"event_types":["SystemSample"],"facet":"entityId","customizations":null,"notes":null}],"dashboard_account_id":1606862}
Dashboard 3
{"title":"NR-DevOps View 3","icon":"bar-chart","grid_column_count":3,"filter":{"key_names":["error","host","appName","username"],"event_types":["DeployMark","Transaction","alert"],"filter_first":false},"owner":{"email":"example@example.com"},"widgets":[{"title":"CPU","nrql":"SELECT average(cpuUserPercent) AS '' FROM SystemSample SINCE 1 week ago FACET hostname LIMIT 3 TIMESERIES AUTO","process_as":"faceted_line_chart","width":1,"height":1,"row":1,"column":1,"event_types":["SystemSample"],"facet":"hostname","customizations":null,"notes":null},{"title":"Errors by Application","nrql":"SELECT count(*) FROM TransactionError SINCE 1 week ago FACET transactionUiName LIMIT 3 TIMESERIES AUTO","process_as":"faceted_line_chart","width":1,"height":1,"row":1,"column":2,"event_types":["TransactionError"],"facet":"transactionUiName","customizations":null,"notes":null},{"title":"Build Status","nrql":"SELECT count(`request.method`)/1000 FROM TransactionError FACET CASES(WHERE `request.method` = 'POST' AS 'Success', WHERE `request.method` = 'GET' as 'Failure') SINCE 1 week ago LIMIT 2","process_as":"facet_pie_chart","width":1,"height":1,"row":1,"column":3,"event_types":["TransactionError"],"facet":"cases","customizations":{},"notes":null},{"title":"Network Throughput","nrql":"SELECT average(receiveBytesPerSecond), average(transmitBytesPerSecond) FROM NetworkSample SINCE 1 week ago TIMESERIES AUTO","process_as":"line_chart","width":1,"height":1,"row":2,"column":1,"event_types":["NetworkSample"],"facet":null,"customizations":null,"notes":null},{"title":"Successful Deploys by User","nrql":"SELECT count(*) As 'Deploys' FROM Transaction WHERE errorType IS NULL AND username != 'syntheticuser@acme.com' SINCE 1 week ago FACET username TIMESERIES AUTO LIMIT 3","process_as":"faceted_line_chart","width":1,"height":1,"row":2,"column":2,"event_types":["Transaction"],"facet":"username","customizations":null,"notes":null},{"title":"Failed Deploys by User","nrql":"SELECT count(*) As 'Deploys' FROM Transaction WHERE errorType IS NOT NULL AND username != 'syntheticuser@acme.com' SINCE 1 week ago FACET username TIMESERIES AUTO LIMIT 3","process_as":"faceted_line_chart","width":1,"height":1,"row":2,"column":3,"event_types":["Transaction"],"facet":"username","customizations":null,"notes":null}],"dashboard_account_id":1606862}
Dashboard 4
{"title":"NR-DevOps View 4","icon":"bar-chart","grid_column_count":3,"filter":{"key_names":["clusterName","namespace"],"event_types":["K8sContainerSample","K8sDeploymentSample","K8sNamespaceSample","K8sNodeSample","K8sPodSample","K8sReplicasetSample"],"filter_first":false},"owner":{"email":"example@example.com"},"widgets":[{"title":"Resources Used","nrql":"SELECT average(8) as 'Cores', average(32) AS 'Mem GB' FROM K8sNodeSample SINCE 1 hour ago","process_as":"attribute_sheet","width":1,"height":1,"row":1,"column":1,"event_types":["K8sNodeSample"],"facet":null,"customizations":null,"notes":null},{"title":"# of K8s Objects","nrql":"SELECT uniqueCount(K8sNodeSample.entityId) as 'Nodes', uniqueCount(K8sNamespaceSample.clusterName) as 'Clusters', uniqueCount(K8sNamespaceSample.entityId) as 'Namespaces', uniqueCount(K8sDeploymentSample.entityId) as 'Deployments', uniqueCount(K8sPodSample.entityId) as 'Pods', uniqueCount(K8sContainerSample.containerID) as 'Containers' FROM K8sNodeSample, K8sNamespaceSample, K8sDeploymentSample, K8sPodSample, K8sContainerSample SINCE 1 hour ago","process_as":"attribute_sheet","width":1,"height":1,"row":1,"column":2,"event_types":["K8sNodeSample","K8sNamespaceSample","K8sDeploymentSample","K8sPodSample","K8sContainerSample"],"facet":null,"customizations":null,"notes":null},{"title":"Containers by Namespace","nrql":"SELECT uniqueCount(containerID) FROM K8sContainerSample SINCE 1 hour ago FACET namespace TIMESERIES AUTO","process_as":"faceted_line_chart","width":1,"height":1,"row":1,"column":3,"event_types":["K8sContainerSample"],"facet":"namespace","customizations":null,"notes":null},{"title":"Namespaces per Cluster","nrql":"SELECT uniqueCount(namespace) FROM K8sNamespaceSample SINCE 1 hour ago FACET clusterName LIMIT 3","process_as":"facet_bar_chart","width":1,"height":1,"row":2,"column":1,"event_types":["K8sNamespaceSample"],"facet":"clusterName","customizations":{"drilldown":{"dashboard_id":713961}},"notes":null},{"title":"Pods by Namespace","nrql":"SELECT uniqueCount(entityId) AS 'pod' FROM K8sPodSample FACET namespace SINCE 1 hour ago LIMIT 3","process_as":"facet_bar_chart","width":1,"height":1,"row":2,"column":2,"event_types":["K8sPodSample"],"facet":"namespace","customizations":{"drilldown":{"dashboard_id":713961}},"notes":null},{"title":"Container CPU Usage","nrql":"FROM K8sContainerSample SELECT latest(cpuUsedCores/cpuLimitCores) * 100 as '% CPU' FACET clusterName, podName, containerName TIMESERIES AUTO LIMIT 3 SINCE 1 hour ago","process_as":"faceted_line_chart","width":1,"height":1,"row":2,"column":3,"event_types":["K8sContainerSample"],"facet":"[\"clusterName\", \"podName\", \"containerName\"]","customizations":null,"notes":null},{"title":"Container Memory Usage","nrql":"FROM K8sContainerSample SELECT latest(memoryUsedBytes/memoryLimitBytes) * 100 as '% Memory' FACET clusterName, podName, containerName SINCE 1 hour ago TIMESERIES AUTO LIMIT 3","process_as":"faceted_line_chart","width":1,"height":1,"row":3,"column":1,"event_types":["K8sContainerSample"],"facet":"[\"clusterName\", \"podName\", \"containerName\"]","customizations":null,"notes":null},{"title":"Pods not Running by Cluster/Namespace","nrql":"SELECT latest(status) as 'Status' from K8sPodSample WHERE status NOT IN ('Running') facet clusterName, namespace, podName since 10 minutes ago UNTIL 1 minute ago limit 100","process_as":"facet_table","width":2,"height":1,"row":3,"column":2,"event_types":["K8sPodSample"],"facet":"[\"clusterName\", \"namespace\", \"podName\"]","customizations":{},"notes":null}],"dashboard_account_id":1606862}
Dashboard 5
{"title":"NR-DevOps View 5","icon":"bar-chart","grid_column_count":3,"filter":{"key_names":["appName","duration","session","userAgentName","countryCode","name","pageUrl","userAgentVersion","httpResponseCode"],"event_types":["Transaction","PageView"],"filter_first":false},"owner":{"email":"example@example.com"},"widgets":[{"title":"Active Users","nrql":"SELECT uniqueCount(username) AS '' FROM Transaction SINCE 1 day ago COMPARE WITH 1 day ago","process_as":"billboard_comparison","width":1,"height":1,"row":1,"column":1,"event_types":["Transaction"],"facet":null,"customizations":null,"notes":null},{"title":"Page Load","nrql":"SELECT histogram(duration,4) FROM PageView SINCE 1 day ago","process_as":"histogram","width":1,"height":1,"row":1,"column":2,"event_types":["PageView"],"facet":null,"customizations":null,"notes":null},{"title":"Application Errors","nrql":"SELECT count(*)/1000 AS '' FROM Transaction WHERE httpResponseCode NOT in ('101','200','201','204','206','301','302','303','304','307') SINCE 1 day ago FACET httpResponseCode","process_as":"facet_pie_chart","width":1,"height":1,"row":1,"column":3,"event_types":["Transaction"],"facet":"httpResponseCode","customizations":{"drilldown":{"dashboard_id":713782}},"notes":null},{"title":"Average Shopping Basket (€)","nrql":"SELECT average(duration)*10000 AS '' FROM Transaction SINCE 1 day ago","process_as":"billboard","width":1,"height":1,"row":2,"column":1,"event_types":["Transaction"],"facet":null,"customizations":{},"notes":null},{"title":"Users at Risk","nrql":"SELECT uniqueCount(username) AS '' FROM Transaction WHERE httpResponseCode NOT in ('101','200','201','204','206','301','302','303','304','307') SINCE today","process_as":"billboard","width":1,"height":1,"row":2,"column":2,"event_types":["Transaction"],"facet":null,"customizations":{"thresholds":{"warning":50.0,"critical":100.0}},"notes":null},{"title":"Revenue at Risk (€)","nrql":"SELECT average(duration)*10000*uniqueCount(username) AS '' FROM Transaction WHERE httpResponseCode NOT in ('200','201','301','302') SINCE 1 day ago","process_as":"billboard","width":1,"height":1,"row":2,"column":3,"event_types":["Transaction"],"facet":null,"customizations":{"thresholds":{"warning":100000.0,"critical":110000.0}},"notes":null}],"dashboard_account_id":1606862}
Dashboard 6
{"title":"NR-DevOps View 6","icon":"cog","grid_column_count":3,"filter":{"key_names":["hostname","commandName"],"event_types":["SystemSample","ProcessSample"],"filter_first":false},"owner":{"email":"example@example.com"},"widgets":[{"title":"Server CPU","nrql":"SELECT average(cpuPercent) FROM SystemSample since 3 hours ago facet hostname limit 10","process_as":"facet_bar_chart","width":1,"height":1,"row":1,"column":1,"event_types":["SystemSample"],"facet":"hostname","customizations":{"drilldown":{"dashboard_id":721203}},"notes":null},{"title":"Network I/O","nrql":"SELECT average(receiveBytesPerSecond), average(transmitBytesPerSecond) FROM NetworkSample SINCE 30 MINUTES AGO TIMESERIES AUTO","process_as":"line_chart","width":1,"height":1,"row":1,"column":2,"event_types":["NetworkSample"],"facet":null,"customizations":null,"notes":null},{"title":"Memory Usage","nrql":"SELECT average(memoryUsedBytes) /1000000 AS 'Avg MB Used', average(memoryFreeBytes)/1000000 AS 'Avg MB Free' FROM SystemSample since 10 minutes ago","process_as":"attribute_sheet","width":1,"height":1,"row":1,"column":3,"event_types":["SystemSample"],"facet":null,"customizations":null,"notes":null},{"title":"Errors over Time by Type","nrql":"SELECT count(*) FROM TransactionError FACET `error.message` SINCE 1 day ago TIMESERIES","process_as":"faceted_area_chart","width":1,"height":1,"row":2,"column":1,"event_types":["TransactionError"],"facet":"error.message","customizations":null,"notes":null},{"title":"System Load","nrql":"SELECT average(loadAverageOneMinute) , average(loadAverageFiveMinute), average(loadAverageFifteenMinute) FROM SystemSample since 3 hours ago TIMESERIES","process_as":"line_chart","width":1,"height":1,"row":2,"column":2,"event_types":["SystemSample"],"facet":null,"customizations":null,"notes":null},{"title":"Application Throughput by Host","nrql":"SELECT count(*) FROM Transaction FACET host SINCE 1 day ago TIMESERIES AUTO","process_as":"faceted_line_chart","width":1,"height":1,"row":2,"column":3,"event_types":["Transaction"],"facet":"host","customizations":null,"notes":null},{"title":"Process Breakdown","nrql":"SELECT count(*), average(threadCount), average(cpuPercent), average(cpuSystemPercent) FROM ProcessSample FACET commandName SINCE 1 hour ago LIMIT 5","process_as":"facet_table","width":1,"height":1,"row":3,"column":1,"event_types":["ProcessSample"],"facet":"commandName","customizations":{"drilldown":{"dashboard_id":721203}},"notes":null},{"title":"Disk Utilization","nrql":"SELECT max(diskUsedPercent) as 'Percent Full' FROM StorageSample since 1 minute ago","process_as":"gauge","width":1,"height":1,"row":3,"column":2,"event_types":["StorageSample"],"facet":null,"customizations":{"limit":100.0},"notes":null},{"title":"Disk I/O","nrql":"SELECT average(readBytesPerSecond), average(writeBytesPerSecond) FROM StorageSample SINCE 30 MINUTES AGO TIMESERIES AUTO","process_as":"line_chart","width":1,"height":1,"row":3,"column":3,"event_types":["StorageSample"],"facet":null,"customizations":null,"notes":null}],"dashboard_account_id":1606862}

In the JSON above you’ll see the NRQL queries. Some of these are targeting specific hostnames, and may potentially include some additional custom attributes. Hopefully that will get you up and running though.