Skip to main content

ServiceNow Integration with FileWave

This example imports FileWave device inventory into a ServiceNow computer table through the FileWave Command Line API and a ServiceNow REST data source. It preserves the tested ServiceNow Orlando-era Flow Designer steps; current ServiceNow labels may differ, so validate the workflow in a non-production instance first.

Third-party workflow. FileWave provides this ServiceNow configuration as an example, not as a supported ServiceNow implementation. Coordinate ServiceNow table, transform, credential, and Flow Designer changes with the team that owns that platform.

Step-by-Step Guide

Step 1: Create Data Source

System Import Sets > Administration > Data Sources > New

  1. NAME: FileWave REST API
  2. IMPORT SET LABEL: (empty)
  3. IMPORT SET TABLE NAME: u_fw_api
  4. TYPE: REST
  5. FORMAT: JSON
  6. PATH FOR EACH ROW: /values/values
  7. DISCARD ARRAYS: √
  8. EXPAND: √
  9. DATA IN SINGLE COLUMN: (unchecked)
  10. APP: Global
  11. REQUEST ACTION: Hit the “click here” and create one (see Step 2)

eyf9O555DfXB4Qzk-embedded-image-xuthosas.png

Step 2: Create Request Action

  1. NAME: GET FW REST
  2. ACCESSIBLE FROM: All application scopes
  3. CATEGORY: (empty)
  4. PROTECTION: —None—
  5. DESCRIPTION: (empty)
  6. APPLICATION: Global
  7. IN-FLOW ANNOTATION: (empty)
  8. Then hit "Submit"

(You should be redirected to the Flow Designer for GET FW REST...see Step 3)

Request Action

Step 3, Part 1: Create in Flow Designer

Create in FLOW DESIGNER, Select #1 “REST step”

- Connection Details -

-Request Details-

  • BUILD REQUEST: Manually
  • RESOURCES PATH: (empty)
  • HTTP METHOD: POST

Why this example uses POST. The request sends an ad-hoc Inventory Report definition instead of depending on a saved report that another administrator could change. Customize the fields list for your environment. The example requests a Custom Field named asset_tag; remove or replace that field when its internal name does not exist on your FileWave Server.

        {
            "column": "asset_tag",
            "component": "CustomFields"
        }
  • QUERY PARAMETERS: (empty)
  • HEADERS:
    1. Name: Authorization
      Value: a FileWave application token from FileWave Central → Assistants → Manage Administrators → Application Tokens. Use a dedicated administrator with only the permissions required for this inventory import, and store the token in ServiceNow's protected credential mechanism rather than in notes or screenshots.
    2. Name: Content-Type
      Value: application/json

-Request Content-

  • REQUEST TYPE: Text
  • REQUEST BODY: - See "Request JSON" example below:

Request 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-

  • ENABLE RETRY POLICY: (unchecked)
  • Save
  • Test Connection
    • Test > Use “test” for “Attachment Name” > Run Test
    • Select the “Action has been executed. To view action, click here.”
    • Verify an HTTP 200 response and inspect the returned JSON for the expected fields before publishing the action.
    • Select the “(gear) GET FW REST” flow designer tab
    • Close the “Test Action” window with the X
  • Select Publish

Close this browser window/tab to return to the “New Record | Data Source | ServiceNow” window/tab

lSij7W8EB7aWx5r4-embedded-image-ihvhkquf.pngHbhzVJPvP3a5jSQw-embedded-image-dqov9w8z.png

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.

WMmYZRRL84D1ntyT-embedded-image-zmqfmkoj.png

Step 3, Part 3: Generate Data Transform

Generate Transform(s)

— MAKING TRANSFORMS ––

On the FileWave REST API page, scroll down to the “Transforms” tab and select “New”

  • NAME: FW API Map
  • SOURCE TABLE: (should auto fill the u_fw_api table)
  • ACTIVE: √
  • RUN BUSINESS RULES: √
  • ENFORCE MANDATORY FIELDS: No
  • COPY EMPTY FIELDS: (unchecked)
  • CREATE NEW RECORD ON EMPTY COALESCE FIELDS: √
  • APPLICATION: Global (input disabled)
  • CREATED: Will auto-generate with Date/Time stamp when saved (input disabled)
  • TARGET TABLE: Computer [cmdb_ci_computer]
  • ORDER: 100
  • RUN SCRIPT: (unchecked)

Table Transform Map

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

...

  

Mapping Assist


You can make more maps, like this example for location data:

Scroll down to the “Transforms” tab and select “New”

  • NAME: FW Location Map
  • SOURCE TABLE: (should auto fill the u_fw_api table)
  • ACTIVE: √
  • RUN BUSINESS RULES: √
  • ENFORCE MANDATORY FIELDS: No
  • COPY EMPTY FIELDS: (unchecked)
  • CREATE NEW RECORD ON EMPTY COALESCE FIELDS: √
  • APPLICATION: Global (disabled)
  • CREATED: (disabled)
  • TARGET TABLE: Location [cmn_location]
  • ORDER: 100
  • RUN SCRIPT: (unchecked)

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.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/import-sets/task/t_ScheduleADataImport.html

No comments to display

Back to top