Re: [Ejbca-develop] What is the meaning of the status integers in the certificateData table in the DB?

[Ralf H. <rh...@hc...>]

Hi,

try this:

SELECT serialNumber, subjectDN, FROM_UNIXTIME(revocationDate/1000) as revoked from CertificateData where revocationDate != '-1'

regards

Von: Ivan R [mailto:iva...@gm...] 
Gesendet: Donnerstag, 2. Juni 2016 10:46
An: ejb...@li...
Betreff: Re: [Ejbca-develop] What is the meaning of the status integers in the certificateData table in the DB?

Hi,
Thanks for the reply. Do you also happen to know the logic behind how the date is transformed into the integer? For example "1464853664953" this is supposed to be the date today and time should be from some time this morning. 

On Wed, Jun 1, 2016 at 8:21 PM, Ralf Hornik <rh...@hc...> wrote:
Hi,
 
There is a column „revocation_date“ that is -1 if not revoked and a timestamp if is
Cheers
 
Von: Ivan R [mailto:iva...@gm...] 
Gesendet: Mittwoch, 1. Juni 2016 17:05
An: ejb...@li...
Betreff: [Ejbca-develop] What is the meaning of the status integers in the certificateData table in the DB?
 
I'm looking for a way to detect if a certificate was revoked. Ideally if it was revoked recently.Is there anything from which I can read up on the status meanings?
 
Also I intend to delete some certificates when they've been been just made and revoked without ever being used. Is there any underlying risk  when doing that?

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Ejbca-develop mailing list
Ejb...@li...
https://lists.sourceforge.net/lists/listinfo/ejbca-develop