Rapid7 Nexpose Warehouse
  • 21 Mar 2024
  • 2 Minutes to read
  • Dark
  • PDF

Rapid7 Nexpose Warehouse

  • Dark
  • PDF

Article summary

Rapid7 Nexpose Warehouse fetches device information directly from an external data warehouse.

Types of Assets Fetched

This adapter fetches the following types of assets:

  • Devices


  1. PostgreSQL Server (required) - The hostname of the Rapid7 Nexpose PostgreSQL server.
  2. Port (required, default: 5432) - The port used for the connection.
  3. Database (required) - The name of the database.
  4. User Name and Password (required) - The credentials for a user account that has the permissions to fetch assets.
  5. Do not fetch devices with no MAC address and no hostname - Select whether to exclude fetching devices without MAC address and without hostname.
    • If enabled, Axonius will only fetch devices having MAC address or hostname.
    • If disabled, Axonius will fetch devices even if those do not have MAC address and no hostname.

To learn more about common adapter connection parameters and buttons, see Adding a New Adapter Connection.


Advanced Settings


Advanced settings can either apply for all connections for this adapter, or you can set different advanced settings and/or different scheduling for a specific connection, refer to ​Advanced Configuration for Adapters.

  1. Use psycopg2 (optional) - Select whether to use Psycopq 2.
  2. Vulnerabilities severity value include list (optional) - Enter one or more comma-separated vulnerability severity values to include in the fetch.
  3. Parse Rapid7 tags as fields (optional) - Select to parse Rapid7 tags as fields.
  4. Keep large raw fields (optional) - Select to include large raw fields in the fetch.
  5. Exclude devices without IP, hostname and MAC address - Select this option to exclude devices with no MAC address, no hostname and no IP address from the fetch. If the devices have none of these fields it is not fetched.
  6. Exclude devices without last seen and hostname - Select this option to exclude devices in which Last Seen and hostname information is unavailable.
  7. Assets to fetch - By default Axonius fetches data about all asset types. Clear asset types that you don't want to fetch. Devices are always fetched and if no values are selected all assets are fetched.
  8. Fetch Remediation Date when available - Toggle on to fetch the Remediation Date information for each vulnerability belonging to an asset when the date is available.
    • When Fetch Remediation Date when available is selected, the Remediated vulnerabilities comparison date option appears. You can choose a date to limit how many days back the query for Vulnerability Remediation checks.
    • When Fetch Remediation Date when available is selected, the Remediated vulnerabilities comparison days option appears. You can set the number of days in the past to check for remediated dates on vulnerabilities.
  9. Enable complex query fetch - Toggle on this option to enable the adapter to utilize complex queries to fetch data from the database. This reduces overall memory consumption of the adapter.
    1. Only fetch devices seen in the last X number of day(s) - Enter a number of days. This setting enables the system to fetch only devices and corresponding information if they were seen by Rapid7 Nexpose Warehouse in the number of days set. This allows the system to pull a recent history of the devices rather than the entire system history every fetch. This option is only enabled when Enable complex query fetch is enabled.

To learn more about Adapter Configuration tab advanced settings, see Adapter Advanced Settings.


Make sure you perform monthly maintenance and tuning on your On-Premise Rapid7 Postgresql database as explained by Rapid7. This ensures optimzed Axonius fetch performance.

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.