- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hello everyone,
I have a report that reads a series of devices that we manually set,
and we obtain a series of data.
Could we import that data from a CSV file?
For example: \\Sever-PS\c$\Program Files (x86)\Lansweeper\Service\Import\Data.CSV
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
If by importing, do you mean creating a new asset record within Lansweeper itself? Lansweeper has an import assets feature that requires specific fields to be completed in order to import data from a CSV file. From Lansweeper Classic, you would:
- Go at Assets
- Select Import Assets
- Download the import template (to show what fields would be required. Note that not all fields are specifically required.)
- Complete the form and then upload to Lansweeper.
- Select "Validate Import" to verify the information has no issues (missing fields that are required, duplicate entries, etc.)
- Make any corrections and revalidate until you're given the all clear, and then select Import Assets to complete the upload.
There area ways to inject other data into the tables, however it's not a supported feature and I am not knowledgeable enough on SQL injections to offer that type of solution. Also, if you are using Lansweeper Sites, I am unsure if the ability to bulk upload assets is an enabled feature for the cloud version yet, so we do all of our manual imports through Lansweeper Classic.
Union Home Mortgage's "Lansweeper Guy"
------------------------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Lo siento, pero puede que no me haya explicado bien.
Lo que estoy tratando de hacer es para un informe que creé que informa de una serie de datos que necesito. Tengo que ejecutarlo periódicamente en diferentes computadoras, y por lo general son grupos variados pero numerosos. Entonces, en lugar de escribir la instrucción In( x, y, z, ....), coloco esa lista de computadoras en una tabla CSV y hago que SQL acceda a esa tabla y lea los datos.
Asà que mi pregunta es, ¿se pueden leer datos externos del asistente de SQL?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Sorry, but I may not have explained myself well.
What I'm trying to do is for a report I created that reports a series of data I need. I have to run it periodically on different computers, and they're usually varied but numerous groups. So instead of writing the In( x, y, z, ....) statement, I put that list of computers in a CSV table, and have the SQL access that table and read the data.
So my question is, can you read external data from the SQL wizard?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
That would be more along the lines of SQL injection from what I understand and I am not very familiar with how to do this and integrate data into Lansweeper using that method.
Union Home Mortgage's "Lansweeper Guy"
------------------------------------------------
