→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ismail
Engaged Sweeper II
Hi,

I added a few fields on the available report called "Server: All Servers"

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




Right now it shows:

Computer name, Domain, OS, vendor, server model number and ram.

When I add tblproccessor to show Proccessor name I get duplicate server names entries.

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



I'm looking to remove duplicate names while showing CPU Name. I would like to show number of processors, number of cores per processor and Disk Capacity available plus disk capacity Used on each server.


Thanks for your help in advance!

2 REPLIES 2
Ismail
Engaged Sweeper II
Perfect! Thanks.
Hemoco
Lansweeper Alumni
Please try the report below.

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