Device description from AD

[ChadWare]

Hi Kids,

I am wanting to generate a report listing all AD device descriptions for users PC's. Any assistance would be much appreciated.

Thanks

[ChadWare]

Much thanks to everyone! This topic appears to be solved.

[Nick_VDB]

The report that MikeMc gave, gives back the description that is stored in AD. The other description field that is found on assets can be found in the tblAssets table in the description field.

[ChadWare]

Thanks for the response MikeMc

I am trying to return the value for AD Description but this returns PC names. When we add a PC to AD we populate the description field as well as naming the device. The AD description is visible on the PC summary page within LANsweeper but I can not figure out how to return that specific field within a report.

[MikeMc · Accepted solution]

This should get you started.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblADComputers.Description
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblADComputers On tblADComputers.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName