Disk information

[Pollak]

Is there away to get the used capacity of more than one computer in a report?



Please advise,
Niles

[afinetycon]

Sorry for hijacking your post, but is there a way to see on servers
the number of disks / what raid their in / what size they are
in a report?? or is this a wish list sort of deal.

[Hemoco]

afinetycon wrote:
Sorry for hijacking your post, but is there a way to see on servers
the number of disks / what raid their in / what size they are
in a report?? or is this a wish list sort of deal.

RAID information is not scanned. A general disk report can be seen below.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblDiskdrives.Caption,
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
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where Ceiling(tblDiskdrives.Size / 1024 / 1024) <> 0 And tblAssetCustom.State =
1 And tblDiskdrives.DriveType = 3 And tblComputersystem.Domainrole > 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblDiskdrives.Caption

[Hemoco]

You can create a new report, copy the sql from the other report and remove the "where" conditions

[Pollak]

Yes, but this only shows workstations and/or servers that are below the 1Gb limit. I am looking for a way to either display or report used space on all workstations and/or servers.


Thank you,
Niles

[Hemoco]

See this built-in report as an example: http://www.lansweeper.com/demo/default.aspx?item=cust&det=web40repHDDFreeServers&title=Disk%3a+Servers+less+than+1+GB+free+HD