Need a report to list all workstations, even those with RPC errors

[chaley]

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

[Hemoco · Accepted solution]

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