How to Deal with a certain scenario?

[swsswr]

Hi,

I am facing the following issue at the moment. At the moment APT28/Fancy BEear  is targeting an old vulnerablity (https://msrc.microsoft.com/update-guide/en-US/advisory/CVE-2022-38028?ref=news.risky.biz) . Microsoft has released a patch for it. 

My problem is to find out, which Assets are affected by that CVE. When searching RiskInsigts for the CVE it is not found. I could filter out all Assets for the absence of that corresponding Patch , eg. KB5018425 with the help of SQL (https://community.lansweeper.com/t5/reports-analytics/windows-computers-that-do-not-have-a-specific-...) But this would list even Assets, which have eg. WIN1123H2, which is not affected with that vulnerability.

How would you address this dilemma?

[Obi_1_Cinobi]

Hello there!

I would recommend logging a case for this: https://www.lansweeper.com/contact/contact-support/

[swsswr]

Hi, 

why can´t we just discuss this here? I am still in the process of testing Lansweeper. Think there is no need for a ticket. Maybe this issue will be interesting to know for other users as well.

[Obi_1_Cinobi]

Hello there!

We appreciate our customers' interest in custom reports and want to assist them in any way we can. However, due to the growing number of report requests and our limited resources, we are only able to offer limited support in creating custom reports. To help us manage this process, you will need to create a support case for each report request. We appreciate your understanding and cooperation in this matter.

If you are interested in building or modifying reports, we recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
• Checking out our report library: https://www.lansweeper.com/report/