active directory computer attributes "whenCreated" report

[CityAdmin2050]

I would like to create a report that includes the active directory computer attributes "whenCreated". I can find it under the active directory user attributes (tblADusers.whenCreated) but not for computer (tblADComputers.whenCreated). Is this possible to do so we can see when our computers were first installed?

[Mister_Nobody]

Try this:

Select Distinct Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblassets.OScode,
  tblassets.Userdomain,
  tblassets.Username,
  tblOperatingsystem.Caption,
  tblOperatingsystem.InstallDate,
  tblassets.Firstseen,
  tblassets.Lastseen
From tblassets
  Left Join tblOperatingsystem On tblassets.AssetID = tblOperatingsystem.AssetID
Order By tblOperatingsystem.InstallDate Desc

[CityAdmin2050]

Thanks, this is a solid script. I should have mentioned that we image our computers. If we ran a report to assess the operating system install date we would have the same date for all the computers that were using the same image.

Does anyone know if Lansweeper even scans the AD Computers attributes like tblADComputers.whenCreated? Can I create a custom scan to include tblADComputers.whenCreated?

[Mister_Nobody]

If you prepare image with sysprep then you will have current install date.