About
Careers
Support
Partners
Community
Contact
Product
Overview
IT Discovery
IT Inventory
IT Analytics
Features
Integrations
Use Cases
IT Asset Management
Cybersecurity
Active Directory Audit
Installing Software & Patches
Automated IT Inventory
Pricing
Resources
Support Knowledge Base
Videos
Testimonials
Vulnerability Updates
Patch Tuesday
Blog
Free Download
Lansweeper
»
Report Questions
»
Run Report on PCs from a list
Active Topics
Search
Join Now
Login
Notification
Error
OK
Run Report on PCs from a list -
Run Report on PCs from a list in a text file or excel file
Posted:
Friday, November 13, 2020 10:59:31 PM(UTC)
ShahM
Member
Original Poster
Posts: 1
0
Like
I need to run a detailed report on couple of hundred PCs. I have the host names in an excel and text file. These PC's are on the Lansweeper database.
How do I run a report against those PCs?
I did not see any option to run report based on text file or excel file.
Thank you!
#1
RC62N
Member
Posts: 494
posted:
11/16/2020 4:23:12 PM(UTC)
LANSweeper "reports" are just views; fixed queries stored in the database, not something you can run against a list without manually incorporating that list into the query.
If you have the full MS Office suite installed, you may find it simplest to create an ODBC connection to your LANSweeper database, put your list in an Access table and then create a query there based on it.
User Profile
View All Posts by User
View helpful posts
Active Discussions
Rest API for Scanning
by
Brian Smith
Last post:
Today
at 7:35:27 PM(UTC)
Language translation not working anymore
by
Florian
Last post:
Today
at 6:03:19 PM(UTC)
Use current user for scanning credentials?
by
pryan67
Last post:
Today
at 6:01:33 PM(UTC)
Bluetooth Info
by
FrankSc
Last post:
Today
at 5:42:59 PM(UTC)
Question about Scanning Assets and Password Encryption
by
FrankSc
Last post:
Today
at 5:23:05 PM(UTC)
How to enable HTTPS in ver 6.0.150.60
by
Duncan.Miles
Last post:
Today
at 1:11:19 PM(UTC)
INFO DateTimeService time refresh
by
miharix
Last post:
Yesterday
at 3:22:29 PM(UTC)
MS Edge Chromium LanSweeper Extension development
by
Slim D
Last post:
1/15/2021 11:39:29 AM(UTC)