Notification

Icon
Error

Windows 10 Computers Out-Of-Date - Lists Windows 10 computers that may be having trouble installing the latest feature update.

Posted: Friday, January 11, 2019 4:39:02 PM(UTC)
marck1024

marck1024

Member Original PosterPosts: 31
1
Like
Lansweeper includes a report showing Windows 10 computers not on the latest feature update. But this report is always showing a lot of computers because we have test users on the newest build at all times while the regular users are delayed by 8 months.

I put together a report that calculates the version that most computers are on and then shows computers on older builds than that. This helps us catch computers that are getting behind.

Code:

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname As OS,
tblAssets.OScode + '.' + tblAssets.BuildNumber As Build,
tblAssets.Version As [OS Version],
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Left Join (Select A.Version,
Row_Number() Over (Order By A.Version Desc) As RowNumber
From (Select Distinct A.Version
From tblAssets A
Inner Join tsysOS B On A.OScode = B.OScode
Inner Join (Select Top 1 A.Version,
Count(1) As Total
From tblAssets A
Inner Join tsysOS B On A.OScode = B.OScode
Where B.OSname = 'Win 10'
Group By A.Version
Order By Total Desc) C On 1 = 1
Where A.Version <= C.Version And B.OSname = 'Win 10') A) Versions On
tblAssets.Version = Versions.Version
Where tsysOS.OSname = 'Win 10' And tblAssetCustom.State = 1 And
(Versions.RowNumber >= 2 Or tblAssets.Version Is Null)
Order By tblAssets.Lastseen Desc
Saulo Benigno
#1Saulo Benigno Member Posts: 7  
posted: 3/1/2019 5:51:15 PM(UTC)
Error

[ Token line number = 1,Token line offset = 753,Token in error = Over ]

I was unable to save it :(
marck1024
#2marck1024 Member Original PosterPosts: 31  
posted: 3/1/2019 6:17:44 PM(UTC)
Are you using SQL Compact for the database? It looks like ROW_NUMBER() is not supported in SQL Compact.

I didn't realize that. I always opt to install applications like this into a separately managed instance of SQL Server Express (which is free) over using the included database option.

Actually, the admin that originally installed Lansweeper in our environment did use SQL Compact and I migrated it over to SQL Server Express. We noticed an immediate performance improvement doing that despite that fact that SQL Express is running on the same system that SQL Compact was. We got a nice performance boost with a software change only.
Saulo Benigno
#3Saulo Benigno Member Posts: 7  
posted: 3/1/2019 7:16:10 PM(UTC)
Yes. I used the default install.

That's my error.

Is there any alternative for that?

Thanks
marck1024
#4marck1024 Member Original PosterPosts: 31  
posted: 3/1/2019 9:59:12 PM(UTC)
DISCALIMER: I do not work work Lansweeper. I'm just an end user.

Lansweeper has documented the process of moving from SQL Compact Edition to SQL Server. You'd need to be comfortable installing and setting up SQL Server Express, first.

Then you would follow these instructions to move your database over.

https://www.lansweeper.c...l-compact-to-sql-server/

Active Discussions

Lansweeper Asset Value Report
by  RC62N   Go to last post Go to first unread
Last post: 9/20/2019 7:12:29 PM(UTC)
Lansweeper Display Hyper-V Guest User report
by  GlenTB  
Go to last post Go to first unread
Last post: 9/20/2019 2:26:15 PM(UTC)
Report Center Windows Defender Antivirus Broken Scan Audit
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:18:02 PM(UTC)
Lansweeper Reports are empty
by  Mendoza  
Go to last post Go to first unread
Last post: 9/20/2019 11:12:18 AM(UTC)
Lansweeper Custom Helpdesk Report
by  StevoCamaro   Go to last post Go to first unread
Last post: 9/19/2019 11:13:05 PM(UTC)
Lansweeper Windows 7 EOL
by  RC62N  
Go to last post Go to first unread
Last post: 9/19/2019 4:42:11 PM(UTC)
Lansweeper Drive Encryption statuses
by  DFox   Go to last post Go to first unread
Last post: 9/19/2019 12:54:06 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 10:55:07 AM(UTC)