Solved

LanSweeper custom report generation

Posted on 2016-07-18
3
448 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
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
Manju earned 500 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now