Computer Location and Department from AD

[mds81]

When Lansweeper scans/adds new computers to its database it doesn't populate/update the Custom fields 'Location', 'Building' or 'Department' from Active Directory.

I have these entered in AD and it would be great if I didn't have to manually update them in Lansweeper.

Is there a way to do this I have overlooked?

Ps: IP Address Location is working fine, I am just looking for the additional functionality for reporting.

Thanks!

[mds81]

Yep that did the trick, thanks very much 🙂

[Hemoco]

AD 'Building' and 'Department' info is not currently scanned by Lansweeper, 'Location' info is. For an overview of AD fields scanned by Lansweeper, please have a look at tblADComputers and tblADusers within the Lansweeper report builder. The report builder can be found in the Lansweeper configuration console under Reports & Alerts\Report Builder.

You can use the script below to insert values from tblADComputers.Location into tblCompCustom.Location (location custom field) as well. Copy and paste the script into the Lansweeper configuration console under Lansweeper\Database Scripts and hit the "Execute sql script" button.

UPDATE tblCompCustom
SET Location = tblADComputers.Location
FROM tblCompCustom INNER JOIN
tblADComputers ON tblCompCustom.Computername = tblADComputers.Computername