Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi,
is it possible to get more than one measurepoint with one query (-C aggregate:user_writes,user_reads...) (this example didn,t work).?
i use this :
dfm perf retrieve -o file:aggrname -C aggregate:user_writes -M Month -s 3600
but i need all existig information like user_writes user_reads total_transfers.
Regards Martin
View By:
14 REPLIES 14
Highlighted
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
You should specify the counters in comma separated format as (-C aggregate:user_reads,aggregate:user_writes,aggregate:total_transfers).
Object name was missing before user_reads in you example.
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
One more thing is your command is wrong. It should be like dfm perf data retrieve -o <object_name> -C <counter_name> ...
You can see the usage details by using the command like
$dfm perf data retrieve help
NAME
retrieve -- This command allows you to extract the counter data
with supported statistical calculations on them.
SYNOPSIS
dfm perf data retrieve { [ -o object-name-or-id ... ] [ -C perf-counter ... ]
[ -V view-name ] }
[ -d duration ] [ -b start-time ] [ -e end-time ]
[ -M month ... ] [ -D weekday ... ] [ -T time-range ... ]
[ -m statistical-method [ -P percentile-value ]
[ -S data-advance-method ] ]
[ -s sample-rate ] [ -x output-format ] [ -R ]
Here it clearly specifies the object name need to be there in the dfm perf data retrieve command.
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
This is the output of my problem:
This worked
smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k -C aggregate:user_reads -M Sep -s 3600
Timestamp smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_reads
-------------------------------------------------------------------------------
2011-09-09 14:04:43 277.800
2011-09-09 15:04:43 175.867
.
.
This not:
smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k -C aggregate:user_reads,aggregate:user_writes -M Sep -s 3600
Error: Expected object:counter; found aggregate:user_reads,aggregate:user_writes.
And this Tables exists:
smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k -V "Aggregate Summary View" -M Aug -s 3600
Timestamp smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_reads
-------------------------------------------------------------------------------
No data available
Timestamp smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_writes
-------------------------------------------------------------------------------
No data available
Timestamp smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:cp_reads
-------------------------------------------------------------------------------
No data available
Timestamp smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:total_transfers
-------------------------------------------------------------------------------
No data available
So, the problem still exists.
Regards Martin
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
The 'No data available' error could be because you are asking for Aug month data and the perf data for 'Aggregate Summary View' by default stores 1 week data.
Can you please verify against Sep month ? Also, post the sampling rate and sampling duration for the 'aggregate' object of this host using 'dfm perf data describe' CLI
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
This should only a example for the existing tables.
This is the main problem:
smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k -C aggregate:user_reads,aggregate:user_writes -M Sep -s 3600
Error: Expected object:counter; found aggregate:user_reads,aggregate:user_writes.
All other things are only to explain.
Regards Martin
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hello,
when you specify the comma in between the counter name on the cli, still -C need to be there. Otherwise it will give you error
Correct syntax would be either
$ dfm perf data retrieve -o <object name> -C aggregate:user_reads, -C aggregate:user_writes -M Sep -s 3600
or
without comma separated cli,
$ dfm perf data retrieve -o <object -name> -C aggregate:user_reads -C aggregate:user_writes -M Sep -s 3600
Now try again.
Thanks,
Bipul
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
Ok. It works now - but --- now the next question . Is it possible tho put the output in two collums. Actual the output was generated sequentialy.
smc-vm-025:~ # dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k -C aggregate:user_reads -C aggregate:user_writes -M Sep -s 3600
Timestamp smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_reads
-------------------------------------------------------------------------------
2011-09-09 14:31:44 507.900
2011-09-09 15:31:44 220.283
.
.
Timestamp smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k:user_writes
-------------------------------------------------------------------------------
2011-09-09 14:31:44 507.900
2011-09-09 15:31:44 220.283
.
.
Regards Martin
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
OK. I found the solution.
dfm perf data retrieve -o smc-na001-pb.smc.xxx.net:f1_aggr0_mir_15k -C aggregate:user_reads -C aggregate:user_writes -M Sep -s 3600 -x TimeIndexed
is what i need.
Thanks for your great support
Martin
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hello,
"-x TimeIndexed" will give you the column by column output, but it ignores the second information on the time column of the CLI output.
Thanks,
Bipul