→ 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: 
chaley
Engaged Sweeper
I am trying to build a report to help us identify all workstations in our environment. I need to also add all workstations that are getting the RPC error. When I try to add it, I only get the devices with the error.

Thank you for your help
Charles


I am currently needing the the following fields:

Computer
Domain
Description
Username
Userdomain
Model
Manufacturer
Serial
IP Address
Lastseen
OSname
SP
MaxClockSpeed
NrOfProcessors
CPU
Memory
VideoProcessor
DeviceID



I am using the following code:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.Compimage As icon, tblComputers.Domain, tblComputers.Description,
tblComputers.Username, tblComputers.Userdomain, tblComputerSystemProduct.Name
As Model, tblComputerSystemProduct.Vendor As Manufacturer,
tblComputerSystemProduct.IdentifyingNumber As Serial, tblComputers.LastknownIP
As [IP Address], tblComputers.Lastseen, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.MaxClockSpeed, web40ProcessorCapacity.NrOfProcessors,
web40ProcessorCapacity.CPU, web40CorrectMemory.Memory,
tblVideoController.VideoProcessor, tblVideoController.DeviceID
From tblComputers Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Left Outer Join
web40ProcessorCapacity On tblComputers.Computername =
web40ProcessorCapacity.Computername Left Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername
Where tblComputerSystemProduct.Name <> 'VMware Virtual Platform' And
tblVideoController.DeviceID = 'VideoController1' And tblDiskdrives.Caption =
'c:'
Order By tblComputers.Computername
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
When adding tblerrors to your query, you must right-click on the connection between tblComputers and tblerrors and check "Select all rows from tblComputers" to ensure that machines without errors are included in the report as well.

Please try the report below instead.
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.Compimage As icon, tblComputers.Domain, tblComputers.Description,
tblComputers.Username, tblComputers.Userdomain, tblComputerSystemProduct.Name
As Model, tblComputerSystemProduct.Vendor As Manufacturer,
tblComputerSystemProduct.IdentifyingNumber As Serial, tblComputers.LastknownIP
As [IP Address], tblComputers.Lastseen, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.MaxClockSpeed, web40ProcessorCapacity.NrOfProcessors,
web40ProcessorCapacity.CPU, web40CorrectMemory.Memory,
tblVideoController.VideoProcessor, tblVideoController.DeviceID,
tblerrors.CFGname, tblerrors.ErrorText, tblerrors.Lastchanged
From tblComputers Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Left Outer Join
web40ProcessorCapacity On tblComputers.Computername =
web40ProcessorCapacity.Computername Left Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Left Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername
Where tblComputerSystemProduct.Name <> 'VMware Virtual Platform' And
tblVideoController.DeviceID = 'VideoController1' And tblDiskdrives.Caption =
'c:'
Order By tblComputers.Computername

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
When adding tblerrors to your query, you must right-click on the connection between tblComputers and tblerrors and check "Select all rows from tblComputers" to ensure that machines without errors are included in the report as well.

Please try the report below instead.
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.Compimage As icon, tblComputers.Domain, tblComputers.Description,
tblComputers.Username, tblComputers.Userdomain, tblComputerSystemProduct.Name
As Model, tblComputerSystemProduct.Vendor As Manufacturer,
tblComputerSystemProduct.IdentifyingNumber As Serial, tblComputers.LastknownIP
As [IP Address], tblComputers.Lastseen, Web40OSName.OSname, Web40OSName.SP,
web40ProcessorCapacity.MaxClockSpeed, web40ProcessorCapacity.NrOfProcessors,
web40ProcessorCapacity.CPU, web40CorrectMemory.Memory,
tblVideoController.VideoProcessor, tblVideoController.DeviceID,
tblerrors.CFGname, tblerrors.ErrorText, tblerrors.Lastchanged
From tblComputers Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Left Outer Join
web40ProcessorCapacity On tblComputers.Computername =
web40ProcessorCapacity.Computername Left Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Left Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername
Where tblComputerSystemProduct.Name <> 'VMware Virtual Platform' And
tblVideoController.DeviceID = 'VideoController1' And tblDiskdrives.Caption =
'c:'
Order By tblComputers.Computername