Turn "Reopened" field into a date/time field

MaxBeauch
Tera Contributor

Hey community,

In the vulnerability items table there is a field called "Reopened" which is by default a True/False field.
I have a ask to make that field show a date when the Vulnerability reopened. Is there a way to achieve this?

Thanks in advance

 

3 REPLIES 3

bammar
Kilo Sage
Kilo Sage

If you cant find it out of box - for instance - Reopened field on incident table is a date field, - But if you cant find the field dedicated to a reopened date out of box- you would create a date field and it would have a business rule that says when reopened changes to true- put the current updated time into the Reopened date custom field. 

MaxBeauch
Tera Contributor

From my understanding, the field in Qualys is a Date/Time field but on ServiceNow, the field is a Boolean. I would like the Out of the Box field show the date instead of just a "True" value whenever it gets opened/reopened.

Aaron Molenaar
Mega Guru

There is a 'Last opened' field on VIT that contains the date for the last time the VIT was (re-)opened. This field is also used in other dialogs like setting Remediation Targets on VIT, so I would strongly consider using this field in your efforts.

 

Hope that helps!