Need one single report for free disk space in c: drive only

[SEC_ALERTS]

Hi Team,

We need one single report of the free disk space of c: drive only in below format.

Computer name
IP address
Total Size
Free space
Last scan date
Domain

Thanks in Advance!!

[RCorbeil]

You can find the details of what you're looking for in the database documentation. There's a link to it at the top of the page when you open the report editor.

WHERE
  tblDiskdrives.Caption Like '%c%'                           -- drive caption contains "C" (caption is C:, D:, etc.)
  AND Ceiling(tblDiskdrives.Freespace / 1024 / 1024) < 1024  -- free space < 1024 MB (aka 1 GB)
  AND Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0         -- drive is not empty
  AND tblAssetCustom.State = 1                               -- asset is active
  AND tblDiskdrives.DriveType = 3                            -- local disk drive

[William382]

RC62N wrote:
You can find the details of what you're looking for in the database documentation. There's a link to it at the top of the page when you open the report editor.

WHERE
  tblDiskdrives.Caption Like '%c%'                           -- drive caption contains "C" (caption is C:, D:, etc.)
  AND Ceiling(tblDiskdrives.Freespace / 1024 / 1024) < 1024  -- free space < 1024 MB (aka 1 GB)
  AND Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0         -- drive is not empty
  AND tblAssetCustom.State = 1                               -- asset is active
  AND tblDiskdrives.DriveType = 3                            -- local disk drive

That was fast! Thank you!

[SEC_ALERTS]

Thanks for your reply!!!

[Hemoco]

Please use the report below.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where tblDiskdrives.Caption Like '%c%' And Ceiling(tblDiskdrives.Freespace /
1024 / 1024) < 1024 And Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And
tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]

[William382]

Lansweeper wrote:
Please use the report below.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where tblDiskdrives.Caption Like '%c%' And Ceiling(tblDiskdrives.Freespace /
1024 / 1024) < 1024 And Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And
tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]

Super old post, what do I need to do to change the report size to something custom?

[SEC_ALERTS]

Thanks a lot for your reply.

In addition to this can your please provide the report for
All Workstations and server less than 1GB free in c: drive only

[Hemoco · Accepted solution]

Please use the report below.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblDiskdrives.Caption As [Disk],
Ceiling(tblDiskdrives.Freespace / 1024 / 1024) As FreeMB,
Ceiling(tblDiskdrives.Size / 1024 / 1024) As TotalMB
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Where tblDiskdrives.Caption Like '%c%' And Ceiling(tblDiskdrives.Size / 1024 /
1024) <> 0 And tblAssetCustom.State = 1 And tblDiskdrives.DriveType = 3
Order By tblAssets.Domain,
tblAssets.AssetName,
[Disk]