Creating a Historical Report of Disk Alerts

Anyone,

I'm trying to create a report that tells me each time over the past 60 days one of my Windows servers reported a volume with 95% or higher usage. Is that possible? If so, how would I go about it?

Find more posts tagged with

disk_space_alerts

writer

WMI

report

Accepted answers

mrxinu

If I followed all the criteria, this should do the trick. Open Report Writer and create an Advanced SQL report and dump this in the SQL tab:

select n.caption, v.caption, vu.datetime, vu.percentdiskused

from volumes v

join volumeusage vu on v.volumeid = vu.volumeid

join nodes n on n.nodeid = v.nodeid

where vu.datetime between dateadd(dd,-60,getdate()) and getdate()

and vu.percentdiskused >= 95

and v.volumetype = 'fixed disk'

and n.vendor = 'windows'

All comments

mrxinu

If I followed all the criteria, this should do the trick. Open Report Writer and create an Advanced SQL report and dump this in the SQL tab:

select n.caption, v.caption, vu.datetime, vu.percentdiskused

from volumes v

join volumeusage vu on v.volumeid = vu.volumeid

join nodes n on n.nodeid = v.nodeid

where vu.datetime between dateadd(dd,-60,getdate()) and getdate()

and vu.percentdiskused >= 95

and v.volumetype = 'fixed disk'

and n.vendor = 'windows'

aussery

Thanks! That worked.

mrxinu

You're very welcome.