Forum Discussion

Novice I

3 years ago

Solved

I'm copying and pasting into excel to sort....:(

I'm copying and pasting into excel to sort....:(

alex_carver
3 years ago
```> purehost monitor --sort 'write_bytes_per_sec' Name Time B/s (read) B/s (write) op/s (read) op/s (write) us/op (read) us/op (write) ac-esxi-a-12 2023-01-17 1956 UTC 3.00K 512.00B 5.00 1.00 110 150 ac-esxi-b-09 2023-01-17 1956 UTC 0.00 4.00K 0.00 1.00 0 177 ac-esxi-a-01 2023-01-17 1956 UTC 0.00 8.00K 0.00 2.00 0 285 ac-esxi-a-08 2023-01-17 1956 UTC 208.47K 16.50K 56.00 33.00 123 163 ac-esxi-a-06 2023-01-17 1956 UTC 142.98K 20.00K 53.00 34.00 142 178```

alex_carver
Novice I
3 years ago
```> purehost monitor --raw name time read_bytes_per_sec write_bytes_per_sec reads_per_sec writes_per_sec usec_per_read_op usec_per_write_op ac-esxi-a-01 2023-01-17 1913 UTC 20989 512 14 1 129 98```
alex_carver
Novice I
3 years ago
If I remember right, if you do a --raw, you get the column names, then you can sort by the given column.
alex_carver
Novice I
3 years ago
```> purehost monitor --sort 'write_bytes_per_sec' Name Time B/s (read) B/s (write) op/s (read) op/s (write) us/op (read) us/op (write) ac-esxi-a-12 2023-01-17 1956 UTC 3.00K 512.00B 5.00 1.00 110 150 ac-esxi-b-09 2023-01-17 1956 UTC 0.00 4.00K 0.00 1.00 0 177 ac-esxi-a-01 2023-01-17 1956 UTC 0.00 8.00K 0.00 2.00 0 285 ac-esxi-a-08 2023-01-17 1956 UTC 208.47K 16.50K 56.00 33.00 123 163 ac-esxi-a-06 2023-01-17 1956 UTC 142.98K 20.00K 53.00 34.00 142 178```
jjprachyl
Novice I
3 years ago
u da man ty