Custom query/report?

I am not horribly familiar with how the SQL queries work. If I go to individual assets in my dashboard there is a section where it lists all of the local users and groups on that specific unix asset. What I am looking for is a report that will list those local users and groups based off either an Asset Group or individual assets.

Is this possible? If so, any guidance is appreciated.

Thanks.

1 Like

Hi Matt,

It sounds like the users you are looking for can be found in the ‘dim_asset_user_account’ table (Understanding the reporting data model: Dimensions | InsightVM Documentation)

So a really simplistic query to get them might look like this…

SELECT da.host_name, da.ip_address, daua.name, daua.full_name
FROM dim_asset da
JOIN dim_asset_user_account daua USING (asset_id)

2 Likes