Informationreport

[itadministratio]

Hey! I'm trying to make a report that shows the following: AssetName, Model, Manufacturer, SerialNumber, SystemSKU, Description (from AD) and Last Login (Displayname). The problem is that it does not show MAC computers when Description and Displayname are included. What have I done wrong?

"
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssetCustom.Serialnumber,
tblAssetCustom.SystemSKU,
tblADComputers.Description,
tblADusers.Displayname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADComputers.Description <> tblADusers.Displayname
Where (tblAssets.AssetName Like 'SUB%') Or
(tblAssets.AssetName Like 'SUS%')

"

[RCorbeil · Accepted solution]

The descriptions of tblADUsers and tblADComputers in the database documentation are clear about their storing Windows-domain users' and computers' attributes. Try replacing the INNER JOINs on the tblADxxx tables LEFT JOINs.

[AZHockeyNut]

start by removing the where clause. does that return data (it did for me)
then it is likely in your where condition (s)
If you can provide some examples of asset names you want in the report and some that you do not want in (they can be fake ones that met your criteria) then I can probably help you more.