 Rank: Administration Groups: Administration, Premium Users
Posts: 10,007
|
Code: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], Web40OSName.Compimage As icon
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 Cast(Cast(dbo.tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <> 0
And dbo.tblDiskdrives.DriveType = '3'
Order By dbo.tblComputers.Computer, Cast(Cast(dbo.tblDiskdrives.Freespace As
bigint) / 1024 / 1024 As numeric), dbo.tblDiskdrives.Caption
|
