→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kevinoie
Engaged Sweeper III
Would be really grateful if anyone can help with this report.. I need a report with the following: Computer, Manufacturer, Model, OS, SP, CPU, #Processors, Memory, IP, and Install date. I seem to be missing something in the SQL report builder and cant seem to figure it out.. Would be very very grateful for any assistance..
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
try this:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, Web40OSName.Compimage As icon,
tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name
As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
tblComputers.LastknownIP, tblOperatingsystem.InstallDate
From tblComputers Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername
Order By tblComputers.Computer

View solution in original post

4 REPLIES 4
kevinoie
Engaged Sweeper III
Thats exactly what I need. Thanks a million for your assistance. Much appreciated..
Hemoco
Lansweeper Alumni
try this:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, Web40OSName.Compimage As icon,
tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name
As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
tblComputers.LastknownIP, tblOperatingsystem.InstallDate
From tblComputers Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername
Order By tblComputers.Computer
kevinoie
Engaged Sweeper III
The problem is not with Lansweeper.. the problem is my lack of Knowledge. I can get most of the fields i need.. Its just the last couple i cant figure out where to find them.. I have been at this for the past 2 days..
Hemoco
Lansweeper Alumni
What exactly is the problem with the report builder?
Do you get a specific error?