Department Help

[rich_martinez]

Good Afternoon,

I would like to see the departments that computers belong to. In the report created below the department field is blank. What am I doing wrong?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.Lastseen,
tblAssetCustom.Warrantydate,
tblAssetCustom.Department,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1

[Susan_A · Accepted solution]

The tblAssetCustom.Department field doesn't contain scanned data; it's reserved for manual data insertion. Unless you manually add data to the field, it will be empty. Be sure to use the database dictionary if you're unsure what a specific field stores.

If you are trying to query the Department attribute from Active Directory: this attribute is currently only scanned for users unfortunately, not computers.