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...
When I go into Software, Windows Software and filter the list based on the "Software" column I get back a list of all matching software names with a line for each matching name variation, along with a count of each. Is there an easy way to move from...
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...
Hi We want to know is there any way to generate report from server database with AssetID's - but we want to see that numbers which are in the lsagent.ini on clients computers. Sometimes on some clients the lsagent.ini file becomes empty for no reas...
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...
I am attempting to run a report pulling selected computers by running the below query. However, it is not including some of the computers that are in the query. I can search for the computer, that does not show up in the query, successfully. Is this...
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:...
