Certified Nodes usage telemetry

[hardillb]

part of https://github.com/FlowFuse/customer/issues/392

Description

Gethers certified nodes count every 24hrs

~~Dual implementation, telemetry and~~ a standalone housekeeping task

~~need to pick one before merging~~

Related Issue(s)

https://github.com/FlowFuse/customer/issues/392

Checklist

• [x] I have read the contribution guidelines
• [ ] Suitable unit/system level tests have been added and they pass
• [ ] Documentation has been updated
  • [ ] Upgrade instructions
  • [ ] Configuration details
  • [ ] Concepts
• [ ] Changes flowforge.yml?
  • [ ] Issue/PR raised on FlowFuse/helm to update ConfigMap Template
  • [ ] Issue/PR raised on FlowFuse/CloudProject to update values for Staging/Production
• [ ] Link to Changelog Entry PR, or note why one is not needed.

Labels

• [ ] Includes a DB migration? -> add the area:migration label

[codecov[bot]]

Codecov Report

:x: Patch coverage is 20.00000% with 44 lines in your changes missing coverage. Please review. :white_check_mark: Project coverage is 76.64%. Comparing base (3409cf0) to head (d1a20ef). :warning: Report is 338 commits behind head on main.

Files with missing lines	Patch %	Lines
forge/housekeeper/tasks/certifiedNodes.js	18.51%	44 Missing :warning:

Additional details and impacted files

@@            Coverage Diff             @@
##             main    #6017      +/-   ##
==========================================
- Coverage   76.79%   76.64%   -0.16%     
==========================================
  Files         384      387       +3     
  Lines       19439    19557     +118     
  Branches     4671     4703      +32     
==========================================
+ Hits        14928    14989      +61     
- Misses       4511     4568      +57     

Flag	Coverage Δ
backend	76.64% <20.00%> (-0.16%)	:arrow_down:

Flags with carried forward coverage won't be shown. Click here to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

:rocket: New features to boost your workflow:

• :snowflake: Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
• :package: JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

[hardillb]

The consumer for this is all up and running now

Only outstanding question is should the scopes and upload URL be configurable?

[hardillb]

@knolleary if you get a second

[hardillb]

@knolleary this now runs the queries in batches of 20 every second until complete to reduce load on db, we can tune the time period if 20/s is still too fast