Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

LanSweeper custom report generation

Posted on 2016-07-18
3
Medium Priority
?
2,593 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 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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 …
Simple Linear Regression

885 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