AD DistinguishedName of Computer object

[elKastr0nom]

How would I go about adding one of these fields to my current report?

Here is my current report:

Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.Domain,
tblassets.Username,
tblassetcustom.PurchaseDate,
tblassetcustom.Warrantydate,
tblassets.Mac,
tblassetcustom.Manufacturer,
tblassetcustom.Model,
tblassetcustom.Serialnumber,
tsysIPLocations.IPLocation
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tsysIPLocations On tsysIPLocations.LocationID =
tblassets.LocationID
Where tsysassettypes.AssetTypename = 'Windows'

[Andy_Sismey]

You just want to add this line to your select:

  'CN=' + tblassets.AssetName + ',' + tblADComputers.OU As DN

[elKastr0nom]

That reports provides "no results found".

[Andy_Sismey]

You could do it this way :

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.Domain,
  tblassets.Username,
  tblassetcustom.PurchaseDate,
  tblassetcustom.Warrantydate,
  tblassets.Mac,
  tblassetcustom.Manufacturer,
  tblassetcustom.Model,
  tblassetcustom.Serialnumber,
  tsysIPLocations.IPLocation,
  'CN=' + tblassets.AssetName + ',' + tblADComputers.OU As DN
From tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Inner Join lansweeperdb.dbo.tsysIPLocations On tsysIPLocations.LocationID =
      tblassets.LocationID
  Inner Join lansweeperdb.dbo.tblADComputers On tblassets.AssetID =
      tblADComputers.AssetID
Where tsysassettypes.AssetTypename = 'Windows'