License key discovery and access control tables
Summarize
Summary of License key discovery and access control tables
This documentation covers the tables, fields, access controls, and scheduled jobs involved in license key discovery within the Agent Client Collector for Visibility - Content on the ServiceNow Zurich release. It provides essential information to manage and interpret license key data collected from endpoint devices.
Show less
Key Tables and Their Purpose
- License Registry Configuration (snaccviscontentlicenseregistryconfig): Admin-managed table listing registry paths and value names to collect license keys from endpoints.
- License Keys (snaccviscontentlicensekeys): Stores discovered license key values along with related information about the device, product, user, and discovery configuration.
License Keys Table Fields
- Configuration Item: The device (from cmdbcicomputer) where the key was collected.
- Product: SAM product associated with the key (from sampswproduct).
- User: Automatically populated user assigned to the CI (from sysuser).
- License Key Config: The configuration rule that discovered the key.
- Resolved Registry Path: Exact registry path on the endpoint where the key was read.
- License Key: The discovered key value itself.
- Last Scanned: Timestamp when the key was last detected.
- Absent: Flag indicating if the key is no longer found; records remain but are marked absent rather than deleted.
License Registry Configuration Table Fields
- Product: Links to the SAM Professional product catalog that the key belongs to.
- Registry Path: Windows registry path where the license key is stored.
- Registry Value Name: Specific registry value to read (e.g., DigitalProductId).
- Name: Auto-generated from Product and Registry Value Name.
- Description: Notes about the configuration record.
- Active: Indicates if the configuration is included in future collections; inactive records are excluded.
Important: The combination of Product, Registry Path, and Registry Value Name must be unique.
Access Control
- ACC application admin (agentclientcollectoradmin): Full access (read, write, create) to License Registry Configuration; read-only on License Keys.
- Discovery admin (discoveryadmin): Full access to License Registry Configuration; read-only on License Keys.
- SAM admin (samadmin): Read-only access to both License Registry Configuration and License Keys tables.
- All other roles: No access to these tables.
Scheduled Job
A scheduled job named "Refresh License Key Config File" runs daily at 8:30 a.m. UTC to support license key discovery. It executes only when the system property snaccviscontent.enablelicensekeydiscovery is set to true and the SAM Professional plugin (com.snc.samp) is activated.
Reference information for the tables, fields, access control, and scheduled job used by license key discovery in Agent Client Collector for Visibility - Content.
Tables
License key discovery uses the following tables.
| Table | Label | Purpose |
|---|---|---|
| sn_acc_vis_content_license_registry_config | License Registry Configuration | Admin-managed list of registry paths and value names to collect from managed endpoints. |
| sn_acc_vis_content_license_keys | License Keys | Stores the license key values collected from endpoint devices. |
License Keys table fields
The License Keys [sn_acc_vis_content_license_keys] table stores the following fields for each discovered key.
| Field | Description |
|---|---|
| Configuration Item | Device the key was collected from. Table: cmdb_ci_computer. |
| Product | SAM product associated with this key. Table: samp_sw_product. |
| User | This field is automatically set to the user assigned to the CI. Table: sys_user. |
| License Key Config | Configuration rule that discovered this key. Table: sn_acc_vis_content_license_registry_config. |
| Resolved Registry Path | Exact registry path the key was read from on the endpoint. |
| License Key | Discovered key value. |
| Last Scanned | Date the key was last detected by the agent. |
| Absent | Selected when the key is no longer found on the device. Records are never deleted, they are marked Absent instead. |
License Registry Configuration form fields
The following table describes the fields in the License Registry Configuration [sn_acc_vis_content_license_registry_config] table.
| Field | Description |
|---|---|
| Product | SAM product this license key belongs to. Links to the SAM Professional product catalog. |
| Registry Path | Windows registry path where the key is stored. For example, HKLM\SOFTWARE\Microsoft\Office\16.0\Registration. |
| Registry Value Name | Specific registry value to read. For example, DigitalProductId. |
| Name | This field is automatically set to a combination of the Product and Registry Value Name values. |
| Description | Notes about this configuration record. |
| Active | Indicator of whether this record is included in future collections. Clearing this check box removes the record from future collections. |
Access control
The following table shows which roles can access each license key discovery table.
| Role | License Registry Configuration table | License Keys table |
|---|---|---|
| ACC application admin (agent_client_collector_admin) | Read, write, create | Read only |
| Discovery admin (discovery_admin) | Read, write, create | Read only |
| SAM admin (sam_admin) | Read only | Read only |
| All other roles | No access | No access |
Scheduled job
The following scheduled job supports license key discovery.
| Job | Schedule | Condition |
|---|---|---|
| Refresh License Key Config File | Daily at 8:30 a.m. UTC | Runs only when the sn_acc_vis_content.enable_license_key_discovery property is set to true and the SAM Professional plugin (com.snc.samp) is activated. |