Custom query/report?

InsightVM
1

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
2

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
3

I’m in need of this too for auditing purposes.

So okay, I get that but “how” and “where” do you use this criteria to create an exportable report for all “users and groups” from a particular asset group for each asset within that group?