View model computer ?

[Kreg]

Hi there,
I've make a very basic query to show :
- AssetName
- Username
- Location
- Manufactur
...
And I want to show the moodel of computer.
I don't understand why but I can't find the model in table tblcomputersystem

Here is my query :

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName,
  tblAssets.AssetID,
  tblAssets.Username,
  tsysIPLocations.IPLocation,
  tblADusers.Firstname,
  tblADusers.Lastname,
  tblOperatingsystem.Caption,
  tblAssets.Lastseen,
  tblBIOS.Manufacturer,
  tblBIOS.SerialNumber
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
    tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
  Left Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Order By tsysIPLocations.IPLocation

Lansweeper version 5.0.0.41

Tks,
Kreg

[Susan_A · Accepted solution]

FYI: there is now a detailed database dictionary that explains what each table and field stores.

[Hemoco]

You don't need to use SQL Server Management Studio, as you can build reports using the Lansweeper report builder. If you are having trouble locating a particular field, please contact support@lansweeper.com

[Kreg]

Oh yes ! Just percfect... Thank you!

Is there a way to have a simple diagram of the database ?
Or simply the good way is to browse the DB with SQL Server Management Studio ?

Tks,
Kreg

[Hemoco]

Model information is stored in tblAssetCustom.Model, not in tblComputersystem.

[Kreg]

Help please 🙂