cfxdm - dm:sort
Sort the data in ascending or descending order
dm:sort: This cfxdm tag allows the user to sort the data for a given column(s) in ascending or descending order.
dm:sort syntax: It supports the below arguments
    columns (mandatory). It accepts one or more column names. If more than one column is specified, use comma as a separator.
    order (optional). Supported values are 'ascending' or 'descending'. When not specified, default applied sort order is 'ascending'
dm:sort columns = 'COLUMN_A,COLUMN_B,..'
OR
dm:sort columns = 'COLUMN_A,COLUMN_B,..' & order = 'ascending/descending'
In the below example, for a reference, we are going to use VMware vROps as an extension to query the data and ingest it into dm:sort tag for applying the sort capability.
Enter the below command to select VMware vROps VM Summary tag (*vrops:vm_summary). (In this example, vrops name is used as a label to identify VMware vROps extension and it's tags. The label is defined while adding the extension in cfxdx configuration file or through UI.)
1
tag *vrops:vm_summary
Copied!
Example 1: Sort the selected column. (ascending order)
Get the data from VMware vROps VM Summary tag (*vrops:vm_summary) which includes some of the below columns, sort the data by 'datastore' column.
Column Names:
    guest_hostname
    guest_ip_address
    guest_full_name
    datastore
    ...
Below command queries the data from vROps vm_summary tag and sorts the data by column name 'datastore' in ascending order. (when 'order' (optional) param is not specified, it sorts in ascending order by default).
1
data --> dm:sort columns = 'datastore'
Copied!
Example 2: Sort the selected column. (descending order)
Get the data from VMware vROps VM Summary tag (*vrops:vm_summary) which includes some of the below columns, sort the data by 'datastore' column.
Column Names:
    guest_hostname
    guest_ip_address
    guest_full_name
    datastore
    ...
Below command queries the data from vROps vm_summary tag and sorts the data by column name 'datastore' in descending order.
1
data --> dm:sort columns = 'datastore' & order = 'descending'
Copied!
Example 3: Sort the selected multiple columns. (descending order)
Get the data from VMware vROps VM Summary tag (*vrops:vm_summary) which includes some of the below columns, sort the data by 'guest_full_name' and 'datastore' columns.
Column Names:
    guest_hostname
    guest_ip_address
    guest_full_name
    datastore
    ...
Below command queries the data from vROps vm_summary tag and sorts the data by both column names 'guest_full_name' and 'datastore' in descending order.
1
data --> dm:sort columns = 'datastore,guest_full_name' & order = 'descending'
Copied!
Last modified 7mo ago
Copy link