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

InsightVM
,
1

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.

2

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.

3

@holly_wilsey Can you please help with container report from insightVM