→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
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

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now