Lansweeper Reports - user info from asset list

[mattdalessandro]

I have a large list of asset names in an excel spreadsheet and would like to run a report in Lansweeper giving me the general info for each of these assets, specifically the user/last user would be most useful.

Can someone help me out with a solution? It would be massively appreciated.

Thanks everyone

[RCorbeil]

If the list of asset names isn't too long, create your report incorporating the fields you want and use the WHERE clause to filter the results for only those asset names you want.

Where tblassets.AssetName In ('assetname1', 'assetname2', 'assetname3')

[mwrobo09]

Matt,

it may be easier to create a report in lansweeper that has asset name and all the fields you need to find, then export the full report to another excel table and do vlookups for the info you are looking to fill in on your list.