# Monitoring & Diagnostic Views

## VW\_INTEGRATION\_PROCESS

Integration process tracking and status.

**Contents:** Integration process date, feature type, integration type, user name, attribute count, file path

**Use cases:** Integration monitoring, process tracking

## VW\_ACCESS\_CONTROL\_USER\_PRIVILEGES

User access control and privilege information.

**Contents:** User privilege information, access control settings, entity names, privilege names, grant status, timestamps

**Note:** Available to `app_admin` role only.

**Use cases:** Access control management, security auditing

***

## Common Query Patterns

**Monitoring active scans:**

```sql
SELECT datasource_name, configuration_name, scan_status, percentage_complete,
       estimated_records_remaining, process_time_remaining_in_minutes
FROM core.vw_datasource_scans_in_process
ORDER BY scan_datetime_begin DESC;
```

**Reviewing scan history:**

```sql
SELECT datasource_name, configuration_name, scan_datetime_begin, scan_duration_minutes,
       records_processed, records_processed_per_minute, scan_status
FROM core.vw_datasource_scans
WHERE datasource_id = 'your-datasource-id'
ORDER BY scan_datetime_begin DESC LIMIT 10;
```

**Monitoring schema drift:**

```sql
SELECT version_number, attribute_path, polymorphic_attribute_name, version_status, version_status_date
FROM core.vw_datasource_version_all_attributes
WHERE datasource_id = 'your-datasource-id' AND version_status_date >= CURRENT_DATE - 7
ORDER BY version_number DESC, version_status_date DESC;
```

**Reviewing security configuration:**

```sql
SELECT attribute_path, polymorphic_attribute_name, include_column_in_row_access_policy,
       column_masking_policy_name, view_name
FROM core.vw_datasource_attribute_security
WHERE datasource_id = 'your-datasource-id'
  AND (include_column_in_row_access_policy = TRUE OR column_masking_policy_name IS NOT NULL);
```