help with report with User name, Cost Center, computer Name Departamen

[matias_marquez]

Hi,

I need to make a report with help with report with User name, Cost Center, computer Name Departament and direct Manager.
can somebody help me? I can´t find everything.

thx a lot

Matias Marquez

[Susan_A · Accepted solution]

I've included a sample report below, which you can add to your Lansweeper installation by following these instructions. I didn't include "cost center", as I'm not sure which database field you're referring to with this.

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblADusers.Department,
  tblADObjects.sAMAccountName As Manager,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
  Left Join tblADObjects On tblADObjects.ADObjectID =
    tblADusers.ManagerADObjectId
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName