Qradar - how to monitor windows server disk space?

Posted on 2013-10-23
Medium Priority
Last Modified: 2014-05-21
Hello Qradar gurus!  Really need your help on this one. And before you respond --> I know there are many drive-space monitoring solutions out there! I want to utilize a system that I already own to monitor drive space and not introduce ...'yet another utility or process'.

Can someone tell me how to configure Qradar to monitor available hard drive space on a Windows 2003 Server?  

I know that the Windows Server System Event Log generates an event ID of 2013 when a disk is at or near capacity. Any way to use Qradar to look for that event and generate an email alert?
Question by:JohnArmstrong
  • 2
LVL 35

Expert Comment

by:David Todd
ID: 39596021

Is the windows event in sufficient time? That is, if memory serves me correctly, when there really is almost no available disk left. Wouldn't you want an alert for 20% free space or 10% free space?

I have a powershell script that stores these values in a SQL database, and I query that database each morning as part of my daily checks.


Author Comment

ID: 39631463
Hi David, What values are you pulling from Windows server?  Are you pulling the info using WMI and piping it into a dbase?
LVL 35

Accepted Solution

David Todd earned 2000 total points
ID: 39631675

Yes I'm using WMI

There are a couple of servers that WMI isn't responding on, so I filter them out of my list.

foreach( $s in Invoke-Sqlcmd -Query ‘select distinct ss.FQDN as ServerName from dbo.SQLServer ss where isWMIWorking = 1 and ( DateDecommissioned is null or DateDecommissioned > dateadd( day, datediff( day, 0, getdate()), 0 ))’ -Database SomeDatabase -ServerInstance SomeServer) {
    $d = Get-WmiObject -computername ( $s.ServerName ) Win32_LogicalDisk -filter "DriveType=3" | foreach { 
        add-member -in $_ -membertype noteproperty UsageDT $((Get-Date).ToString("yyyy-MM-dd HH:mm:ss")) 
        add-member -in $_ -membertype noteproperty SizeGB $([math]::round(($_.Size/1GB),2)) 
        add-member -in $_ -membertype noteproperty UsedGB $([math]::round((($_.Size - $_.FreeSpace ) /1GB ), 2 ))
        add-member -in $_ -membertype noteproperty FreeGB $([math]::round(($_.FreeSpace/1GB),2)) 
        add-member -in $_ -membertype noteproperty PercentUsed $([math]::round(((1 - [float]$_.FreeSpace/[float]$_.Size) * 100),2)) -passThru 
        } | Select UsageDT, SystemName, Caption, VolumeName, SizeGB, UsedGB, FreeGB, PercentUsed | out-DataTable       

Open in new window

out-DataTable is by Chad Miller


Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This blog will spread awareness about Dropbox. We have given the statements based upon our experience. Along with this, there is a section of some new plans that should be added in Dropbox this year. This will make the storage service enhanced from …
Data security in the cloud is very much like a security in an on-premises data center - only without costs for maintaining facilities and computer hardware.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question