CFXQL - CFX Query Language

CFX Query Language allows to query the data in cfxDimensions platform in an effective and efficient way and is delivered as part of cfxDimensions platform.

Each CFXQL query can be one or more conditions followed by GET and then column names.

CONDITIONS GET col1, col2 as ‘LABEL1’. The example usage is

Equipment_Type is 'CHASSIS'orEquipment_Type is 'CHASSIS' and first_seen is after 'Sep 15 2020, 10am'or (Equipment_Type is 'CHASSIS') and (first_seen is after 'Sep 15 2020, 10am')

The following table shows all possible operations.

The following example queries are made against asset-db:assetLCMMaster.

Parent_SN is Serial_Number and first_seen is not null and first_seen is after 'Sep 15 2020, 10am' \get IP_Address, Hostname, Product_ID, Site_Code, CAFM_Code, first_seen, last_seen, \Serial_Number, Device_Role​
Equipment_Type is 'CHASSIS' and first_seen is not null and first_seen is after 'Sep 18 2020, 10am' \get IP_Address, Hostname, Product_ID, Site_Code, CAFM_Code, first_seen, last_seen, \Serial_Number, Device_Role​
Equipment_Type is 'CHASSIS' and last_seen is not null and last_seen is before 'Sep 15 2020, 10am' \get IP_Address, Hostname, Product_ID, Site_Code, CAFM_Code, first_seen, last_seen, \Serial_Number, Device_Role​