Never Scanned OS error report

[SBHC]

I have a need to pull a report for the workstations & servers that Lansweeper is failing to run on. I need to be able to run a report that can list the error(s) that are causing Lansweeper to not inventory the device.

I can see the "errors" if I look at the devices individually, but because I have over 500 of of them I would like to run a report and hand it over to our desktop support team for them to "go and fix" the problems.

I know that the errors can be caused by; RPC issues, DCOM issues, DHCP issues, remote registry administration issues, etc., but I need a way to determine "easliy" which machines are having which error(s).

Thanks

[SBHC]

Works great... Thank you and keep up the good work.

[Hemoco]

try this:

SELECT      TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblerrors.CFGname, dbo.tblerrors.ErrorText, 
                        dbo.tblerrors.Lastchanged
FROM          dbo.tblComputers INNER JOIN
                        dbo.tblerrors ON dbo.tblComputers.Computername = dbo.tblerrors.Computername
ORDER BY dbo.tblerrors.Lastchanged DESC, dbo.tblComputers.Computername