Last active
December 4, 2022 20:38
-
-
Save htnosm/bddede2c4170d784986c83e40434e5ab to your computer and use it in GitHub Desktop.
New Relic manage data additional information dashboard
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "Manage Data Additional Information", | |
| "description": null, | |
| "permissions": "PUBLIC_READ_WRITE", | |
| "pages": [ | |
| { | |
| "name": "Ingest Resource Request Per Minute", | |
| "description": null, | |
| "widgets": [ | |
| { | |
| "title": "Resource Consumption Limits as a %", | |
| "layout": { | |
| "column": 1, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) /latest(newrelic.resourceConsumption.limitValue) * 100 facet limitName where limitTimeInterval = '1 minute' timeseries limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Max % Consumption in an hour", | |
| "layout": { | |
| "column": 5, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT max(`usage`) FROM (FROM Metric select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) / latest(newrelic.resourceConsumption.limitValue) * 100 as 'usage' facet limitName timeseries ) facet limitName limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "APM Agent API transaction events request per minute", | |
| "layout": { | |
| "column": 9, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) where limitName = 'APM Agent API transaction events requests per minute' TIMESERIES" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Trace API With limit line", | |
| "layout": { | |
| "column": 1, | |
| "row": 4, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) as 'usage', latest(newrelic.resourceConsumption.limitValue) as 'limit' where limitName = 'Trace API requests per minute' TIMESERIES" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Impact FACET", | |
| "layout": { | |
| "column": 5, | |
| "row": 4, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "From Metric select rate(sum(newrelic.resourceConsumption.impact), 1 minute) facet dataType, impact, resource TIMESERIES 1 minute limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "NrIntegrationError by limit", | |
| "layout": { | |
| "column": 9, | |
| "row": 4, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrIntegrationError select count(*) facet limitName TIMESERIES MAX since 1 day ago limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Multi-account limits (on time series charts only)", | |
| "layout": { | |
| "column": 1, | |
| "row": 7, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) / latest(newrelic.resourceConsumption.limitValue) * 100 facet limitName, consumingAccountId where limitTimeInterval = '1 minute' timeseries limit max" | |
| }, | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) / latest(newrelic.resourceConsumption.limitValue) * 100 facet limitName, consumingAccountId where limitTimeInterval = '1 minute' timeseries limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Limit list and NrIntegrationError", | |
| "layout": { | |
| "column": 5, | |
| "row": 7, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric, NrIntegrationError select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) as 'Per Minute Count',latest(newrelic.resourceConsumption.limitValue) as ' limit Value',(rate(sum(newrelic.resourceConsumption.currentValue), 1 minute)/latest(newrelic.resourceConsumption.limitValue)*100)as 'Percent Used', filter (count(*), where NrIntegrationError.limitValue is not null) as 'limit reached count' facet limitName limit 1000" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "Limit Metrics", | |
| "description": null, | |
| "widgets": [ | |
| { | |
| "title": "newrelic.resourceConsumption.limitValue", | |
| "layout": { | |
| "column": 1, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric select latest(newrelic.resourceConsumption.limitValue) WHERE limitTimeInterval = '1 minute' FACET limitName limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "newrelic.resourceConsumption.currentValue", | |
| "layout": { | |
| "column": 5, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric select rate(sum(newrelic.resourceConsumption.currentValue), 1 minute) where limitTimeInterval = '1 minute' FACET limitName limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "newrelic.resourceConsumption.impact", | |
| "layout": { | |
| "column": 9, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "From Metric select rate(sum(newrelic.resourceConsumption.impact), 1 minute) facet dataType, resource, impact, limitName TIMESERIES limit max" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "Data Ingest Problems", | |
| "description": null, | |
| "widgets": [ | |
| { | |
| "title": "Query of Event API issues", | |
| "layout": { | |
| "column": 1, | |
| "row": 1, | |
| "width": 6, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT * FROM NrIntegrationError WHERE newRelicFeature = 'Event API' SINCE 1 WEEK AGO LIMIT 100" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Query of Metric API issues", | |
| "layout": { | |
| "column": 7, | |
| "row": 1, | |
| "width": 6, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT * FROM NrIntegrationError WHERE newRelicFeature = 'Metrics' SINCE 1 WEEK AGO LIMIT 100" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Query of distributed tracing issues", | |
| "layout": { | |
| "column": 1, | |
| "row": 4, | |
| "width": 6, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT * FROM NrIntegrationError WHERE newRelicFeature = 'Distributed Tracing' SINCE 1 WEEK AGO LIMIT 100" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Query of issues over time", | |
| "layout": { | |
| "column": 7, | |
| "row": 4, | |
| "width": 6, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT count(*) FROM NrIntegrationError WHERE newRelicFeature = 'Metrics' TIMESERIES" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "Event Data", | |
| "description": null, | |
| "widgets": [ | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 1, | |
| "width": 12, | |
| "height": 1 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# General account changes" | |
| } | |
| }, | |
| { | |
| "title": "What changes have been made to the New Relic account", | |
| "layout": { | |
| "column": 1, | |
| "row": 2, | |
| "width": 12, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT timestamp, actionIdentifier, actorEmail, actorType, description, scopeType, targetType \nfrom NrAuditEvent SINCE 1 day ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "What type of account change was made the most", | |
| "layout": { | |
| "column": 1, | |
| "row": 5, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT count(*) AS Actions FROM NrAuditEvent \nFACET actionIdentifier SINCE 1 week ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "What trends appear in account changes", | |
| "layout": { | |
| "column": 5, | |
| "row": 5, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT count(*) from NrAuditEvent TIMESERIES facet actionIdentifier since 1 week ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "What accounts were added to our organization", | |
| "layout": { | |
| "column": 1, | |
| "row": 8, | |
| "width": 12, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT actorEmail, actorId, targetId FROM NrAuditEvent WHERE actionIdentifier = 'account.create' SINCE 1 month ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "What changes have been made to a monitor", | |
| "layout": { | |
| "column": 1, | |
| "row": 11, | |
| "width": 12, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT count(*) FROM NrAuditEvent \nFACET actionIdentifier, description, actorEmail \nSINCE 1 week ago LIMIT 1000" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 14, | |
| "width": 12, | |
| "height": 1 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# Changes made by specific users" | |
| } | |
| }, | |
| { | |
| "title": "What account changes have been made by any user", | |
| "layout": { | |
| "column": 1, | |
| "row": 15, | |
| "width": 12, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT actionIdentifier, description, actorEmail, actorId, targetType, targetId \nFROM NrAuditEvent WHERE actorType = 'user' \nSINCE 1 week ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Who made the most changes to the account", | |
| "layout": { | |
| "column": 1, | |
| "row": 18, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT count(*) as Users FROM NrAuditEvent \nWHERE actorType = 'user' \nFACET actorEmail SINCE 1 week ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "What monitors were created by a specific user", | |
| "layout": { | |
| "column": 5, | |
| "row": 18, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT count(*) FROM NrAuditEvent \nFACET actorEmail, actionIdentifier, description \nSINCE 1 week ago LIMIT 1000" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 21, | |
| "width": 12, | |
| "height": 1 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# Changes made using the API" | |
| } | |
| }, | |
| { | |
| "title": "What account changes have been made using an API key", | |
| "layout": { | |
| "column": 1, | |
| "row": 22, | |
| "width": 12, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.table" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT actionIdentifier, description, targetType, targetId, actorAPIKey, actorId, actorEmail \nFROM NrAuditEvent WHERE actorType = 'api_key' SINCE 1 week ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "Usage Data", | |
| "description": null, | |
| "widgets": [ | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 1, | |
| "width": 12, | |
| "height": 1 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# Data ingest usage" | |
| } | |
| }, | |
| { | |
| "title": "Daily data usage", | |
| "layout": { | |
| "column": 1, | |
| "row": 2, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrConsumption SELECT sum(GigabytesIngested) \nWHERE productLine = 'DataPlatform' \nSINCE 3 months ago TIMESERIES 1 day" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Daily data usage", | |
| "layout": { | |
| "column": 5, | |
| "row": 2, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrConsumption SELECT sum(GigabytesIngested) \nWHERE productLine = 'DataPlatform' SINCE 3 months ago \nFACET usageMetric TIMESERIES 1 day" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Metrics ingest by source", | |
| "layout": { | |
| "column": 9, | |
| "row": 2, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric SELECT bytecountestimate()/10e8 as 'GB Estimate' \nFACET metricName LIMIT 10 TIMESERIES 1 day" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Month-to-date data usage", | |
| "layout": { | |
| "column": 1, | |
| "row": 5, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrMTDConsumption SELECT latest(GigabytesIngested) \nWHERE productLine = 'DataPlatform'" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 8, | |
| "width": 12, | |
| "height": 1 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# Synthetics usage" | |
| } | |
| }, | |
| { | |
| "title": "Total synthetics consumption", | |
| "layout": { | |
| "column": 1, | |
| "row": 9, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT (sum(syntheticsFailedCheckCount) + sum(syntheticsSuccessCheckCount)) AS 'Total Checks' FROM NrDailyUsage WHERE syntheticsTypeLabel != 'Ping' SINCE 1 month ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Synthetics consumption by month", | |
| "layout": { | |
| "column": 5, | |
| "row": 9, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT (sum(syntheticsFailedCheckCount) + sum(syntheticsSuccessCheckCount)) AS 'Total Checks' FROM NrDailyUsage WHERE syntheticsTypeLabel != 'Ping' SINCE 6 months ago FACET monthOf(timestamp)" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Synthetics consumption by account", | |
| "layout": { | |
| "column": 9, | |
| "row": 9, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT (sum(syntheticsFailedCheckCount) + sum(syntheticsSuccessCheckCount)) AS 'Total Checks' FROM NrDailyUsage WHERE syntheticsTypeLabel != 'Ping' SINCE 1 month ago FACET consumingAccountName" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Synthetics consumption by monitor type", | |
| "layout": { | |
| "column": 1, | |
| "row": 12, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT (sum(syntheticsFailedCheckCount) + sum(syntheticsSuccessCheckCount)) AS 'Total Checks' FROM NrDailyUsage WHERE syntheticsTypeLabel != 'Ping' SINCE 1 month ago FACET syntheticsTypeLabel" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Synthetics consumption by monitor name", | |
| "layout": { | |
| "column": 5, | |
| "row": 12, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT (sum(syntheticsFailedCheckCount) + sum(syntheticsSuccessCheckCount)) AS 'Total Checks' FROM NrDailyUsage WHERE syntheticsTypeLabel != 'Ping' SINCE 1 month ago FACET syntheticsMonitorName" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Synthetics consumption by location", | |
| "layout": { | |
| "column": 9, | |
| "row": 12, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT (sum(syntheticsFailedCheckCount) + sum(syntheticsSuccessCheckCount)) AS 'Total Checks' FROM NrDailyUsage WHERE syntheticsTypeLabel != 'Ping' SINCE 1 month ago FACET syntheticsLocationLabel" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 15, | |
| "width": 12, | |
| "height": 1 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# User count" | |
| } | |
| }, | |
| { | |
| "title": "Month-to-date full platform users", | |
| "layout": { | |
| "column": 1, | |
| "row": 16, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrMTDConsumption SELECT latest(FullPlatformUsersBillable)" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Month-to-date core users", | |
| "layout": { | |
| "column": 5, | |
| "row": 16, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrMTDConsumption SELECT latest(CoreUsersBillable)" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 19, | |
| "width": 12, | |
| "height": 2 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# Cost-related\n- ref\n - [per-GB ingested data cost](https://docs.newrelic.com/docs/accounts/accounts-billing/new-relic-one-pricing-billing/data-ingest-billing/#data-prices)\n - [organization's full platform user cost](https://newrelic.com/pricing#pricing_plan-user)" | |
| } | |
| }, | |
| { | |
| "title": "This month's estimated cost for data", | |
| "layout": { | |
| "column": 1, | |
| "row": 21, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrMTDConsumption SELECT latest(GigabytesIngestedBillable)*{{ingested_data_cost}}" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "This month's billable user cost", | |
| "layout": { | |
| "column": 5, | |
| "row": 21, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrMTDConsumption SELECT latest(FullUsersBillable)*{{full_platform_user_cost}}" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "Baseline", | |
| "description": null, | |
| "widgets": [ | |
| { | |
| "title": "Browser monitoring data has each account ingested in the last 30 days", | |
| "layout": { | |
| "column": 1, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrConsumption SELECT sum(GigabytesIngested) WHERE usageMetric = 'BrowserEventsBytes' SINCE 30 days AGO COMPARE WITH 30 days AGO FACET consumingAccountName" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Daily average ingest has been for the past month", | |
| "layout": { | |
| "column": 5, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT rate(sum(GigabytesIngested), 1 day) AS 'Daily Ingest Rate (GB)' FROM NrConsumption WHERE productLine = 'DataPlatform' LIMIT MAX SINCE 30 days AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Facet by calendar month", | |
| "layout": { | |
| "column": 9, | |
| "row": 1, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT sum(GigabytesIngested) AS 'Daily Ingest Rate (GB)' FROM NrConsumption WHERE productLine = 'DataPlatform' FACET monthOf(timestamp) LIMIT MAX SINCE 56 weeks AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Change analysis", | |
| "layout": { | |
| "column": 1, | |
| "row": 4, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT sum(GigabytesIngested) FROM NrConsumption WHERE productLine = 'DataPlatform' AND usageMetric = 'BrowserEventsBytes' SINCE 6 months AGO UNTIL 1 week AGO TIMESERIES 7 weeks COMPARE WITH 2 months ago" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "ingest rate per day", | |
| "layout": { | |
| "column": 5, | |
| "row": 4, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrConsumption SELECT rate(sum(GigabytesIngested), 1 day) WHERE productLine = 'DataPlatform' SINCE 26 weeks AGO TIMESERIES 1 DAY" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "ingest rate per day (sliding window of four days)", | |
| "layout": { | |
| "column": 9, | |
| "row": 4, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM NrConsumption SELECT rate(sum(GigabytesIngested), 1 day) WHERE productLine = 'DataPlatform' since 24 weeks ago TIMESERIES 1 DAY SLIDE BY 4 days" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Using a seven day derivative to explore ingest trends", | |
| "layout": { | |
| "column": 1, | |
| "row": 7, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.line" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "legend": { | |
| "enabled": true | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "SELECT derivative(sum(GigabytesIngested) , 7 day) FROM NrConsumption WHERE productLine = 'DataPlatform' and usageMetric = 'BrowserEventsBytes' LIMIT MAX SINCE 3 MONTHS AGO UNTIL THIS MONTH TIMESERIES 1 MONTH slide by 3 days COMPARE WITH 1 WEEK AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| }, | |
| "yAxisLeft": { | |
| "zero": true | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Ingest by application(APM) estimate 30 day rate", | |
| "layout": { | |
| "column": 5, | |
| "row": 7, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Transaction, TransactionError, TransactionTrace, SqlTrace, ErrorTrace, Span SELECT rate(bytecountestimate()/10e8, 30 day) AS 'GB Ingest' FACET appName SINCE 1 WEEK AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Ingest by application(Browser) estimate 30 day rate", | |
| "layout": { | |
| "column": 9, | |
| "row": 7, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM PageAction, PageView, PageViewTiming, AjaxRequest, JavaScriptError SELECT rate(bytecountestimate()/10e8, 30 day) AS 'GB Ingest' FACET appName SINCE 1 WEEK AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Ingest by application(Mobile) estimate 30 day rate", | |
| "layout": { | |
| "column": 1, | |
| "row": 10, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Mobile, MobileRequestError, MobileSession SELECT rate(bytecountestimate()/10e8, 30 day) AS 'GB Ingest' FACET appName SINCE 1 WEEK AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Metric ingest by integration estimate 30 day rate", | |
| "layout": { | |
| "column": 5, | |
| "row": 10, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric SELECT rate(bytecountestimate()/10e8, 30 day) FACET usage.integrationName SINCE 1 WEEK AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Metric ingest by integration seven day sum", | |
| "layout": { | |
| "column": 9, | |
| "row": 10, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Metric SELECT bytecountestimate()/10e8 FACET usage.integrationName SINCE 1 WEEK AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Log ingest by host for past 3 hours (total)", | |
| "layout": { | |
| "column": 1, | |
| "row": 13, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Log SELECT bytecountestimate()/10e8 \n WHERE host is not NULL SINCE 3 hours ago FACET host" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Log ingest by host (30 day rate)", | |
| "layout": { | |
| "column": 5, | |
| "row": 13, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Log SELECT rate(bytecountestimate()/10e8, 30 day) \n WHERE host is not NULL SINCE 3 hours ago FACET host" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Log ingest by cluster_name (30 day rate)", | |
| "layout": { | |
| "column": 9, | |
| "row": 13, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Log SELECT rate(bytecountestimate()/10e8, 30 day) \n WHERE host is not NULL SINCE 3 hours ago FACET cluster_name" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Log ingest by cluster_name and container_name (30 day rate)", | |
| "layout": { | |
| "column": 1, | |
| "row": 16, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM Log SELECT rate(bytecountestimate()/10e8, 30 day) \n WHERE host is not NULL SINCE 3 hours ago FACET cluster_name, container_name" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Ingest By Kubernetes cluster estimate 30 day rate", | |
| "layout": { | |
| "column": 5, | |
| "row": 16, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM K8sClusterSample, K8sContainerSample,K8sDaemonsetSample, K8sDeploymentSample, K8sEndpointSample, K8sHpaSample, K8sNamespaceSample, K8sNodeSample, K8sPodSample, K8sReplicasetSample, K8sServiceSample, K8sVolumeSample SELECT rate(bytecountestimate()/10e8, 30 day) AS 'GB Ingest' FACET clusterName SINCE 1 WEEK AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Process samples estimate 30 day rate by command name", | |
| "layout": { | |
| "column": 9, | |
| "row": 16, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.bar" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM ProcessSample SELECT rate(bytecountestimate()/10e8, 30 day) AS 'GB Ingested' FACET commandName SINCE 1 DAY AGO" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| }, | |
| { | |
| "title": "Listing of ingest by K8s event type", | |
| "layout": { | |
| "column": 1, | |
| "row": 19, | |
| "width": 4, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.billboard" | |
| }, | |
| "rawConfiguration": { | |
| "facet": { | |
| "showOtherSeries": false | |
| }, | |
| "nrqlQueries": [ | |
| { | |
| "accountId": __NEW_RELIC_ACCOUNT_ID__, | |
| "query": "FROM\nK8sApiServerSample,\nK8sClusterSample,\nK8sContainerSample,\nK8sControllerManagerSample,\nK8sDaemonsetSample,\nK8sDeploymentSample,\nK8sEndpointSample,\nK8sNamespaceSample,\nK8sNodeSample,\nK8sPodSample,\nK8sReplicasetSample,\nK8sSchedulerSample,\nK8sServiceSample,\nK8sStatefulsetSample,\nK8sVolumeSample\nSELECT bytecountestimate()/10e8 AS 'Gigabytes'\nSINCE 1 DAYS AGO\nLIMIT MAX FACET entityType" | |
| } | |
| ], | |
| "platformOptions": { | |
| "ignoreTimeRange": false | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "README", | |
| "description": null, | |
| "widgets": [ | |
| { | |
| "title": "", | |
| "layout": { | |
| "column": 1, | |
| "row": 1, | |
| "width": 8, | |
| "height": 3 | |
| }, | |
| "linkedEntityGuids": null, | |
| "visualization": { | |
| "id": "viz.markdown" | |
| }, | |
| "rawConfiguration": { | |
| "text": "# Manage Data Additional Information\n\nMore Information: [New Relic data management hub \\| New Relic Documentation](https://docs.newrelic.com/docs/data-apis/manage-data/manage-your-data)\n\n- Ingest Resource Request Per Munute / Limit Metrics\n - [Query system limits \\| New Relic Documentation](https://docs.newrelic.com/docs/data-apis/manage-data/query-limits/)\n- Data Ingest Problems\n\t- [Use NrIntegrationError event to understand data ingest problems \\| New Relic Documentation](https://docs.newrelic.com/docs/data-apis/manage-data/nrintegrationerror)\n- Event Data\n\t- [NrAuditEvent event data and query examples \\| New Relic Documentation](https://docs.newrelic.com/docs/data-apis/understand-data/event-data/nrauditevent-event-data-query-examples/)\n- Usage Data\n - [Query and alert on usage data \\| New Relic Documentation](https://docs.newrelic.com/docs/accounts/accounts-billing/new-relic-one-pricing-billing/usage-queries-alerts#billable-full-platform-users-for-the-month)\n- Baseline\n - [Baseline your data ingest \\| New Relic Documentation](https://docs.newrelic.com/docs/new-relic-solutions/observability-maturity/operational-efficiency/data-governance-baseline-ingest-guide/)\n" | |
| } | |
| } | |
| ] | |
| } | |
| ], | |
| "variables": [ | |
| { | |
| "name": "ingested_data_cost", | |
| "items": [ | |
| { | |
| "title": null, | |
| "value": "0.30" | |
| }, | |
| { | |
| "title": null, | |
| "value": "0.35" | |
| }, | |
| { | |
| "title": null, | |
| "value": "0.50" | |
| }, | |
| { | |
| "title": null, | |
| "value": "0.55" | |
| } | |
| ], | |
| "defaultValues": [ | |
| { | |
| "value": { | |
| "string": "0.30" | |
| } | |
| } | |
| ], | |
| "nrqlQuery": null, | |
| "title": "per-GB ingested data cost", | |
| "type": "ENUM", | |
| "isMultiSelection": false, | |
| "replacementStrategy": "NUMBER" | |
| }, | |
| { | |
| "name": "full_platform_user_cost", | |
| "items": [ | |
| { | |
| "title": null, | |
| "value": "99" | |
| } | |
| ], | |
| "defaultValues": [ | |
| { | |
| "value": { | |
| "string": "99" | |
| } | |
| } | |
| ], | |
| "nrqlQuery": null, | |
| "title": "organization's full platform user cost", | |
| "type": "ENUM", | |
| "isMultiSelection": false, | |
| "replacementStrategy": "NUMBER" | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment