Server Disk Space low

[dennisatsub]

Is there a way to have Lansweeper notify me via company email (exchange server 2010) that a server has gone below 5 GB (for example) free space on the hard drive?

thanks in advance!

Dennis

[dennisatsub]

FYI,

This is all I did to the ...less than 1 GB... report to turn it into ..5 GB.."

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, Web40OSName.OSname, tblOperatingsystem.Description, tblDiskdrives.Caption, Cast(Cast(tblDiskdrives.Freespace As bigint) / 5120 / 5120 As numeric) As Free, Cast(Cast(tblDiskdrives.Size As bigint) / 5120 / 5120 As numeric) As [Total size], tblDiskdrives.Lastchanged As [Last changed], Web40OSName.Compimage As icon From tblComputers Inner Join tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 5120 / 5120 As numeric) < 5120 And Cast(Cast(tblDiskdrives.Size As bigint) / 5120 / 5120 As numeric) <> 0 And tblComputersystem.Domainrole > 5 And tblDiskdrives.DriveType = '3' Order By Cast(Cast(dbo.tblDiskdrives.Freespace As bigint) / 5120 / 5120 As numeric), dbo.tblDiskdrives.Caption

[dennisatsub]

Great! Seems pretty straight forward...I created a new report from the ...less than 1 GB free space" report and made that ...less than 5 GB free..."
I'm wondering then does LS scan EACH drive partition? I have a server with a C,D,E,F that I need to scan.

thanks!! Dennis

[Hemoco]

dennisatsub wrote:
Great! Seems pretty straight forward...I created a new report from the ...less than 1 GB free space" report and made that ...less than 5 GB free..."
I'm wondering then does LS scan EACH drive partition? I have a server with a C,D,E,F that I need to scan.

Lansweeper automatically scans all drives.

The report you've created however will not return any results, since you have opted to only include machines with a domain role higher than 5. (The highest domain role is 5.) To return only servers the domain role must be set to "higher than 1", to return workstations the domain role must be set to "lower than 2".

The current report only includes local drives as well and has some other issues.

Please have a look at the sample report below. It looks at all server disks and reports on the ones that are below 5GB. To change the size requirement, only change the number highlighted in bold.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.OSname, tblOperatingsystem.Description, tblDiskdrives.Caption,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
Free, Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As
[Total size], tblDiskdrives.Lastchanged As [Last changed],
Web40OSName.Compimage As icon
From tblComputers Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) <
5120 And Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <>
0 And tblComputersystem.Domainrole > 1
Order By Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric),
tblDiskdrives.Caption

[Hemoco]

This can be done by setting up report mailing. More info on report mailing can be found on page 91 of our online documentation.
The report builder contains a built-in report "Disk: Workstations less than 1 GB free HD" that you can modify to suit your needs.