Debugging a totally unrelated issue I noticed that there was at least one puppet certificate still signed on the puppetmaster for a host that have been decommissioned.
I then decided to compare the list of certs with the PuppetDB one and this is the result:
Hosts that don't have a signed certificate on Puppetmaster but they are Active in Netbox and Puppet runs just fine
Those should have a new cert recreated and signed
db1105.eqiad.wmnet ms-be2021.codfw.wmnet mw2320.codfw.wmnet mw2321.codfw.wmnet
Hosts that have a signed certificate on Puppetmaster but were decommissioned
Those should be cleanup without any problem AFAICT
db2051.codfw.wmnet db2057.codfw.wmnet db2063.codfw.wmnet dbstore2001.codfw.wmnet kafka2001.codfw.wmnet kafka2002.codfw.wmnet kafka2003.codfw.wmnet kafka1001.eqiad.wmnet kafka1002.eqiad.wmnet kafka1003.eqiad.wmnet mw1259.eqiad.wmnet mw1260.eqiad.wmnet orespoolcounter1002.eqiad.wmnet restbase-test2003.codfw.wmnet
For reference, a similar effort made in the past: T185239