SQL Query to retrieve Installed Software, Ports, etc. from assets

We are running Nexpose on prem. I’ve been asked to generate one or four separate CSV or XML reports containing each asset’s

  • Installed Software
  • Services
  • Port Information
  • Containers

I don’t see a report to fetch this automatically, so I assume we would want an SQL query to fetch these. Does anyone by chance have a query/queries to do this? Thanks.

Services/Port Information: SQL example - view open ports | Nexpose Documentation
Installed Software: SQL example - asset details | Nexpose Documentation

Not positive on containers, but the above two examples will give you a good start.

@holly_wilsey Can you please help with container report from insightVM