SELECT LANSWEEPER DATABASE

[Vsantos]

Hello, community!
I need help to get the following information directly from the Lansweeper database. If anyone knows which tables this data is stored in or has a SELECT ready, I would be very grateful!
Total Assets;
Number of Users in AD;
Total Domain Admins;
Total Vulnerabilities;
Top 10 Vulnerabilities;
Operating Systems – EOL (End of Life);
Lansweeper Laptops/Desktops x KES (Kaspersky Endpoint Security);
Lansweeper Laptops x BitLocker;
Lansweeper Laptops/Desktops x DLP (Data Loss Prevention).
If anyone has done something similar and can share the query or point the way, it will be of great help!

[Katgroup]

You can find the tables where the information is stored in our Database Documentation. Most of the information should already exist in the default reports or in our Reports Library, so it shouldn't be too difficult to copy one and edit what you need.

You can use our Report Builder, or of course SSMS or your favorite SQL editor.