Web usage data collection tables and fields
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 content describes the key tables and fields used in ServiceNow to gather and store web usage data from Windows and macOS devices. It details how the system tracks user interactions with websites, categorizes domains, and associates web activity with applications and CMDB services. This data supports monitoring and analysis of web usage patterns within your organization.
Show less
Key Tables and Their Purpose
- User Web Usage (snaccviscontentuserwebusage): Records detailed web usage per user, device, and domain, including page visit counts and access times on a daily basis.
- Application Domain (snaccviscontentapplicationdomain): Stores domain-level information, aggregates usage totals such as total page views and unique users, and automatically creates new domain records discovered through full monitoring.
- Application (snaccviscontentapplication): Groups one or more domains into service applications linked to CMDB services and data sources, supporting application-level web usage monitoring.
Important Fields and Their Roles
- User Web Usage Table: Tracks the domain visited, the device and user involved, last accessed timestamp, page visits, and a daywise breakdown of page visits in JSON format for retention and analysis.
- Application Domain Table: Contains domain name (unique identifier), associated application, URL category, domain type (internal or external), monitoring status, total accessed time, total unique users, last access time, and both total and daywise page views. Aggregated fields are updated daily by the aggregation job.
- Application Table: Links to the CMDB service and Software Asset Management product, records the source of the application data, application type (web or installed), and metric monitoring status (read-only).
Practical Benefits for ServiceNow Customers
By leveraging these tables and fields, customers can:
- Gain detailed visibility into web usage across users, devices, and domains.
- Understand and categorize domain usage through automated domain discovery and classification.
- Associate web usage data with CMDB services and applications for better IT service management and optimization.
- Use aggregated daily metrics to monitor trends and inform decision-making regarding application and network usage.
Description of the tables and their fields used when gathering web usage data from your Windows and macOS machines.
| 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. |
| 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"}) |
| 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. |
| 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 |