About this task
InfiniShell provides options that help the user to control the way query result are displayed.
Filtering a query
InfiniBox queries can be filtered, so that only specific entities will be returned. The filtering options of each query are available through running help on the query command: typing the command and pressing TAB.
For example:
You can filter the volume query by:
- Name - the name of the volume
- Pool - the pool that the volume belongs to
- CG - the consistency group that the volume is a member of
- Mapped, thin, write protected - volumes attributes
vol.query [name] [pool] [mapped] [thin] [--columns] [--format] [-d|--xdebug] [cg] [unit] [write_protected] [--detailed] [--sort] [--grep] [-y|--yes]
Filtering the query result by any string of characters
Filtering by a string of characters
Example: vol.query --grep=replica
Filtering for query results that do not include a specific string
Examples:
- vol.query --grep=replica
- vol.query --inverted-grep=replica
Sorting the query
The query results can be sorted by the value of any of its fields.
Sorting by numerical value
Sorting the query results by used, from small to big.
vol.query --sort=used NAME THIN USED POOL vol_1 yes 980.02 MB replication-from-ibox1092 vol_2 yes 880.02 MB replica_from_ibox3008 vol_3 yes 763.69 MB replica_from_ibox3008 vol_4 yes 678.97 MB replica_from_ibox3008 ...
Sorting the query results by used, from big to small.
vol.query --sort=-used NAME THIN USED POOL vol_4 yes 678.97 MB replica_from_ibox3008 vol_3 yes 763.69 MB replica_from_ibox3008 vol_2 yes 880.02 MB replica_from_ibox3008 vol_1 yes 980.02 MB replication-from-ibox1092 ...
Sorting by alphanumerical value
Sorting the query results by volume name.
vol.query --sort=name NAME THIN USED POOL vol_1 yes 980.02 MB replication-from-ibox1092 vol_2 yes 880.02 MB replica_from_ibox3008 vol_3 yes 763.69 MB replica_from_ibox3008 vol_4 yes 678.97 MB replica_from_ibox3008 ...
Setting the displayed capacity unit
You can select the unit in which capacity is displayed.
vol.query unit= B, G, GB, GiB, T, TB, TiB or block B G GB GiB T TB TiB block
Selecting the displayed columns
Select the columns that will be displayed on the query result.
vol.query --columns=name,used,pool NAME USED POOL aixio001_1 0 aix aixio001_2 0 aix aixio001_3 0 aix aixio001_4 0 aix aixio001_5 0 aix aixio003_boot_1 0 aix aixio003_boot_2 0 aix aixio003_boot_3 0 aix aixio003_boot_4 0 aix aixio004-01 222.00 GB aix aixio004-02 444.00 GB aix aixio004-03 665.99 GB aix aixio004-04 887.96 GB aix ...
Setting the results format
You can select between tabular, CSV and JSON formats.
(For tabular format, run the query without the format option.)
CSV format
vol.query --format=csv NAME,THIN,SIZE,USED,ALLOCATED,TREE ALLOCATED,POOL,WP,MAPPED aixio001_1,no,500.00 GB,0,500.00 GB,0,aix,no,yes aixio001_2,no,500.00 GB,0,500.00 GB,0,aix,no,yes aixio001_3,no,500.00 GB,0,500.00 GB,0,aix,no,yes aixio001_4,no,500.00 GB,0,500.00 GB,0,aix,no,yes aixio001_5,no,500.00 GB,0,500.00 GB,0,aix,no,yes
JSON format
vol.query name=vol_fea63de9-6a2f-4f9d-8fa2-62aa34e6d855_replica --format=json
{
"command": "vol.query name=vol_fea63de9-6a2f-4f9d-8fa2-62aa34e6d855_replica --format=json",
"result": [
{
"allocated": "1.00 GB",
"mapped": "no",
"name": "vol_fea63de9-6a2f-4f9d-8fa2-62aa34e6d855_replica",
"pool": "replica_from_ibox3008",
"size": "1.00 GB",
"thin": "yes",
"tree_allocated": "0",
"used": "1.00 GB",
"write_protected": "no"
}
]
}
Displaying a detailed output
The detailed output displays more fields than the default tabular output.
vol.query name=vol_fea63de9-6a2f-4f9d-8fa2-62aa34e6d855_replica --detailed Name vol_fea63de9-6a2f-4f9d-8fa2-62aa34e6d855_replica Serial 742b0f000000bbb0000000000000414 Thin yes Size 1.00 GB Used 1.00 GB Allocated 1.00 GB Tree Allocated 0 Pool replica_from_ibox3008 Write Protected no Mapped no Ssd Cache yes Replication Role - Created At 2015-09-27 09:59:28 Updated At 2015-10-19 12:33:45
Comments