Solved

LanSweeper custom report generation

Posted on 2016-07-18
3
1,590 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 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

615 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