Dynamic Discovery of AWS RDS databases using boundary host?

[omkensey]

Boundary stores a bunch of info on connections in its own data warehouse. mgaffney has posted a bunch of info in some other threads; see for example:

Boundary event questions

Hi @x980707x, Boundary records most of the data you mentioned in the data warehouse. The only thing not recorded is the remote ip address of the end user. You can query the tables yourself or use a business intelligence tool if you have one available to get the data. Here is a diagram of the data warehouse tables for reference: [boundary-warehouse-erd]

Visibility into End User Sessions for access audit purposes

Hi Bjorn, The tables prefixed with wh_ are the data warehouse tables. There are 4 dimension tables and 2 accumulating fact tables. The wh_session_accumulating_fact table contains one row per session. The wh_session_connection_accumulating_fact table contains one row per connection in each session. Both of the fact tables have foreign key relationships to the 4 dimension tables. The wh_date_dimension contains one row for each day for approximately the next 50 years. The wh_time_of_day_dimension …