topic How do you calculate the total disk size in MB? in Splunk Search

How do you calculate the total disk size in MB?

jip31 — Fri, 23 Nov 2018 07:06:04 GMT

hello,

I use this query in order to calculate the remaining space in percent.

I also need to calculate the disk size from this source type.

How do I find the disk size from the counter Freespace and Free MB please?

index=perfom sourcetype=perfmon:logicaldisk | where Value <15 
| dedup host 
| eval time = strftime(_time, "%m/%d/%Y %H:%M") | eval Value = round(Value, 1). " %" | rename Value as Free_Space 
| table time host Free_Space | sort -Free_Space limit=10

Re: How do you calculate the total disk size in MB?

inventsekar — Fri, 23 Nov 2018 08:36:46 GMT

You can do eval Value= Value/1024/1024, that will be in MB, and one more Value/1024/1024/1024 will be GB.

index=perfom sourcetype=perfmon:logicaldisk | where Value <15 
 | dedup host 
 | eval time = strftime(_time, "%m/%d/%Y %H:%M") 
 | eval Value= Value/1024/1024
 | eval Value = round(Value, 1). " %" 
 | rename Value as Free_Space 
 | table time host Free_Space | sort -Free_Space limit=10

Re: How do you calculate the total disk size in MB?

jip31 — Fri, 23 Nov 2018 09:21:41 GMT

thanks but it's not what I want
i want to know if its possible to find the size disk in MB from the fcounter free space and free mb

Re: How do you calculate the total disk size in MB?

inventsekar — Fri, 23 Nov 2018 09:57:37 GMT

i want to know if its possible to find the size disk in MB from the fcounter free space and free mb /// i am not sure how to do that. if you let us know the logic, then we can write the query.