→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Kreg
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
FYI: there is now a detailed database dictionary that explains what each table and field stores.

View solution in original post

5 REPLIES 5
Susan_A
Lansweeper Alumni
FYI: there is now a detailed database dictionary that explains what each table and field stores.
Hemoco
Lansweeper Alumni
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
Engaged Sweeper II
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
Lansweeper Alumni
Model information is stored in tblAssetCustom.Model, not in tblComputersystem.
Kreg
Engaged Sweeper II
Help please 🙂