132 Sentinel 6.1 Reference Guidenovdocx (en) 7 January 20108.1.10 ADV_NXS_KB_PATCH_VThis view contains information about the patches that are required to remove the vulnerabilities.ATTACK_SCENARIO text Description of how a vulnerability can beexploited.SOLUTION_DESCRIPTION text Description of the solution that is used to fix thevulnerability.FULL_DESCRIPTION text The complete description of the vulnerability.LOCATION_PHYSICAL bit This value is 1 if the vulnerability can be exploitedwith only physical system access.LOCATION_LOCAL bit This value is 1 if the vulnerability can be exploitedon a local system.LOCATION_REMOTE bit This value is 1 if the vulnerabilitycan be exploitedon a remote system.LOCATION_DIALUP bit This value is 1 if the vulnerability can be exploitedusing a dial-up connection.LOCATION_UNKNOWN bit This value is 1 if the vulnerability is exploited inan unknown location.PUBLISHED datetime Time stamp indicating when the vulnerability waspublished in the OSVDB.INSERTED datetime Time stamp indicating when the vulnerability wasinserted in the vendor database.UPDATED datetime Time stamp indicating when the vulnerability wasupdated in the vendor database.DATE_CREATED datetime Time stamp indicating when the vulnerabilityinformation was entered in the Sentinel database.DATE_MODIFIED datetime Time stamp indicating when the vulnerabilityinformation was modified in the Sentineldatabase.CREATED_BY int The ID of the user who entered the vulnerabilityinformation in the Sentinel database.MODIFIED_BY int The ID of the user who modified the vulnerabilityinformation in the Sentinel database.Column Name Datatype CommentID int The unique ID for the row.OSVDB_ID int The ID of the vulnerability in the OSVDB.TYPE_NAME varchar (128) The type of the patch used to remove the vulnerability.TYPE_ID int The unique ID of the patch.Column Name Datatype Comment
