Scheduling the Export Job Run
The Flexera One app includes a job to export data from ServiceNow. This job can be configured to export filtered output of Computers, Netgear, and Software Install data to extract for import into IT Visibility in Flexera One.
| • | Setting Query Filters—instructions for setting filter values as well as sample filter values. |
| • | Scheduling the Export Job—instructions for setting the job schedule. |
Note:The export job leverages the OAuth token used to connect to the Flexera One and IT Visibility. See Generating a Refresh Token in ServiceNow.
Query filter values can be set in the Flexera One Export Properties for Computer, Netgear, and Software Install tables. These filter queries use the same syntax as the filters you use in the table views to filter the tables.
To set query filters for the Export job
| 1. | Go to Filter navigation and search for Flexera One. |
| 2. | Under the Flexera One menu, search for Export Properties and then click Export Properties. |
| 3. | On the Export Properties page, set query filter values for the Computer Query, Netgear Query, and Software Install Query. Some sample query filter values are provided in the table below: |
|
Query Filter |
Sample Query Filter Value |
|
Computer Query |
serial_number!=NULL^operational_status=1^sys_class_name=cmdb_ci_computer |
|
Netgear Query |
operational_status=1^category=Hardware^serial_number!=NULL |
|
Software Install Query |
x_display_name!=NULL^is_normalized=false^active!=false |
| 4. | Click Save. |
Note:Job scheduling requires an account with the ServiceNow admin role.
Follow the instructions below to set the run frequency for the Export job.
To schedule the Export job
| 1. | Go to Filter navigation and search for Flexera One. |
| 2. | Under the Flexera One menu, search for Export and then click Schedule Export. |
| 3. | On the Schedule Export Run page, set the Run frequency for the job. |
| 4. | Click Update. |
The scheduled export will start the export of records based on the queries provided in Export Properties and send it to IT Visibility in Flexera One.
Properties for the job include the following:
| • | Run—The run frequency to use for running the scheduled job: Daily, Monthly, Weekly, Periodically, Once, On Demand, Business Calendar: Entry Start, Business Calendar: Entry End. Jobs set to run Once can be scheduled. Jobs set to run On Demand cannot be scheduled and only run when invoked. |
| • | Time zone—Time zone to use with the Time field entry when you specify the time at which the scheduled job should run. |
Note:For scheduled job types that require an entered time, you have the option to enter an associated time zone. If no time zone is selected, the job will run at the entered time in time zone of the user who entered the time. If Use System Time Zone is selected, the entered time will run in the time zone of the instance running the job.
| • | Time—Time of day at which the scheduled job should run, expressed in hours, minutes, and seconds on a 24-hour clock. |
| • | Run this script—Content of script to run at the scheduled date and time. This script has the logic to run the Flexera One API services for different datasets and executes at the time you specify. |