`github.organization_1_day`

fail

Get Copilot organization usage metrics for a specific day

Requires org and day. Large organizations can return many rows; narrow by one scoping filter before broad scans.

org, day captured 2026-08-31 07:23:58Zmedian 36688 ms

Verdict: FALSE

All variants failed: 6 errors, 0 successful.

What to do

GitHub returned 404

upstream.not_found

Either the resource is private, doesn't exist, or your filter values don't match a real resource.

Try a known public repo (anomalyco/opencode, sst/opencode, octocat/Hello-World)

GitHub returned 404

upstream.not_found

Either the resource is private, doesn't exist, or your filter values don't match a real resource.

Confirm the resource exists: it may be private, removed, or org-scoped

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts	Errors
minimal	2	40390 ms	41924 ms	43458 ms	[0, 0]	2
realistic	2	35242 ms	36688 ms	38135 ms	[0, 0]	2
edge	2	33059 ms	35948 ms	38838 ms	[0, 0]	2

Latency per trial

minimalmedian 41924ms

scale: 0–43458 ms

realisticmedian 36688ms

scale: 0–38135 ms

edgemedian 35948ms

scale: 0–38838 ms

Probe variants — every command + output

minimal2 trials

min 40390ms · median 41924ms · max 43458ms · rows 0,0

smallest valid query

Command

SELECT * FROM github.organization_1_day WHERE org = 'opencode' AND day = '1' LIMIT 1

Trials + output

trial 1·40390ms·rows 0isError=true

Error

Error: Source resource was not found (404)
Detail: {"message":"Not Found","documentation_url":"https://docs.github.com/rest/copilot/copilot-usage-metrics#get-copilot-organization-usage-metrics-for-a-specific-day","status":"404"} [GET] https://api.github.com/orgs/opencode/copilot/metrics/reports/organization-1-day
Hint: Verify the identifier or filter values you passed; the upstream resource was not found.

trial 2·43458ms·rows 0isError=true

Error

Error: Source resource was not found (404)
Detail: {"message":"Not Found","documentation_url":"https://docs.github.com/rest/copilot/copilot-usage-metrics#get-copilot-organization-usage-metrics-for-a-specific-day","status":"404"} [GET] https://api.github.com/orgs/opencode/copilot/metrics/reports/organization-1-day
Hint: Verify the identifier or filter values you passed; the upstream resource was not found.

realistic2 trials

min 35242ms · median 36688ms · max 38135ms · rows 0,0

typical user query

Command

SELECT * FROM github.organization_1_day WHERE org = 'opencode' AND day = '1' LIMIT 25

Trials + output

trial 1·38135ms·rows 0isError=true

Error

Error: Source resource was not found (404)
Detail: {"message":"Not Found","documentation_url":"https://docs.github.com/rest/copilot/copilot-usage-metrics#get-copilot-organization-usage-metrics-for-a-specific-day","status":"404"} [GET] https://api.github.com/orgs/opencode/copilot/metrics/reports/organization-1-day
Hint: Verify the identifier or filter values you passed; the upstream resource was not found.

trial 2·35242ms·rows 0isError=true

Error

Error: Source resource was not found (404)
Detail: {"message":"Not Found","documentation_url":"https://docs.github.com/rest/copilot/copilot-usage-metrics#get-copilot-organization-usage-metrics-for-a-specific-day","status":"404"} [GET] https://api.github.com/orgs/opencode/copilot/metrics/reports/organization-1-day
Hint: Verify the identifier or filter values you passed; the upstream resource was not found.

edge2 trials

min 33059ms · median 35948ms · max 38838ms · rows 0,0

edge: larger limit

Command

SELECT * FROM github.organization_1_day WHERE org = 'opencode' AND day = '1' LIMIT 200

Trials + output

trial 1·33059ms·rows 0isError=true

Error

Error: Source resource was not found (404)
Detail: {"message":"Not Found","documentation_url":"https://docs.github.com/rest/copilot/copilot-usage-metrics#get-copilot-organization-usage-metrics-for-a-specific-day","status":"404"} [GET] https://api.github.com/orgs/opencode/copilot/metrics/reports/organization-1-day
Hint: Verify the identifier or filter values you passed; the upstream resource was not found.

trial 2·38838ms·rows 0isError=true

Error

Error: Source resource was not found (404)
Detail: {"message":"Not Found","documentation_url":"https://docs.github.com/rest/copilot/copilot-usage-metrics#get-copilot-organization-usage-metrics-for-a-specific-day","status":"404"} [GET] https://api.github.com/orgs/opencode/copilot/metrics/reports/organization-1-day
Hint: Verify the identifier or filter values you passed; the upstream resource was not found.

All returned rowsacross all non-errored trials · filterable · paginated

0 rows stored · 0 returned · page 1/1

No rows captured. Trials either returned isError=true (errors shown above) or the probe runner didn't capture full output rows.

Trial comparison

Variant / combo	Trial #	Latency	Status	First key returned
minimal	t1	40390ms	error	—
minimal	t2	43458ms	error	—
realistic	t1	38135ms	error	—
realistic	t2	35242ms	error	—
edge	t1	33059ms	error	—
edge	t2	38838ms	error	—

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T07:23:58Z

JSON record: reports/github/tables/organization_1_day.json

first_run_at: 2026-08-31T07:23:58Z

last_retried_at: 2026-08-31T07:23:58Z

retry_count: 0

View version history →