Web usage data collection tables and fields

  • Release version: Yokohama
  • 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 details the key tables and fields used in ServiceNow's Yokohama release to collect and manage web usage data from Windows and macOS devices. Understanding these tables helps you monitor user web activity, aggregate usage data, and associate it with applications and services in your CMDB.

    Show full answer Show less

    Data Collection Tables

    • User Web Usage (snaccviscontentuserwebusage): Captures detailed per-user, per-device, per-domain web usage including page visit counts and daily usage metrics.
    • Application Domain (snaccviscontentapplicationdomain): Stores aggregated domain-level data such as total page views, user counts, and trends. Domains are automatically created during full monitoring if not preconfigured.
    • Application (snaccviscontentapplication): Groups one or more domains under a service application linked to CMDB services and data sources.

    User Web Usage Table Fields

    • Domain: The visited website's domain.
    • Device: The computer (cmdbcicomputer) used to access the site.
    • User: The individual who accessed the site.
    • Last Accessed: Timestamp of the most recent access.
    • Page Visits: Total page visits for the user-domain-device combination.
    • Page Visits Daywise: JSON object tracking daily page visits over the retention period.

    Application Domain Table Fields

    • Application: The application record the domain belongs to.
    • Domain: Unique domain name monitored (e.g., example.com).
    • Category: URL category classification.
    • Domain Type: Internal or external domain designation (default external).
    • CMDB HTTP Endpoint: Associated HTTP endpoint for SaaS applications.
    • Metric Monitoring: Flag indicating if metrics are monitored for the domain (default false).
    • Total Accessed Time: Accumulated duration the domain was accessed.
    • Total Users: Count of unique users accessing the domain, updated daily.
    • Last Accessed Time: Latest access timestamp.
    • Total Page Views: Aggregate page views for the domain, updated daily.
    • Total Page Views Daywise: JSON object with daily page view counts, updated daily.

    Application Table Fields

    • Service: CMDB service linked to the application, also the display field.
    • SAMP Product: Software Asset Management product associated with the application.
    • Source: Origin that created or discovered the application record.
    • Type: Application type, either web or installed (default web).
    • Metric Monitoring: Read-only flag indicating if the application is monitored for metrics (default false).

    Practical Benefits for ServiceNow Customers

    By leveraging these tables and fields, you can efficiently track and analyze detailed web usage across users and devices, understand domain-level and application-level usage trends, and integrate web usage insights with your CMDB services. Automated aggregation jobs maintain up-to-date summaries, enabling proactive monitoring and informed decision-making related to application and network usage.

    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