Christophe Jauffret
07/20/2026, 6:02 PMSheen Santos Capadngan
07/20/2026, 6:13 PMChristophe Jauffret
07/20/2026, 8:23 PMChristophe Jauffret
07/20/2026, 8:24 PMSheen Santos Capadngan
07/20/2026, 8:31 PMChristophe Jauffret
07/20/2026, 9:07 PMChristophe Jauffret
07/20/2026, 9:10 PMChristophe Jauffret
07/21/2026, 3:23 PMChristophe Jauffret
07/21/2026, 3:23 PMSaif Rahman
07/22/2026, 8:04 AMChristophe Jauffret
07/22/2026, 8:04 AMChristophe Jauffret
07/22/2026, 8:05 AMSaif Rahman
07/22/2026, 8:06 AMChristophe Jauffret
07/22/2026, 8:06 AMSaif Rahman
07/22/2026, 8:06 AMChristophe Jauffret
07/22/2026, 8:08 AMChristophe Jauffret
07/22/2026, 8:08 AMChristophe Jauffret
07/22/2026, 8:08 AMSaif Rahman
07/22/2026, 8:08 AMChristophe Jauffret
07/22/2026, 8:08 AMChristophe Jauffret
07/22/2026, 8:09 AMSaif Rahman
07/22/2026, 8:10 AMChristophe Jauffret
07/22/2026, 8:10 AMSaif Rahman
07/22/2026, 11:18 AMSELECT
c."commonName",
p."enrollmentType" AS profile_label,
cr."enrollmentType" AS issued_via,
cs."certId" IS NOT NULL AS has_key
FROM certificates c
JOIN pki_certificate_profiles p ON p.id = c."profileId"
LEFT JOIN LATERAL (
SELECT "enrollmentType" FROM certificate_requests
WHERE "certificateId" = c.id ORDER BY "createdAt" ASC LIMIT 1
) cr ON true
LEFT JOIN certificate_secrets cs ON cs."certId" = c.id
WHERE p.slug = 'public-cloudnative-nvdlab';Saif Rahman
07/22/2026, 11:18 AMChristophe Jauffret
07/22/2026, 12:26 PMcommonName | profile_label | issued_via | has_key
-------------------------------------------------+---------------+------------+---------
<http://nai.qa-1.gpu-farm.cloudnative.nvdlab.net|nai.qa-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
| acme | acme | f
| acme | acme | f
| acme | acme | f
| acme | acme | f
<http://nai.dev-1.gpu-farm.cloudnative.nvdlab.net|nai.dev-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
| acme | acme | f
<http://nai.nai-gateway.gpu-farm.cloudnative.nvdlab.net|nai.nai-gateway.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
<http://nkp-mgmt.nai-nvd.cloudnative.nvdlab.net|nkp-mgmt.nai-nvd.cloudnative.nvdlab.net> | acme | acme | f
<http://nai.nai-gateway.nai-nvd.cloudnative.nvdlab.net|nai.nai-gateway.nai-nvd.cloudnative.nvdlab.net> | acme | acme | f
<http://nai.nai-prod.nai-nvd.cloudnative.nvdlab.net|nai.nai-prod.nai-nvd.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
<http://nai.qa-1.gpu-farm.cloudnative.nvdlab.net|nai.qa-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
| acme | acme | f
| acme | acme | f
<http://nai.nai-stage-1.gpu-farm.cloudnative.nvdlab.net|nai.nai-stage-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
<http://nai.qa-1.gpu-farm.cloudnative.nvdlab.net|nai.qa-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
| acme | acme | f
| acme | acme | f
<http://nai.dev-2.gpu-farm.cloudnative.nvdlab.net|nai.dev-2.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
| acme | acme | f
<http://nai.nai-prod-1.gpu-farm.cloudnative.nvdlab.net|nai.nai-prod-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
<http://nai.qa-1.gpu-farm.cloudnative.nvdlab.net|nai.qa-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
| acme | acme | f
<http://nkp-mgmt.nai-nvd.cloudnative.nvdlab.net|nkp-mgmt.nai-nvd.cloudnative.nvdlab.net> | acme | acme | f
<http://nai.qa-1.gpu-farm.cloudnative.nvdlab.net|nai.qa-1.gpu-farm.cloudnative.nvdlab.net> | acme | acme | f
| acme | acme | f
<http://nai.dev-2.gpu-farm.cloudnative.nvdlab.net|nai.dev-2.gpu-farm.cloudnative.nvdlab.net> | acme | api | t
| acme | acme | f
<http://pc.dragon-lab.cloudnative.nvdlab.net|pc.dragon-lab.cloudnative.nvdlab.net> | acme | api | t
<http://pc.romanticism-lab.cloudnative.nvdlab.net|pc.romanticism-lab.cloudnative.nvdlab.net> | acme | api | t
<http://pc.solengcnai-lab.cloudnative.nvdlab.net|pc.solengcnai-lab.cloudnative.nvdlab.net> | acme | api | t
(38 rows)Christophe Jauffret
07/22/2026, 5:41 PMSaif Rahman
07/22/2026, 6:36 PMcommonName | profile_label | issued_via | has_key
---------------------------------------------+---------------+------------+--------
<http://nai.dev-2.gpu-farm.cloudnative.nvdlab.net|nai.dev-2.gpu-farm.cloudnative.nvdlab.net> | acme | api | t
<http://pc.dragon-lab.cloudnative.nvdlab.net|pc.dragon-lab.cloudnative.nvdlab.net> | acme | api | t
<http://pc.romanticism-lab.cloudnative.nvdlab.net|pc.romanticism-lab.cloudnative.nvdlab.net> | acme | api | t
<http://pc.solengcnai-lab.cloudnative.nvdlab.net|pc.solengcnai-lab.cloudnative.nvdlab.net> | acme | api | tSaif Rahman
07/22/2026, 6:37 PMSaif Rahman
07/23/2026, 2:03 AMChristophe Jauffret
07/23/2026, 5:40 AM