Including non-scanned items

[MustQ]

Hello,

Is there a way to include items that exist in active directory but have not been scanned in a report? This way we can manually edit these details in the excel output?

I am running the base/built in "computer: system configuration overview" report.

Thanks

[MustQ]

Thanks!

[Hemoco]

Lansweeper only pulls computers into your database that it intends to scan. Active directory computers for which no scan attempts have been made are not present in the database and cannot be included in a report.

To include computers with scanning errors in the report Computer: System Configuration Overview, replace the report code with the one below.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, Web40OSName.Compimage As icon, tblComputers.Domain, Web40OSName.OSname, tblComputers.Description, tblComputers.Username, tblComputers.Userdomain, web40CorrectMemory.Memory As Memory, Cast(Cast(Cast(DerivedDisk.Size As bigint) / 1024 / 1024 / 1024 As numeric) As varchar) As [Disk size], web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU, tblComputerSystemProduct.Name As Model, tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.IdentifyingNumber As Serial, tblComputers.LastknownIP As [IP Address], tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate From tblComputers Left Outer Join web40ProcessorCapacity On tblComputers.Computername = web40ProcessorCapacity.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Inner 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 (Select tblDiskdrives.Computername, tblDiskdrives.Size, tblDiskdrives.Caption From tblDiskdrives Where tblDiskdrives.Caption = 'c:') DerivedDisk On DerivedDisk.Computername = tblComputers.Computername Order By dbo.tblComputers.Computername

[MustQ]

"If it exists in active directory but has never been scanned OR scanning resulted in an error".

[Hemoco]

Could you clarify what you mean by "have not been scanned". Are you referring to machines for which scan attempts have been made, but that are displaying scanning errors?