→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎07-03-2012 09:21 AM
Select Top 1000000 tblcomputers.Computername, tblcomputers.ComputerUnique,
Web40OSName.OSname, Web40OSName.Compimage As icon,
tblComputerSystemProduct.Vendor, tblComputersystem.Model As [Model Number],
tblOperatingsystem.TotalVisibleMemorySize As RAM
From tblComputersystem Inner Join
tblcomputers On tblComputersystem.Computername = tblcomputers.Computername
Inner Join
web40ActiveComputers On tblcomputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblcomputers.Computername Inner Join
tblOperatingsystem On tblcomputers.Computername =
tblOperatingsystem.Computername Inner Join
tblComputerSystemProduct On tblcomputers.Computername =
tblComputerSystemProduct.Computername
Where tblComputersystem.Domainrole > 1
Order By tblcomputers.Computer
Select Top 1000000 tblcomputers.Computername, tblcomputers.ComputerUnique,
Web40OSName.OSname, Web40OSName.Compimage As icon,
tblComputerSystemProduct.Vendor, tblComputersystem.Model As [Model Number],
tblOperatingsystem.TotalVisibleMemorySize As RAM, tblPROCESSOR.Name
From tblComputersystem Inner Join
tblcomputers On tblComputersystem.Computername = tblcomputers.Computername
Inner Join
web40ActiveComputers On tblcomputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblcomputers.Computername Inner Join
tblOperatingsystem On tblcomputers.Computername =
tblOperatingsystem.Computername Inner Join
tblComputerSystemProduct On tblcomputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblPROCESSOR On tblcomputers.Computername = tblPROCESSOR.Computername
Where tblComputersystem.Domainrole > 1
Order By tblcomputers.Computer
‎07-04-2012 08:26 AM
‎07-03-2012 04:42 PM
Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, Web40OSName.OSname, Web40OSName.Compimage As
icon, tblComputerSystemProduct.Vendor, tblComputersystem.Model As
[Model Number], web40CorrectMemory.Memory, tblPROCESSOR.Name,
tblPROCESSOR.NumberOfLogicalProcessors, tblPROCESSOR.NumberOfCores,
tblDiskdrives.Caption, Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 /
1024 As numeric) As [Disk Free], Cast(Cast(tblDiskdrives.Size As bigint) /
1024 / 1024 As numeric) - Cast(Cast(tblDiskdrives.Freespace As bigint) /
1024 / 1024 As numeric) As [Disk Used]
From tblComputersystem Inner Join
tblComputers On tblComputersystem.Computername = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername
Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername
Where tblComputersystem.Domainrole > 1 And Cast(Cast(tblDiskdrives.Size As
bigint) / 1024 / 1024 As numeric) <> 0
Order By tblComputers.ComputerUnique, tblDiskdrives.Caption
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now