Filtering What Is Exported From ServiceNow
The Flexera One app gives you the flexibility to filter which records to export for each of the following classes. These filter queries use the same syntax as the filters you use in the table views to filter the tables. The Export job also supports ServiceNow encoded queries.
The queries that filter the output of the Export job are available on the Export Properties page. On the Export Properties page, you can configure queries to filter values for the Computer Query, the Netgear Query, and the Software Install Query.
• | Computer: This filter can be created for the cmdb_ci_computer table and any tables extended from it—such as Windows server and Linux server. |
• | Netgear: This filter can be created for the cmdb_ci_netgear table and any tables extended from it—such as IP_Router and IP_Switch |
• | Software Installations: This filter can be created for the cmdb_sam_sw_install table. |
The instruction set below explains how to set the Export job’s query filters. A list of example queries is also provided below the instruction set.
Setting Query Filters
Query filter values can be set in the Flexera One Export Properties for Computer, Netgear, and Software Install tables.
To set filters for the content of the export
1. | Navigate to Flexera One > Export Configurations > Export Properties. |
2. | On the Export Properties page, enter a query for each table for which you would like to filter export data. |
Filter queries can be set for Computer Query, Netgear Query, and Software Install Query. Some sample query filter values are provided here.
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 |
See Example Queries for Each Class for additional examples, below.
Tip:You can also choose to omit from the export all the records in a table/class that supports query filters (Computer, Netgear, or Software Install). If you do not want to export any Software records, for example, then enter a query that will not return any data—such as sys_idISEMPTY—for the Software Install Query.
3. | Click Save. |
Example Queries for Each Class
Computer: operational_status=1^serial_numberISNOTEMPTY^sys_class_name=cmdb_ci_computer
This filter would cause the export to return all records that have an operational status of Operational, a serial number that is not empty, and class of computer.
Netgear: manufacturer=b7e831bdc0a80169015ae101f3c4d6cd^sys_class_name=cmdb_ci_netgear
This query would return all records where the class equals netgear and the manufacturer equals Cisco.
Software Installation: publisherISNOTEMPTY^installed_on.operational_status=1
This query would return all records from the software installation table where the publisher is not empty and the operational status of the device it is installed on is Operational.