Hi,I am using the following report to get the total OS count by Windows version.The SQL query is set to only display "Active" devices. However, when clicking on the totals, the list expands and there are both, "Active" and "Non-active."Does anyone ha...
Hi,I just read an article that repots that Windows 11 24H2 requires something called POPCNT instruction support (SSE4.2). Has anyone created a report that will tell you which computers cannot be upgraded to 24H2?Here is the article: https://www.ghac...
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. M...
Generate SQL queries to recreate your custom reports on another database. This code is designed for SQL Server and will not work on SQL Compact.SELECT 'INSERT INTO [tsysreports] ([Reportquery] ,[Reporttitle] ,[Sendmail] ,[Mailgrou...
LS has bug in SQL Model - partially not working Remove AD object function. When LS removes AD object SQL has some triggers which can not correctly clean AD objects info. Firsty, you can run report to check count of orphaned objects in your database:...
HelloI have a problem with scaning windows os that have jenkins installed.It seems that LS only is able to show the information that you can find in Programs & Features.But if the jenkins is updated that informations does not change. So even if the j...
Hello,I would like to create two reports to obtain all local users and which group they belong to; one for Windows servers and another for Linux servers.
HelloSeveral times through out the year we are asked for reports for auditing purposed to list out all the local administrators on a few of our critical systems. We have a basic report setup up that lists all local accounts, AD users and AD Groups t...
