Disk free space report - specific clients

[sisman]

Hi, is it possible to generate report for disk space less than 20GB for F partition only on servers which name is ending with EF?

[sisman]

It seems that this is it!
Thank you, I will test this further...

[Hemoco]

try this:

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

[sisman]

I searched forum but didn't found anything helpful....