Web usage data collection tables and fields

  • Release version: Zurich
  • Updated March 26, 2026
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Web usage data collection tables and fields

    This documentation describes the key tables and fields used in ServiceNow’s Zurich release to collect and manage web usage data from Windows and macOS machines. It focuses on how web activity is tracked per user, device, domain, and application, providing detailed insights into user behavior and domain-level metrics.

    Show full answer Show less

    Key Features

    • User Web Usage Table: Captures detailed records of web usage per user, device, and domain, including page visit counts and timestamps. It stores daily page visits in a JSON format for retention analysis.
    • Application Domain Table: Maintains domain-level information with aggregation of total page views, unique users, access times, and domain metadata such as category and type (internal/external). Domains are automatically created during full monitoring.
    • Application Table: Groups domains under service applications linked to CMDB services. It tracks application type (web or installed), source of discovery, and Software Asset Management product association, along with monitoring status.

    Key Outcomes

    • Enables tracking of detailed web activity on a per-user, per-device, and per-domain basis, supporting granular usage analysis.
    • Aggregates domain-level metrics daily, providing insights into total page views, unique users, and access duration for better understanding of web traffic patterns.
    • Integrates web usage data with CMDB services and Software Asset Management products, allowing customers to correlate web activity with IT service and asset management.
    • Supports automated and dynamic updating of domain records during monitoring, ensuring comprehensive and up-to-date data collection.

    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