10MAINTAINING THE DATABASE

Image

Your database now contains information about hosts and vulnerabilities that you parsed out of Nmap and OpenVAS scan results. To generate meaningful reports, you need to start with a quality database that contains accurate, consistent, and recent information about your environment. Being able to generate those reports quickly is also beneficial. The examples in this chapter show you how to improve your database. You’ll add indexes to speed query performance and maintain data integrity by restricting the values that you can place in the index. In addition, you’ll automatically remove stale data so your reports are based ...

Get Practical Vulnerability Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.