Introduction
HP Workforce Experience Platform (WXP) Device Management application allows end-to-end integration between HP Workforce Experience and ServiceNow Configuration Management Database (CMDB). This technical design document presents a detailed description of the application's architecture, data flow, user interface, and configuration requirements. It is designed to be used by system administrators, IT operations professionals, and asset managers who would be deploying, operating, and maintaining the integration for increased visibility of devices, enriching the CI data, and automating incident management in real-time using telemetry and update capabilities.
This TDD covers the following topics:
Purpose and Scope of the Document
This document describes the technical design for integrating HP Workforce Experience with ServiceNow's Configuration Management application. It details the features, architecture, data flow, user interface, and crucial components of the integration, ensuring consistency with ServiceNow’s best practices.
For installation instructions, a supporting user guide documentation provides comprehensive information on how to install and configure the HP WXP Device Management application.
Overview of the Application
The integration of HP Workforce Experience with ServiceNow’s Configuration Management provides the capability to import ServiceNow CMDB CIs (cmdb_ci_computer) based on HP Workforce Experience Platform data for a specific tenant. The integration enables ongoing CI data enrichment through a pre-defined field mapping, as well on-demand access to telemetry data such as battery status, hardware health, blue screen errors, warranty information, etc. that improves overall incident handling.
Target Audience
This technical design document is aimed at system and application administrators tasked with implementing and managing the HP Workforce Experience integration with ServiceNow’s Configuration Management application. It is also intended for IT operations teams, support engineers, and CMDB and asset managers.
2. Key Features and Use Cases
This integration features a ServiceNow Configuration Wizard designed to streamline the setup and deployment. With its guided, step-by-step interface, the wizard facilitates configuring the connection between HP Workforce Experience and ServiceNow’s Configuration Management application. Notable features of the wizard include:
Authentication using Fastn.AI
Selection of tenants
Import of CI records (computers)
Pre-defined field mapping between HP Workforce Experience and ServiceNow cmdb_ci_computer table
Ongoing updates of HP Workforce Experience data to CI record
On-demand telemetry data (hardware health, blue screen errors, battery status, warranty information, etc.)
The use case diagram below provides a visual representation of the integration from the perspectives of different personas, such as HP and ServiceNow.
3. Application Architecture
The Application Architecture section contains the high-level architecture diagram, application scope information, data flow diagrams, and any integrations with other systems/applications. These designs reflect how components of the application interact and how data flows.
4. Data Model
The Data Model section contains an entity-relationship diagram (ERD), table definitions with field names, types and relationships, and also access control requirements.
4.1 Data Model Narrative
4.2 Table Name - HP Workforce Experience Device Import Set
set(x_hpws_wrkfrcexpdm_hp_workforce_experience_device_import_set)
Column name | Column label | Mandatory | Primary | Type | Max length |
organizationid | Organization Id | FALSE | FALSE | String | 40 |
sys_id | Sys ID | FALSE | TRUE | Sys ID (GUID) | 32 |
operatingsystem | Operating system | FALSE | FALSE | String | 50 |
lastseen | Last seen | FALSE | FALSE | String | 40 |
osrelease | Os release | FALSE | FALSE | String | 50 |
serialnumber | Serial number | FALSE | FALSE | String | 40 |
manufacturer | Manufacturer | FALSE | FALSE | String | 50 |
createdts | Created Ts | FALSE | FALSE | String | 40 |
devicetype | Device type | FALSE | FALSE | String | 50 |
graphics | Graphics | FALSE | FALSE | String | 50 |
firmwareversion | Firmware version | FALSE | FALSE | String | 40 |
memory | Memory | FALSE | FALSE | String | 50 |
alias | Alias | FALSE | FALSE | String | 50 |
biosversion | Bios version | FALSE | FALSE | String | 70 |
manufacturedate | Manufacture date | FALSE | FALSE | String | 40 |
name | Name | FALSE | FALSE | String | 50 |
location | Location | FALSE | FALSE | String | 40 |
devicemodel | Device model | FALSE | FALSE | String | 70 |
assettag | Asset tag | FALSE | FALSE | String | 50 |
osversion | OS version | FALSE | FALSE | String | 50 |
productsku | Product Sku | FALSE | FALSE | String | 50 |
dataasofdate | Data as of date | FALSE | FALSE | String | 50 |
lifecyclestatus | Lifecycle status | FALSE | FALSE | String | 40 |
processor | Processor | FALSE | FALSE | String | 50 |
Access Control Requirements
List of ACLs for reference:
Name | Operation | Type | Role |
x_hpws_wrkfrcexpdm_hp_workforce_experience_device_import_set | delete | record | x_hpws_wrkfrcexpdm.hp_workforce_experience_device_import_set_user |
x_hpws_wrkfrcexpdm_hp_workforce_experience_device_import_set | write | record | x_hpws_wrkfrcexpdm.hp_workforce_experience_device_import_set_user |
x_hpws_wrkfrcexpdm_hp_workforce_experience_device_import_set | read | record | x_hpws_wrkfrcexpdm.hp_workforce_experience_device_import_set_user |
x_hpws_wrkfrcexpdm_hp_workforce_experience_device_import_set | create | record | x_hpws_wrkfrcexpdm.hp_workforce_experience_device_import_set_user |
5. User Interface and Installation Guide
The user interface design section references wireframes/screenshots of application UI elements and navigation paths showing common user paths and design.
See User Installation Guide
6. Business Logic and Workflow
The business logic and workflow section contains a process flow, transform maps, script includes, record producers, catalog client scripts, catalog UI policies, UI pages, notifications, system properties, images, UI actions and other sections.
6.1 HP Workforce → Import set table → Computer Record
Import Set Table: Data from HP Workforce Experience will be inserted in the import set staging table.
6.2 Process Flow
HP WXP Device Management
Computer Record
Import Set Staging Table
Scheduled Job
6.3 Import Set Web Services
List of Import Set Web Services for reference:
Name | Application |
HP WXP Devices Import Set | HP Workforce Experience Platform Device Management |
6.4 Transform Maps
The table below shows the transform map list created for mapping the staging table to target table:
Name | Source table | Target table |
HP WrkfrcExpDM Transform map | HP WXP Devices Import Set [x_hpws_wrkfrcexpdm_hp_workforce_experience_device_import_set] | Computer [cmdb_ci_computer] |
Note: Ensure that the foundation data in ServiceNow (company and location records) is aligned with the company, manufacturer and location values in HP Workforce Experience Platform to avoid mismatch.
In case of no match found or mismatch between the company and location names, the fields: company, manufacture and location on the computer table (cmdb_ci_computer) will remain empty after the sync as the choice action on those fields is set to ‘ignore’.
6.5 Script Includes
List of Script Includes for reference:
Name | Description | Application |
WrkfrcExpFleetDeviceMgmtUtil | Includes functions for calling API and handling the response. | HP Workforce Experience Platform Device Management |
WrkfrcExpDMUtil | Includes functions for general utilities | HP Workforce Experience Platform Device Management |
6.6 Scheduled Script Executions
List of Scheduled Script for reference:
Name | Description | Type | Default execution interval | Application |
On Demand: Calibrate URL References | To populate sysID values to respective system properties. | On Demand | ----- | HP Workforce Experience Platform Device Management |
Periodic: Get all Assets | To get all the assets | Periodic | Weekly (Sunday) | HP Workforce Experience Platform Device Management |
6.7 Record Producers
List of Record Producers for reference:
Record Producer Name | Description |
HP WXP Device Management Company | This form is used for tenant selection within guided setup and post guided setup in ‘Add Tenants’ module. |
HP WXP Device Management Group/Email for Failure Notification | This form is used to provide the group/Email address for which failure notification has to be sent. |
HP WXP Device Management Company to Remove | Post Guided Setup is used for removing active tenants. |
6.8 Catalog Client Scripts
List of Catalog Client Scripts for reference:
Name | Catalog item | Description | Type |
Populate Company | ------- | Populate Company | OnLoad |
Group email validation | HP Workforce Experience Device Management Group/Email for Failure Notification | To ensure if entered time is not future date | onChange |
Set email address to system property | HP Workforce Experience Device Management Group/Email for Failure Notification | To set the system property value with the selected group’s email address | onSubmit |
Get tenants data | HP WXP Device Management Company to Remove | Gets tenant data for scripted list on selected tenants page | onLoad |
Hide Remove All button | ------- | Hides the remove all button on the selected tenants page | onLoad |
Send channel to computer | ------- | onChange | |
Get Tenants | ------ | onLoad |
6.9 Catalog UI Policies
List of Catalog UI Policies for reference:
Name | Catalog item | Description | Applies on a Catalog Item view [Catalog UI Policy] | Applies on the Target Record [Catalog UI Policy] |
6.10 UI Pages
List of UI Pages for reference:
UI Page Name | Description |
WrkfrcExpfmdmRedirectContact | To redirect to record producer |
WrkfrcExpfmdmRedirectEmail | To redirect to record producer |
WrkfrcExpfmdmRedirectCompany | To redirect to record producer |
WrkfrcExpfmdmRPSuccess | To display Success message upon submission of record producer |
extra_fields | To display attributes of API |
DiscoverySource | To display the steps to configure Discovery Source |
battery_risk_factors | To display attributes of API in Computer record |
bluescreen_errors | To display attributes of API in Computer record |
|
|
WrkfrcExpDMAppPrivacyPolicy | To display App Privacy Policy module |
WrkfrcExpDMGuidedSetUp | To pass sys id of Guided setup |
hw_warranty | To display attributes of API in Computer record |
WrkfrcExpfmdmRedirectJob | To redirect to the scheduled job |
Note : Created UI Pages to use their endpoints in Guided Setup in order to avoid using Sys ID in redirection URL.
6.11 Notifications
List of notifications for reference:
Notification Name | Description |
Wrkfrc Exp Fleet DM Integration Failure | To trigger when an integration failure is identified between SNOW and HP |
6.12 Event Registry
List of Event Registry for reference:
Event Registry Name | Description |
x_hpws_wrkfrcexpdm.hp.dm.failure.notify | To trigger notification: Wrkfrc Exp Integration Failure |
6.13 Notification Email Script
Notification Email Script for reference:
Notification Email Script Name | Description |
wrkfrc_exp_dm_failure_notification | This is used to show email body for the notification: Wrkfrc Exp Integration Failure |
6.14 System Properties
List of System Properties for reference:
Name | Description |
x_hpws_wrkfrcexpdm.rec.prod.company | holds the sysid of the record producer: HP WXP Device Management Company |
x_hpws_wrkfrcexpdm.failureNotif_rcrdprdcr | Holds the sysID of the record producer: HP Workforce Experience Device Mgmt Group/Email for Failure Notification |
x_hpws_wrkfrcexpdm.hp.dm.application | Holds the sysID of the application: HP WXP Device Management |
x_hpws_wrkfrcexpdm.api.fastn.device.api.key | HP WXP Device Management API Key |
x_hpws_wrkfrcexpdm.relatedlink.page.size | Related link page size |
x_hpws_wrkfrcexpdm.tenants | tenantId of partner/company |
x_hpws_wrkfrcexpdm.company.tenants | company tenantIds of children companies including parent |
x_hpws_wrkfrcexpdm.device.fastn.space.id | HP Workforce Experience API Space ID |
x_hpws_wrkfrcexpdm.selected.tenants | selected tenants |
x_hpws_wrkfrcexpdm.email_notify | Holds the email address that receives failure notification. |
x_hpws_wrkfrcexpdm.batch.size | HP WXP Device Management Page Size |
x_hpws_wrkfrcexpdm.device.fastn.api.baseurl | Base URL for fastn device management |
x_hpws_wrkfrcexpdm.config_complete | Indicates if configuration for HP WXP Device Management app is complete |
x_hpws_wrkfrcexpdm.sch_job | Holds the sys id of the scheduled job |
x_hpws_wrkfrcexpdm.remove.tenants.name | To remove active tenants post Guided Setup. |
x_hpws_wrkfrcexpdm.selected.tenants.name | To add more tenants post Guided Setup. |
6.15 Outbound Integrations [REST Message]
List of REST Messages for reference:
Name | Application |
HP WXP Device Management | HP Workforce Experience Platform Device Management |
6.16 REST Message – HTTP Methods
List of HTTP Methods for reference:
Name | Authentication type | Application |
Hardware Warranty | Inherit from parent | HP Workforce Experience Platform Device Management |
Get Assets | No authentication | HP Workforce Experience Platform Device Management |
Get Asset Detail | No authentication | HP Workforce Experience Platform Device Management |
Get Battery Risk Factors | No authentication | HP Workforce Experience Platform Device Management |
Get Hardware Blue Screen Details | No authentication | HP Workforce Experience Platform Device Management |
6.17 Modules
List of Modules for reference:
Name | Application | Visibility Roles |
All Devices | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.user, x_hpws_wrkfrcexpdm.admin |
All Assets | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.user |
Computers | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.user, x_hpws_wrkfrcexpdm.admin |
Check Sync Logs | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Configuration | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Contact | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.user, x_hpws_wrkfrcexpdm.admin |
Guided Setup | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
HP WXP Devices Staging | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Imports | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Outbound Rest | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Scheduled Jobs | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Settings | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Support | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.user, x_hpws_wrkfrcexpdm.admin |
App Privacy Policy | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
Add Tenants | HP Workforce Experience Platform Event Management | x_hpws_wrkfrcexpdm.admin |
Remove Active Tenants | HP Workforce Experience Platform Device Management | x_hpws_wrkfrcexpdm.admin |
6.18 Images
List of Images for reference:
Name | Application |
x_hpws_wrkfrcexpdm.AppPriPolicy.png | HP Workforce Experience Platform Device Management |
x_hpws_wrkfrcexpdm.ContactModuleHelp.png | HP Workforce Experience Platform Device Management |
x_hpws_wrkfrcexpdm.ContactModule.png | HP Workforce Experience Platform Device Management |
x_hpws_wrkfrcexpdm.HPLogo.png | HP Workforce Experience Platform Device Management |
x_hpws_wrkfrcexpdm.ContactHome.png | HP Workforce Experience Platform Device Management |
6.19 UI Actions
List of UI Actions for reference:
UI Action Name | Description |
Sync CI | To sync the CI |
Get blue screen errors | To display CI attributes related to blue screen errors |
Get battery risk factors | To display CI attributes related to battery risk factors |
Get hardware warranty | To display CI attributes related to hardware warranty |
Get additional attributes | To display CI additional attributes |
Note: These UI Actions are visible as related links on cmdb_ci_computer record.
6.20 Business Rules
List of Business Rules for reference:
Business Rule Name | Description |
---|---|
Populate correlation_id | To populate correlation id |
Remove Tenants | To remove tenants from scripted list. |
7. Deployment and Implementation
The deployment and implementation section details the deployment process, application dependencies, installation steps, demo data, environment setup, and rollback plan.
7.1 Deployment Process
Access the HP Workforce Experience Platform Device Management application listing on the ServiceNow App Store and purchase.
Ensure all application dependencies have been addressed (see application dependencies below).
Conduct installation of the application (see installation steps below).
The deployment process must be conducted for each environment.
7.2 Application Dependencies
The application requires the following dependency:
1. CMDB plugin: com.snc.cmdb
7.3 Installation Steps
In order to install the HP Workforce Experience Platform Device Management application follow the below listed steps (Install a ServiceNow Store Application):
Navigate to All > System Applications > All Available Applications > All
Search for “HP Workforce Experience Platform Device Management”
Click the “Install” button to begin installation of the application
Once the install is finished, click the “Close” button
7.4 Demo Data
Demo data is not required for the installation of the HP Workforce Experience Platform Device Management application.
The HP Workforce Experience platform is best utilized in ServiceNow with multiple environments: a production instance and a UAT instance.
Production Instance – The environment where the majority of customers (application users) will access the scoped application.
UAT Instance – The environment where publications should first be deployed to.
7.6 Rollback Plan
In order to rollback the HP Workforce Experience Platform Device Management application from the ServiceNow App Store follow the below steps (Rollback a ServiceNow Store Application):
1. Go to System Applications > My Company Applications
2. Search for and click the HP Workforce Experience Platform Device Management application.
3. In the record, select the Rollback related link
4. Navigate back to System Applications > My Company Applications and verify.
8. Maintenance and Support
The maintenance and support section outlines support procedures for the HP Workforce Experience Platform Device Management application, SLA definition information, and the contact method/details. Also, the version control strategy are listed.
8.1 Application Updates
If the application requires an update the below steps can be utilized (Install an Update to a ServiceNow Store Application):
Navigate to System Applications > All Available Applications > All
Here, find the application using filters or the search bar
If an update is available, select the version
Click ‘Update’
8.2 Support Procedures
Customers should start with their Service Desk/Support team to report any issues and to determine if the HP Workforce Experience support team is required for further assistance. In the event customers are instructed to contact HP Workforce Experience for technical support, the hours/days of operation, and contact method/details are provided below.
Support Hours of Operation: 8am - 5pm EST
Support Days of Operation: Monday - Friday (exception US Holidays)
Contact Method: HP Workforce Experience Platform: Support
Click Help and Support
Click Request under the Email section
8.3 Version Control Strategy
Application Admins are responsible for determining which version is best. Managing the version of the HP Workforce Experience Platform Device Management application can be accomplished via these steps (Install Version ServiceNow Store Application).
Navigate to System Applications > All Available Applications > All
Find the HP Workforce Experience Platform Device Management application using filters or search bar.
If a new version is available, select the new version.
Click ‘Update’.
9. Appendix
The appendix section contains the glossary of terms and references throughout the document. In addition, the appendix holds links to documentation for managing a ServiceNow Store application, links to required plugins, and a link to the HP Workforce Experience platform.
9.1 Glossary of Terms
The terms listed below have a provided definition and are present throughout the document.
Application Admin: User with elevated privileges and permissions similar to that of admin, but specifically for the scoped application. The application admin role contains permissions beyond that of the admin within the scoped app. Can access all modules of the scoped app by default.
Application User: User with mostly viewing privileges and permissions similar to that of itil user, but specifically for the scoped application. Can only access specific modules of the scoped application by default.
HP Workforce Experience Platform Device Management: long name of the application.
HP WXP Device Management: short name of the application.
wrkfrc_exp: abbreviated short name of the application used in back-end items.
Fastn.ai: ai powered API orchestration platform for which the HP Workforce Experience application connects Proactive Insights data to ServiceNow.
9.2 Related Resources
Contact Us
For any assistance, create a support case or email [email protected].