No stale certificate and all of stale certificate are removed from the database as seen in Aria Operations reports expired certificate for NSX-T integration despite valid endpoint certificates.
VCF Operations Aria Operations 8.18.x
Multiple adapters are collecting the property and posting them under different groups thus the report is using old data.
The issue is related to the representation of the property “Summary | Certificate Expiration Date”, which contains a Unix epoch timestamp in milliseconds.
In the current configuration, the representation type is set to “Timestamp”. This displays the property publish time, not the actual property value. The report period was configured for 7 days, which lead to the report showing a timestamp 7 days prior to the current date/time.
There is currently no direct method to convert the property “Summary | Certificate Expiration Date” from Unix epoch time to a Date/Time format due to the field type.
Workaround: