ServiceNow integration with FileWave
ServiceNow can be provided with device inventory information from FileWave to make the ServiceNow experience much more accurate and rewarding. Previously, a ServiceNow portal app was required to supply this FileWave data, but as of version Orlando of ServiceNow that is no longer required, and the FileWave API can be used directly. This guide, provided as a courtesy for a non-FileWave related system, will show you how to bring the information gathered by FileWave inventory into ServiceNow using the API.
Note that the previous FileWave application in the ServiceNow app portal has been discontinued in favor of this integration method.
Step-by-Step Guide
Step 1: Create Data Source
System Import Sets > Administration > Data Sources > New
Step 2: Create Request Action
(You should be redirected to the Flow Designer for GET FW REST...see Step 3)
Step 3, Part 1: Create in Flow Designer
Create in FLOW DESIGNER, Select #1 “REST step”
The reason this is a POST is so we don't rely on an inventory query that might be changed.
Customize the fields portion as needed.
This is an example of custom fields. If the field named "asset_tag" does not exist in your system, this will cause an error.
{
"column": "asset_tag",
"component": "CustomFields"
}
Value: Your Users Application Token (FW Admin > Assistants > Manage Administrators > (select admin) > Application Tokens > (Copy the base64: e.g. aalkjdlAKJDlakjdALkdsjaldksja= ) Name: Content-Type
Value: application/json
{
"criteria": {
"expressions": [
{
"column": "filewave_client_name",
"component": "Client",
"operator": "is_not",
"qualifier": null
},
{
"column": "last_check_in",
"component": "Client",
"operator": "!=",
"qualifier": null
}
],
"logic": "all"
},
"fields": [
{
"column": "filewave_id",
"component": "Client"
},
{
"column": "filewave_client_name",
"component": "Client"
},
{
"column": "current_ip_address",
"component": "Client"
},
{
"column": "last_check_in",
"component": "Client"
},
{
"column": "latitude",
"component": "GeoLocation"
},
{
"column": "longitude",
"component": "GeoLocation"
},
{
"column": "type",
"component": "OperatingSystem"
},
{
"column": "version",
"component": "OperatingSystem"
},
{
"column": "filewave_client_version",
"component": "AndroidClient"
},
{
"column": "filewave_client_version",
"component": "DesktopClient"
},
{
"column": "cpu_count",
"component": "Client"
},
{
"column": "cpu_speed",
"component": "Client"
},
{
"column": "ram_size",
"component": "Client"
},
{
"column": "total_disk_space",
"component": "Client"
},
{
"column": "free_disk_space",
"component": "Client"
},
{
"column": "serial_number",
"component": "Client"
},
{
"column": "asset_tag",
"component": "CustomFields"
}
],
"main_component": "Client"
}
-Retry Policy-
Close this browser window/tab to return to the “New Record | Data Source | ServiceNow” window/tab
Step3, Part 2: Set Request Action
Under REQUEST ACTION, start typing the name of the Action we just created "GET FW REST" and select it from the drop-down.
Submit
Hitting 'Submit' will redirect you back to the Data Source list. Select the one we just made, FileWave REST API and select "Load All Records" under Related Links
Once the test has completed, go back to FileWave REST API's Data Source page and continue to next step.
Step 3, Part 3: Generate Data Transform
— MAKING TRANSFORMS ––
On the FileWave REST API page, scroll down to the “Transforms” tab and select “New”
Select “Mapping Assist” under Related Links
You should be able to map a lot of the client's information, for example...
FileWave
ServiceNow
operatingsystem_type
Operating System
client_cpu_count
cpu_count
client_current_ip_address
ip_address
client_ram_size
ram
customfields_asset_tag
asset_tag
client_total_disk_space
disk_space
operatingsystem_version
os_version
client_cpu_speed
cpu_speed
client_filewave_client_name
name
client_serial_number
serial_number
...
You can make more maps, like this example for location data:
Scroll down to the “Transforms” tab and select “New”
Select “Mapping Assist”
FileWave
ServiceNow
geolocation_latitude
latitude
geolocation_longitude
longitude
client_filewave_client_name
Name
Once you're finished, save your data, update the Table Transform Map form and continue to next steps.
Part 4: Schedule the Job
Schedule the job
Schedule the import task you just created...recommend at least daily.
System Import Sets > Administration > Scheduled Imports.