This post is more than 5 years old
2 Intern
•
136 Posts
0
3069
mminfo query
Hi All,
I want to query SSID details for specific client on specific date.
mminfo -q "client=clientname,savetime>=last month" -r "ssid,totalsize,savetime,volume,ssretent"
This query giving for all ssid with last month save time. For specific date?
Thanks,
Samuel Thomas
ble1
2 Intern
2 Intern
•
14.3K Posts
1
September 6th, 2015 07:00
Could be format of savetime - I do not know which format is used on your server, but if you do some open query you will see it in output.
Just as you did before with > (or =>), you can add < (or<=) so assuming your ssid was written on 29th of August, you can do something like (assuming date format is correct):
mminfo -q "client=kwtuatvcpap001.mha.local,savetime=>08/29/2015 00:00:01,savetime<=08/29/2015 23:59:59" -r "ssid,totalsize,savetime,volume,ssretent,ssbrowse"
mfriedma
20 Posts
0
September 6th, 2015 03:00
Hello Samuel,
Should be:
mminfo -q "client=clientname,savetime=mm/dd/yyyy" -r "ssid,totalsize,savetime,volume,ssretent"
Regards,
Mickey Friedman
tsamuel0905
2 Intern
2 Intern
•
136 Posts
0
September 6th, 2015 04:00
Not working...
# mminfo -q "client=kwtuatvcpap001.mha.local,savetime=08/29/2015" -r "ssid,totalsize,savetime,volume,ssretent,ssbrowse"
6095:mminfo: no matches found for the query
tsamuel0905
2 Intern
2 Intern
•
136 Posts
0
September 7th, 2015 12:00
Perfect this one working... Thanks..
But Still need querying for specific date...
As suggested, I used, "savetime=>08/28/2015 00:00:01,savetime<=08/30/2015"
I got the output which includes 28 & 30 also... Only for 29?
ble1
2 Intern
2 Intern
•
14.3K Posts
0
September 7th, 2015 15:00
For 29th only use query as I showed you before (note that I defined start and end of the day as 00:00:01 and 23:59:59).
tsamuel0905
2 Intern
2 Intern
•
136 Posts
0
September 10th, 2015 23:00
Thanks Hrvoje. I think got it as you suggested.. Hopefully I am getting report for 29th. Thanks again