?
Solved

LanSweeper custom report generation

Posted on 2016-07-18
3
Medium Priority
?
2,108 Views
Last Modified: 2016-07-28
Using LanSweeper v6022 in an office with Windows 10 computers, I would like to accomplish the following:

1. Generate a report to find if the built-in local administrator account is active.
2. Generate a report to find if antivirus is working/last update/last run time.
3. Generate a report to find critical and error events in Windows Application and System logs from within 90 days prior to collection.

I don't know which database LanSweeper uses, but the reports are all SQL-based. Please advise on how to create a custom report in LanSweeper for those items.
0
Comment
Question by:OAC Technology
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
Manju earned 2000 total points
ID: 41722870
Lansweeper uses SQL compact / SQL server. and pretty much most of your requirements can be driven from web console.

Please go through Lansweeper support page below to understand step by step process.

Antivirus : http://www.lansweeper.com/kb/123/managing-anti-virus-software-reports.html

Logins : http://www.lansweeper.com/kb/200/see-who-logged-in-and-made-changes-to-settings.html

Email alerts for critical events: http://www.lansweeper.com/kb/113/sending-email-alerts.html
0
 
LVL 2

Author Comment

by:OAC Technology
ID: 41723774
@Manju
Thank you for forwarding this documentation to me. While the Antivirus portion of my question appears to have been addressed, I am looking for the following on the remaining items:

Logins: Find the names of local accounts with administrative rights that are enabled/disabled.

Windows Events: Output a list of Critical and Error Application and System Windows Events from within the last 90 days of use.

Let me know if there is a built-in template that can address these concerns, or if a custom report needs to be constructed.

Thank you.
0
 
LVL 6

Expert Comment

by:Manju
ID: 41724238
you can create custom reports for those. I dont think these are readily available.

You can view this page as a starting point while building your custom report (http://www.lansweeper.com/kb/53/How-to-create-custom-widgets.html)

lansweeper is SQL database. so you can customize query as per your requirement.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question