I had already given them the usage overview screenshot for the numbers, but they wanted a bit more detail.
I have tried to run the insight report as well, with raw data on onboard certificates. I go one year back in time, since this is the validity period for the certificates.
Fitlering on the revoked date colomn should in theory give me the same number of certficiates as valdi + not enrolled clients in the usage tab.
It's not even close.
I am 350 certificates short from the insight report compared to the usage tab from mamangement and control in onboarding module.
And the usage tab report only 28 certificates expired on time.
The numbers from usage don't add up either.
1695 License usage
Total enrolled 1704, not enrolled 77
Onboard CA, 1914 valid certificates, 28 expired. 0 Revoked.
From the insight onboard certificate report (one year back), I get 1357 certificates without a revoked date.
To me this is more confusing than usefull. Am I missing something here?