→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Macman
Engaged Sweeper II
Is there a document in existence which maps Fields and Tables to fields within the LANSweeper user interface?

For example, if I wanted to run a report listing the Manufacturers of Assets, how could I easily find out which table and field to include in the report?

Hope my question makes sense.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
FYI for everyone: a database dictionary was added in Lansweeper 5.2. More information can be found here.

View solution in original post

2 REPLIES 2
Susan_A
Lansweeper Alumni
FYI for everyone: a database dictionary was added in Lansweeper 5.2. More information can be found here.
Hemoco
Lansweeper Alumni
Hi,

Currently we do not have a database dictionary but we are working on one.

You can find an example report down here:
Select Top 1000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Manufacturer
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID