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 from which you would like to export data.

Filter queries can be set for Computer Query, Netgear Query, and Software Install Query. If you do not want to export any Software records, for example, leave the Software Install Query blank. Some sample query filter values are provided here. An additional query example for each class appear in a list following this instruction set.

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

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 would return all records where the class equals netgear and the manufacturer equals Cisco.

Software Installation: publisherISNOTEMPTY^installed_on.operational_status=1

This 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.