Web usage data collection tables and fields

  • Release version: Yokohama
  • Updated March 26, 2026
  • 2 minutes to read

    • Description of the tables and their fields used when gathering web usage data from your Windows and macOS machines.

    Table 1. Data collection tables
    Name Description
    User Web Usage (sn_acc_vis_content_user_web_usage) Stores per-user, per-device, per-domain web usage records, including page visit counts and data measured by each day.
    Application Domain (sn_acc_vis_content_application_domain) Stores domain-level information. Updated with aggregated totals (total page views, total users, daily trends) by the daily aggregation job. Domains not previously configured are automatically created here when collected via full monitoring.
    Application (sn_acc_vis_content_application) Stores service application records that group one or more domains. Each application is linked to a CMDB service and a source.
    Table 2. User web usage table fields
    Name Description
    Domain (domain) The application domain of the visited website.
    Device (device_id) The computer (cmdb_ci_computer) from which the website was accessed.
    User (user) User that accessed the website.
    Last Accessed (last_accessed) Date and time that the website was last accessed.
    Page Visits (page_visits) Number of page visits for the current user-domain-device combination.
    Page Visits Daywise (page_visits_daywise) A JSON object storing page visit counts, broken down by day for the retention period (for example, {"2026-03-15": "12", "2026-03-16": "8"})
    Table 3. Application Domain table fields
    Name Description
    Application (application) Application record that the domain belongs to.
    Domain (domain) Domain name that can be monitored (such as example.com). The display field. Must be unique.
    Category (category) The URL category (sn_acc_vis_content_url_category) for the domain.
    Domain Type (domain_type) Indicates whether the domain is internal or external.

    Default: external
    CMDB endpoint http (endpoint_http) The CMDB HTTP endpoint (cmdb_ci_endpoint_http) for SaaS applications.
    Metric monitoring (monitored) Indicates whether the domain is monitored for metrics.

    Default: false
    Total accessed time (total_accessed_time) Total accumulated access duration for the domain.
    Total users (total_users) Total number of unique users who accessed the domain. Updated by the daily aggregation job.
    Last accessed time (last_accessed_time) Date and time that the domain was last accessed.
    Total page views (total_page_views) Total number of page views for the domain. Updated by the daily aggregation job.
    Total page views daywise (total_page_views_day_wise) A JSON object storing total page view counts broken down by day (for example, {"2026-03-15": "120", "2026-03-16": "85"}). Updated by the daily aggregation job.
    Table 4. Application table fields
    Name Description
    Service (ci_id) The CMDB service (cmdb_ci_service) associated with the application. The display field.
    SAMP product (samp_sw_product) The Software Asset Management product (samp_sw_product) for the application.
    Source (source) The source (sn_acc_vis_content_source) that discovered or created the application.
    Type (type) Type of application: web or installed

    Default: web
    Metric monitoring (monitored) Indicates whether the application is monitored for metrics. Read-only.

    Default: false