Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NRQL Syntax issue with dashboard preventing import #2081

Closed
jsbnr opened this issue Sep 27, 2023 · 2 comments
Closed

NRQL Syntax issue with dashboard preventing import #2081

jsbnr opened this issue Sep 27, 2023 · 2 comments

Comments

@jsbnr
Copy link

jsbnr commented Sep 27, 2023

"query": "FROM Metric select filter(uniqueCount(k8s.podName), where k8s.status = 'Running') as 'Running Pods', filter(uniqueCount(k8s.podName), where k8s.status = 'Pending') as 'Pending Pods', (average(k8s.node.cpuUsedCores) / average(k8s.node.allocatableCpuCores) * 100) as 'CPU %', (average(k8s.node.memoryWorkingSetBytes) / average(k8s.node.allocatableMemoryBytes) * 100) as 'Mem %', (average(k8s.node.fsUsedBytes) / average(k8s.node.fsCapacityBytes) * 100) as 'Disk Util %' where metricName = 'k8s.pod.createdAt' nodeName is not null facet nodeName limit 2000 since 30 minutes ago"

The NRQL here appears to be missing an AND and is therfore failing to import correctly.

This pat of the NRQL
where metricName = 'k8s.pod.createdAt' nodeName is not null facet nodeName

should possibly read:
where metricName = 'k8s.pod.createdAt' AND nodeName is not null facet nodeName

csalvador-nr added a commit to csalvador-nr/newrelic-quickstarts that referenced this issue Sep 27, 2023
Copy link

Old issues will be closed after 105 days of inactivity. This issue has been quiet for 90 days and is being marked as stale. Reply here to keep this issue open.

@github-actions github-actions bot added the stale label Dec 27, 2023
Copy link

This issue is being closed due to inactivity. Is this a mistake? Please re-open this issue or create a new one.

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Apr 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant