Search via uploaded list

[crowbox]

Hello,

Quick question: I have a csv list of Asset names of about 100 different machines. Is there any way for me to upload this list to LS and do a report on them (list by their Asset names, etc.)? Or, even just cut/paste the names into some sort of report query?

Thanks.

[Karel_DS · Accepted solution]

There is no immediate option for this, however you could try the following. This is assuming all names are in separate rows.

• Open your file in Excell, or import its data (with all names in column A)
• Combine all names by putting the following in column B1 and respectively B2, then dragging B2 down the entire column:
  • ="SELECT * FROM tblAssets WHERE AssetName = "&A1
  • =B1&" OR AssetName = "&A2
• The last cell should now have your required query, which you can use to make a custom report

Example:
___A___________________________B_____________________________________________
lan-001``````="SELECT * FROM tblAssets WHERE AssetName = '"&A1&"'"
lan-002``````=B1&" OR AssetName = '"&A2&"'"
lan-003``````SELECT * FROM tblAssets WHERE AssetName = 'lan-001' OR AssetName = 'lan-002' OR AssetName = 'lan-003'