Skip to content

Instantly share code, notes, and snippets.

@sleevi
Last active July 2, 2020 01:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sleevi/e4d443198e59abca9855045338fd2de3 to your computer and use it in GitHub Desktop.
Save sleevi/e4d443198e59abca9855045338fd2de3 to your computer and use it in GitHub Desktop.
OCSP Delegated Responders without nocheck
certificate_id | ca_id | parent_ca_id | parent_name | validity | revoked
----------------+--------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------
2329203344 | 156182 | 134884 | C=BE, O=GlobalSign nv-sa, CN=GlobalSign Root E46 | 2029-04-10 00:00:00 | f
2220986544 | 153121 | 134883 | C=BE, O=GlobalSign nv-sa, CN=GlobalSign Root R46 | 2029-04-10 00:00:00 | f
2392141070 | 157937 | 36 | C=BE, O=GlobalSign nv-sa, OU=Root CA, CN=GlobalSign Root CA | 2028-01-28 00:00:00 | f
1476651569 | 1357 | 36 | C=BE, O=GlobalSign nv-sa, OU=Root CA, CN=GlobalSign Root CA | 2026-04-13 10:00:00 | f
157564305 | 50437 | 36 | C=BE, O=GlobalSign nv-sa, OU=Root CA, CN=GlobalSign Root CA | 2024-03-16 00:00:00 | f
2369947954 | 17859 | 36 | C=BE, O=GlobalSign nv-sa, OU=Root CA, CN=GlobalSign Root CA | 2024-03-16 00:00:00 | f
2369948051 | 18172 | 36 | C=BE, O=GlobalSign nv-sa, OU=Root CA, CN=GlobalSign Root CA | 2024-03-16 00:00:00 | f
2369948436 | 18083 | 36 | C=BE, O=GlobalSign nv-sa, OU=Root CA, CN=GlobalSign Root CA | 2024-03-16 00:00:00 | f
8585944 | 1367 | 1304 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA G2 | 2020-07-09 00:00:00 | t
2839140453 | 170468 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2027-04-25 00:00:00 | f
163676419 | 51044 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2027-02-22 00:00:00 | f
1476651440 | 126327 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2026-05-15 00:00:00 | f
1225556701 | 117754 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2024-02-20 00:00:00 | f
1225556702 | 117755 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2024-02-20 00:00:00 | f
1229139434 | 118001 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2024-02-20 00:00:00 | f
329514052 | 14517 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2023-02-13 00:00:00 | f
306624237 | 14512 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2023-01-17 00:00:00 | f
196919504 | 13080 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2022-08-23 00:00:00 | f
12729527 | 14517 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-09-16 00:00:00 | f
392882654 | 14512 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-09-16 00:00:00 | f
1596016275 | 14517 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-07-31 23:00:00 | f
12729526 | 14517 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-07-09 00:00:00 | f
786990298 | 99547 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2023-09-19 00:00:00 | t
329514048 | 1871 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2023-02-13 00:00:00 | t
215376215 | 14512 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2022-09-20 00:00:00 | t
27823827 | 1871 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2021-07-20 00:00:00 | t
36391364 | 30418 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2021-05-18 00:00:00 | t
10105729 | 4422 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2021-04-03 00:00:00 | t
7890405 | 4422 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-12-13 00:00:00 | t
9881176 | 1871 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-09-16 00:00:00 | t
215376217 | 14512 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-09-16 00:00:00 | t
11501550 | 10312 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-08-19 00:00:00 | t
85774742 | 13080 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-08-19 00:00:00 | t
8527797 | 1871 | 1423 | C=BE, OU=Trusted Root, O=GlobalSign nv-sa, CN=Trusted Root CA SHA256 G2 | 2020-07-09 00:00:00 | t
549505562 | 88333 | 21435 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 1 G3 | 2028-06-21 15:05:27 | f
135970401 | 47808 | 21435 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 1 G3 | 2027-02-06 14:16:24 | f
1470387404 | 44645 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2029-05-11 13:31:14 | f
109952780 | 44645 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2027-03-14 15:21:23 | f
174851777 | 52410 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2023-07-11 14:30:41 | f
151456478 | 49872 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2022-08-05 06:11:34 | f
206114674 | 48577 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2027-09-04 13:35:00 | t
216371873 | 48577 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2027-08-13 16:20:13 | t
180538091 | 50629 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2027-06-12 07:12:50 | t
160014456 | 50629 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2027-05-17 06:04:11 | t
159384842 | 50629 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2027-05-15 15:22:40 | t
28870731 | 26087 | 21424 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 2 G3 | 2022-08-05 06:10:42 | t
311598613 | 69630 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2028-01-17 10:05:05 | f
151456475 | 49871 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2022-08-04 15:45:07 | f
151456470 | 49870 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2022-08-04 15:42:29 | f
151456479 | 49873 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2022-08-04 15:38:27 | f
151456483 | 49875 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2022-08-04 15:35:53 | f
151456481 | 49874 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2022-08-04 15:33:06 | f
648772148 | 49874 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2022-08-04 15:33:06 | f
453366210 | 82850 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2028-05-01 19:24:09 | t
415169072 | 80962 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2028-04-17 12:05:08 | t
283394545 | 66321 | 21426 | C=BM, O=QuoVadis Limited, CN=QuoVadis Enterprise Trust CA 3 G3 | 2027-12-17 16:02:07 | t
766740088 | 98706 | 5689 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 1 G3 | 2028-09-15 18:35:38 | f
331017934 | 73467 | 5689 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 1 G3 | 2028-02-11 13:51:07 | f
125032792 | 46370 | 5689 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 1 G3 | 2027-04-19 15:03:36 | f
1596016279 | 130161 | 5689 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 1 G3 | 2024-06-16 16:04:12 | f
736697493 | 97618 | 181 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 | 2028-09-04 18:25:52 | f
736697429 | 97619 | 181 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 | 2028-09-04 18:21:39 | f
8300804 | 5102 | 181 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 | 2025-06-01 12:47:38 | f
6195315 | 1700 | 181 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 | 2025-01-13 16:42:15 | f
6276321 | 1707 | 181 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 | 2025-01-13 15:59:08 | f
15159402 | 15999 | 181 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 | 2026-01-12 14:53:05 | t
15895471 | 16596 | 181 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 | 2026-01-12 14:49:28 | t
98403793 | 42790 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2026-11-30 16:21:01 | f
125032793 | 22507 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2025-04-19 18:27:31 | f
125032795 | 18465 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2025-04-19 18:20:31 | f
23432430 | 22507 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2024-04-29 22:45:18 | t
19415522 | 18465 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2024-04-29 22:38:11 | t
528010132 | 85898 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2023-05-23 15:20:36 | t
580872540 | 85898 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2023-05-23 15:20:11 | t
507425109 | 85898 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2023-05-23 15:19:38 | t
279527706 | 64785 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2022-11-30 14:00:39 | t
278828716 | 64785 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2022-11-30 13:59:54 | t
271418958 | 64785 | 1682 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 2 G3 | 2022-11-30 13:58:41 | t
125032791 | 46369 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2027-04-19 15:16:07 | f
405618315 | 80521 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2030-12-11 13:39:03 | t
71200411 | 38622 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2026-12-02 14:22:45 | t
87718153 | 38622 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2026-12-02 14:21:52 | t
73136199 | 38622 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2026-12-02 14:20:53 | t
154664777 | 50173 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2026-11-30 16:01:42 | t
24491545 | 23154 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2026-06-06 15:15:41 | t
72490942 | 23154 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2026-06-06 14:15:41 | t
147601126 | 23154 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2026-06-06 14:15:41 | t
10700546 | 9220 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2025-11-09 15:35:26 | t
405618302 | 80514 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2025-08-28 14:05:18 | t
154664776 | 50172 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2025-06-25 14:31:13 | t
7714552 | 4122 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2025-05-12 13:20:00 | t
135970405 | 47809 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2024-12-29 14:07:20 | t
5674244 | 1651 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2024-11-17 15:33:00 | t
12728749 | 14061 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2024-11-12 17:56:07 | t
12728748 | 14060 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2024-05-07 13:12:03 | t
4192485 | 1508 | 257 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 | 2024-05-06 20:37:48 | t
125032794 | 46371 | 5746 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 G3 | 2027-04-19 14:48:40 | f
419564511 | 81096 | 5746 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 G3 | 2025-04-19 18:38:50 | f
519290490 | 82951 | 5746 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 G3 | 2028-06-02 13:54:38 | t
455264148 | 82951 | 5746 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 G3 | 2028-05-07 13:21:40 | t
417999816 | 81096 | 5746 | C=BM, O=QuoVadis Limited, CN=QuoVadis Root CA 3 G3 | 2024-04-29 22:53:00 | t
125032790 | 46368 | 288 | C=BM, O=QuoVadis Limited, OU=Root Certification Authority, CN=QuoVadis Root Certification Authority | 2021-03-17 18:33:33 | f
3525432 | 1456 | 579 | C=CH, O=WISeKey, OU=Copyright (c) 2005 WISeKey SA, OU=International, CN=WISeKey CertifyID Advanced G1 CA | 2020-12-11 18:00:47 | t
12625546 | 12645 | 579 | C=CH, O=WISeKey, OU=Copyright (c) 2005 WISeKey SA, OU=International, CN=WISeKey CertifyID Advanced G1 CA | 2020-12-11 18:00:47 | t
36391354 | 1456 | 579 | C=CH, O=WISeKey, OU=Copyright (c) 2005 WISeKey SA, OU=International, CN=WISeKey CertifyID Advanced G1 CA | 2020-12-11 18:00:47 | t
36391363 | 1456 | 579 | C=CH, O=WISeKey, OU=Copyright (c) 2005 WISeKey SA, OU=International, CN=WISeKey CertifyID Advanced G1 CA | 2020-12-11 18:00:47 | t
1435074103 | 124836 | 14559 | C=CH, O=WISeKey, OU=OISTE Foundation Endorsed, CN=OISTE WISeKey Global Root GB CA | 2039-12-01 15:10:31 | f
1490728458 | 126740 | 14559 | C=CH, O=WISeKey, OU=OISTE Foundation Endorsed, CN=OISTE WISeKey Global Root GB CA | 2039-12-01 15:10:31 | f
1490728539 | 126738 | 14559 | C=CH, O=WISeKey, OU=OISTE Foundation Endorsed, CN=OISTE WISeKey Global Root GB CA | 2039-12-01 15:10:31 | f
1303235837 | 120492 | 6068 | C=DE, O=T-Systems Enterprise Services GmbH, OU=T-Systems Trust Center, CN=T-TeleSec GlobalRoot Class 2 | 2033-10-01 23:59:59 | f
2517734973 | 161238 | 6068 | C=DE, O=T-Systems Enterprise Services GmbH, OU=T-Systems Trust Center, CN=T-TeleSec GlobalRoot Class 2 | 2030-02-25 23:59:59 | f
40463077 | 12273 | 6068 | C=DE, O=T-Systems Enterprise Services GmbH, OU=T-Systems Trust Center, CN=T-TeleSec GlobalRoot Class 2 | 2026-07-13 23:59:59 | f
862503 | 995 | 995 | C=EE, O=AS Sertifitseerimiskeskus, CN=EE Certification Centre Root CA, emailAddress=pki@sk.ee | 2030-12-17 23:59:59 | f
12624839 | 12278 | 995 | C=EE, O=AS Sertifitseerimiskeskus, CN=EE Certification Centre Root CA, emailAddress=pki@sk.ee | 2030-12-17 23:59:59 | f
78288258 | 39962 | 995 | C=EE, O=AS Sertifitseerimiskeskus, CN=EE Certification Centre Root CA, emailAddress=pki@sk.ee | 2030-12-17 23:59:59 | f
163641648 | 51042 | 995 | C=EE, O=AS Sertifitseerimiskeskus, CN=EE Certification Centre Root CA, emailAddress=pki@sk.ee | 2030-12-17 23:59:59 | f
164243751 | 6528 | 995 | C=EE, O=AS Sertifitseerimiskeskus, CN=EE Certification Centre Root CA, emailAddress=pki@sk.ee | 2024-03-18 10:14:59 | t
164243750 | 6533 | 995 | C=EE, O=AS Sertifitseerimiskeskus, CN=EE Certification Centre Root CA, emailAddress=pki@sk.ee | 2024-03-18 10:11:11 | t
10601239 | 994 | 430 | C=ES, CN=Autoridad de Certificacion Firmaprofesional CIF A62634068 | 2030-12-31 04:02:55 | f
240192053 | 13034 | 430 | C=ES, CN=Autoridad de Certificacion Firmaprofesional CIF A62634068 | 2030-12-31 04:02:55 | f
536779027 | 13291 | 430 | C=ES, CN=Autoridad de Certificacion Firmaprofesional CIF A62634068 | 2030-12-31 04:02:55 | f
536779028 | 34352 | 430 | C=ES, CN=Autoridad de Certificacion Firmaprofesional CIF A62634068 | 2030-12-31 04:02:55 | f
408789249 | 24298 | 430 | C=ES, CN=Autoridad de Certificacion Firmaprofesional CIF A62634068 | 2030-12-31 04:02:55 | t
495029017 | 34352 | 430 | C=ES, CN=Autoridad de Certificacion Firmaprofesional CIF A62634068 | 2030-12-31 04:02:55 | t
495029018 | 13291 | 430 | C=ES, CN=Autoridad de Certificacion Firmaprofesional CIF A62634068 | 2030-12-31 04:02:55 | t
12729554 | 14525 | 1115 | C=ES, O=AC Camerfirma S.A., serialNumber=A82743287, L=Madrid (see current address at https://www.camerfirma.com/address), CN=AC Camerfirma - 2009 | 2024-11-21 11:07:55 | f
49167479 | 33784 | 1114 | C=EU, L=Madrid (see current address at www.camerfirma.com/address), serialNumber=A82743287, O=AC Camerfirma S.A., CN=Global Chambersign Root - 2008 | 2033-07-13 07:39:14 | t
1265291634 | 119276 | 14546 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions ECC RootCA 2015 | 2027-03-04 10:46:33 | t
2858289782 | 171146 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-05-18 07:29:31 | f
2657659465 | 164802 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 11:15:25 | f
2657657558 | 164777 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 11:10:25 | f
2657659681 | 164809 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 11:05:32 | f
2657659170 | 164786 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:57:37 | f
2657662544 | 164811 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:51:09 | f
2657659290 | 164792 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:46:37 | f
2657658676 | 164781 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:41:33 | f
2657659304 | 164791 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:35:25 | f
2657658699 | 164780 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:30:20 | f
2657659294 | 164793 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:20:26 | f
2657659626 | 164808 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:13:10 | f
2657659279 | 164788 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 10:05:27 | f
2657659376 | 164796 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 09:59:16 | f
2657659332 | 164797 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 09:46:26 | f
2657662689 | 164813 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 09:40:02 | f
2657659434 | 164804 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-03-22 09:32:32 | f
2838197804 | 170418 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 13:04:09 | f
2838197796 | 170410 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:59:58 | f
2838197805 | 170419 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:56:57 | f
2838197794 | 170408 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:53:33 | f
2838197806 | 170420 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:47:13 | f
2838197795 | 170409 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:42:31 | f
2838197797 | 170411 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:38:53 | f
2838197799 | 170413 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:30:23 | f
2838197798 | 170412 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:21:31 | f
2838197801 | 170415 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:12:55 | f
2838197802 | 170416 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2028-01-19 12:03:13 | f
2097908041 | 148611 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2027-11-05 10:01:13 | f
1903248090 | 140496 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2027-03-12 13:38:55 | f
1222759679 | 117663 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2027-02-18 10:32:48 | f
1222760114 | 117669 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2027-02-18 10:18:26 | f
1222761078 | 117671 | 14566 | C=GR, L=Athens, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2015 | 2027-02-18 10:02:52 | f
900785759 | 104389 | 1307 | C=GR, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2011 | 2026-05-21 07:53:30 | f
909718586 | 104809 | 1307 | C=GR, O=Hellenic Academic and Research Institutions Cert. Authority, CN=Hellenic Academic and Research Institutions RootCA 2011 | 2026-05-21 07:56:44 | t
2411246057 | 68938 | 778 | C=HU, L=Budapest, O=Microsec Ltd., CN=Microsec e-Szigno Root CA 2009, emailAddress=info@e-szigno.hu | 2029-09-29 16:00:00 | f
2411247733 | 68938 | 113775 | C=HU, L=Budapest, O=Microsec Ltd., organizationIdentifier=VATHU-23584497, CN=e-Szigno Root CA 2017 | 2042-08-22 09:00:00 | f
21606058 | 21427 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-05-20 12:53:03 | f
21606070 | 21437 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-05-20 12:52:38 | f
21606056 | 21425 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-05-20 12:51:57 | f
21606064 | 21431 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-05-20 12:51:28 | f
135970330 | 47803 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2023-10-25 12:52:27 | f
155179795 | 50228 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2023-09-07 12:43:06 | f
12620974 | 300 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-09-10 18:52:08 | t
91478107 | 300 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-04-16 21:13:22 | t
12625621 | 300 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-04-16 21:10:56 | t
91478106 | 300 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-04-16 20:14:20 | t
91478105 | 300 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-04-16 20:10:55 | t
12620985 | 300 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-04-16 20:05:44 | t
124297161 | 284 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2024-01-24 12:54:15 | t
78290245 | 39968 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2023-11-15 12:01:48 | t
2382695512 | 39968 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2023-09-07 12:43:50 | t
881434380 | 103423 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2023-08-23 12:44:30 | t
7739892 | 1952 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2022-05-21 18:52:20 | t
35335507 | 1952 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2022-05-21 18:46:26 | t
6976985 | 1985 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2022-03-18 17:41:10 | t
881434274 | 1985 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2022-03-18 17:36:30 | t
6906659 | 1952 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2022-03-03 18:31:04 | t
1566589408 | 1952 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2022-03-03 18:28:17 | t
12729022 | 14197 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2021-02-12 19:09:54 | t
881434272 | 14197 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2021-02-12 19:04:44 | t
3528065 | 1458 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2021-02-12 19:01:08 | t
3321681 | 1437 | 8 | C=IE, O=Baltimore, OU=CyberTrust, CN=Baltimore CyberTrust Root | 2020-12-19 20:15:45 | t
1298407195 | 119818 | 935 | C=IT, L=Milan, O=Actalis S.p.A./03358520967, CN=Actalis Authentication Root CA | 2030-09-22 11:22:02 | f
1298407200 | 120278 | 935 | C=IT, L=Milan, O=Actalis S.p.A./03358520967, CN=Actalis Authentication Root CA | 2030-09-22 11:22:02 | f
1305420938 | 120552 | 935 | C=IT, L=Milan, O=Actalis S.p.A./03358520967, CN=Actalis Authentication Root CA | 2030-09-22 11:22:02 | f
2029983391 | 146057 | 935 | C=IT, L=Milan, O=Actalis S.p.A./03358520967, CN=Actalis Authentication Root CA | 2030-09-22 11:22:02 | f
1671982905 | 132949 | 1160 | C=JP, O="SECOM Trust Systems CO.,LTD.", OU=Security Communication RootCA2 | 2029-05-29 05:00:39 | f
1671982906 | 132948 | 1160 | C=JP, O="SECOM Trust Systems CO.,LTD.", OU=Security Communication RootCA2 | 2029-05-29 05:00:39 | f
2517735005 | 161243 | 1160 | C=JP, O="SECOM Trust Systems CO.,LTD.", OU=Security Communication RootCA2 | 2029-05-29 05:00:39 | f
2595911605 | 163072 | 941 | CN=Atos TrustedRoot 2011, O=Atos, C=DE | 2030-03-15 11:02:49 | f
2411246003 | 158410 | 941 | CN=Atos TrustedRoot 2011, O=Atos, C=DE | 2030-01-28 11:20:20 | f
2070270509 | 147555 | 941 | CN=Atos TrustedRoot 2011, O=Atos, C=DE | 2029-10-27 14:00:03 | f
1618718808 | 131028 | 941 | CN=Atos TrustedRoot 2011, O=Atos, C=DE | 2029-06-17 11:19:45 | f
1838117644 | 138470 | 18128 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Autonome Apparaten CA - G3 | 2028-11-12 00:00:00 | f
135970406 | 47810 | 18131 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Burger CA - G3 | 2028-11-12 00:00:00 | f
318398866 | 71637 | 18131 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Burger CA - G3 | 2028-11-12 00:00:00 | f
1412330500 | 71637 | 18131 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Burger CA - G3 | 2028-11-12 00:00:00 | f
1412330508 | 84077 | 18131 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Burger CA - G3 | 2028-11-12 00:00:00 | f
363419311 | 77580 | 18131 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Burger CA - G3 | 2028-11-12 00:00:00 | t
475894537 | 84077 | 18131 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Burger CA - G3 | 2028-11-12 00:00:00 | t
7846179 | 4342 | 1685 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden EV Intermediair CA | 2022-12-05 23:59:59 | f
10646767 | 9117 | 1685 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden EV Intermediair CA | 2022-12-05 23:59:59 | f
15971988 | 16657 | 1685 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden EV Intermediair CA | 2022-12-05 23:59:59 | f
7801964 | 4264 | 1685 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden EV Intermediair CA | 2022-12-05 23:59:59 | t
135970399 | 47807 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
147613373 | 49384 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
164244352 | 51125 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
164244353 | 51126 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
1412330520 | 51125 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
1412330543 | 84076 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
1412330611 | 51126 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
1652799589 | 132287 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
1835407965 | 119270 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | f
19623446 | 18753 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-11 23:00:00 | f
19622894 | 18751 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | t
363419313 | 77582 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | t
475894533 | 84076 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | t
1265291511 | 119270 | 18145 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Persoon CA - G3 | 2028-11-12 00:00:00 | t
54959165 | 36560 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
63094369 | 37677 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
130068222 | 46859 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
130486221 | 46926 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
164244355 | 51128 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
475894529 | 84075 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
1412329219 | 51128 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
1412330519 | 37677 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
1412330560 | 36560 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
1412330569 | 84075 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
1838117716 | 119274 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | f
18068237 | 18175 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | t
19623445 | 18752 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | t
73706454 | 39214 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | t
363419312 | 77581 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | t
363419317 | 77584 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | t
475894540 | 84078 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | t
1265291620 | 119274 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-12 00:00:00 | t
18068225 | 18166 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-11 23:00:00 | t
19623447 | 18754 | 5963 | C=NL, O=Staat der Nederlanden, CN=Staat der Nederlanden Organisatie Services CA - G3 | 2028-11-11 23:00:00 | t
155179794 | 50227 | 5699 | C=US, O=DigiCert Inc, OU=www.digicert.com, CN=DigiCert Global Root G3 | 2023-09-07 12:16:10 | f
2839140405 | 170467 | 5749 | OU=GlobalSign ECC Root CA - R5, O=GlobalSign, CN=GlobalSign | 2035-05-20 00:00:00 | f
970083107 | 107693 | 5749 | OU=GlobalSign ECC Root CA - R5, O=GlobalSign, CN=GlobalSign | 2028-11-21 00:00:00 | f
405618313 | 80520 | 5749 | OU=GlobalSign ECC Root CA - R5, O=GlobalSign, CN=GlobalSign | 2028-04-18 00:00:00 | f
1490728430 | 126736 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
1814823951 | 137703 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
2369947889 | 157337 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
2369948041 | 12857 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
2369948075 | 157336 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
2369948428 | 157342 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
2369948433 | 157341 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
2369948437 | 157339 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2029-03-18 00:00:00 | f
970082980 | 107688 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2028-11-21 00:00:00 | f
970083106 | 107692 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2028-11-21 00:00:00 | f
1703475054 | 6624 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2028-08-02 10:00:00 | f
1703475088 | 14124 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2028-08-02 10:00:00 | f
549505576 | 88335 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2028-06-20 00:00:00 | f
2839140428 | 170469 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2028-05-20 00:00:00 | f
1490728500 | 126739 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2028-05-15 00:00:00 | f
2369948432 | 157340 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2026-01-22 00:00:00 | f
24592899 | 23213 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2024-06-15 00:00:00 | f
26749929 | 25081 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2024-06-15 00:00:00 | f
41285443 | 30969 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2024-06-15 00:00:00 | f
147619379 | 49386 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2024-06-15 00:00:00 | f
163079175 | 51022 | 874 | OU=GlobalSign Root CA - R3, O=GlobalSign, CN=GlobalSign | 2024-06-15 00:00:00 | f
1490728721 | 126748 | 18459 | OU=GlobalSign Root CA - R6, O=GlobalSign, CN=GlobalSign | 2034-12-10 00:00:00 | f
1476654013 | 126328 | 18459 | OU=GlobalSign Root CA - R6, O=GlobalSign, CN=GlobalSign | 2029-05-15 00:00:00 | f
1436918881 | 124922 | 18459 | OU=GlobalSign Root CA - R6, O=GlobalSign, CN=GlobalSign | 2029-04-30 00:00:00 | f
405618295 | 80510 | 18459 | OU=GlobalSign Root CA - R6, O=GlobalSign, CN=GlobalSign | 2028-04-18 00:00:00 | f
164243753 | 51121 | 18459 | OU=GlobalSign Root CA - R6, O=GlobalSign, CN=GlobalSign | 2021-09-21 00:00:00 | f
(277 rows)
SELECT DISTINCT
-- The certificate with the problem
c.ID as certificate_id,
-- The CA that operates the problem certificate
ca_c.CA_ID as ca_id,
-- The CA that issued the certificate
c.ISSUER_CA_ID as parent_ca_id,
-- The name of the CA that issued the certificate
ca.NAME as parent_name,
-- The validity period
coalesce(x509_notAfter(c.CERTIFICATE), 'infinity'::timestamp) AS validity,
-- Whether the certificate wsa already revoked
EXISTS(
SELECT 1
FROM crl_revoked AS crl_r
WHERE
crl_r.CA_ID = c.ISSUER_CA_ID
AND crl_r.SERIAL_NUMBER = x509_serialNumber(c.CERTIFICATE)
) as revoked
FROM
ca_certificate AS ca_c
INNER JOIN certificate AS c ON
c.ID = ca_c.CERTIFICATE_ID
INNER JOIN ca_trust_purpose AS ca_t_p
ON ca_t_p.CA_ID = c.ISSUER_CA_ID
INNER JOIN ca ON
c.ISSUER_CA_ID = ca.ID
WHERE
-- Trusted by Mozilla
ca_t_p.TRUST_CONTEXT_ID = 5
AND ca_t_p.TRUST_PURPOSE_ID = 1
AND NOT ca_t_p.ALL_CHAINS_REVOKED_VIA_ONECRL
-- Unexpired
AND coalesce(x509_notAfter(c.CERTIFICATE), 'infinity'::timestamp) > NOW()
-- That have an OCSP EKU
AND EXISTS(
SELECT 1
FROM x509_extkeyusages(c.CERTIFICATE)
WHERE
x509_extkeyusages = '1.3.6.1.5.5.7.3.9' -- OCSP Signing
)
-- Without pkix-nocheck
AND NOT EXISTS(
SELECT 1
FROM x509_extensions(c.CERTIFICATE)
WHERE
x509_extensions = '1.3.6.1.5.5.7.48.1.5'
)
ORDER BY
parent_name ASC, parent_ca_id ASC, revoked ASC, validity DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment