Need to find some fields

[lococola]

Hi,

i need to create a single report that contains several fields but I'm quite unfamiliar with SQL and the Report Builder doesn't tell me in wchich tables I can find the fields I'm looking for. I have found these so far:

PC Name - Manufacturer - Model - Caption - IP Address

Now I need to add:

Last User - Software (specifically: Office, all possible versions and whether or not it's installed) - Office Serial.

Can anyone help me out? Or point me in the right direction?

Thanks!

[Hemoco · Accepted solution]

User: tblAssets.Username and tblAssets.Userdomain
Software: tblSoftware and tblSoftwareUni
Product keys: tblSerialNumber

Note that you cannot include software and product key information in a single report, as these are stored in different tables.

[lococola]

Using Lansweeper 5 Premium btw.