8 Krypton

mminfo query

Jump to solution

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

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
8 Krypton

Re: mminfo query

Jump to solution

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"

6 Replies
Highlighted
mfriedma
6 Indium

Re: mminfo query

Jump to solution

Hello Samuel,

Should be:

mminfo -q "client=clientname,savetime=mm/dd/yyyy" -r "ssid,totalsize,savetime,volume,ssretent"

Regards,

Mickey Friedman

0 Kudos
8 Krypton

Re: mminfo query

Jump to solution

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

0 Kudos
8 Krypton

Re: mminfo query

Jump to solution

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"

8 Krypton

Re: mminfo query

Jump to solution

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?

0 Kudos
8 Krypton

Re: mminfo query

Jump to solution

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).

0 Kudos
8 Krypton

Re: mminfo query

Jump to solution

Thanks Hrvoje. I think got it as you suggested.. Hopefully I am getting report for 29th. Thanks again

0 Kudos