Lansweeper not seeing computer location information from Active Directory

[adecicco]

Our AD has all computer with locations listed however lansweeper doesnt appear to pick these up ?
We are using Lansweeper v5/0/0/69

Essentially we want to be able to understand where computer assets are using lansweeper reporting.

Thanks,
Angelo

[Hemoco]

Problem resolved through email. There are several Location fields in the Lansweeper database and the customer was looking at an incorrect one. To list the AD Location field, build a report that includes tblADComputers.Location. E.g.:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Location As LocationAssetCustom,
tblADComputers.Location As LocationAD,
tblADComputers.OU,
tblADComputers.Lastchanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID

[Hemoco]

Please contact support@lansweeper.com and provide us with:
- Program Files (x86)\Lansweeper\Service\Errorlog.txt, as present on your Lansweeper server.
- Screenshot of one problem machine's Lansweeper webpage.
- Output of the report below, preferably in Excel format.

Select * from tblADComputers

[adecicco]

Lansweeper wrote:
Please contact support@lansweeper.com and provide us with:
- Program Files (x86)\Lansweeper\Service\Errorlog.txt, as present on your Lansweeper server.
- Screenshot of one problem machine's Lansweeper webpage.
- Output of the report below, preferably in Excel format.

Select * from tblADComputers

Thanks.

Details have been emailed through as requested.

Regards,
Angelo