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: 27
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: 27  
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: 27  
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

Action Powershell script for WOL on VLAN
by  psmail   Go to last post Go to first unread
Last post: 5/30/2019 12:00:43 AM(UTC)
Lansweeper Fonts
by  TKinnie  
Go to last post Go to first unread
Last post: 5/23/2019 4:00:40 PM(UTC)
Action Schedule Reboot using AT and psshutdown with time input
by  spatchE   Go to last post Go to first unread
Last post: 5/21/2019 5:35:46 PM(UTC)
Action Open users local Temp directory
by  studerje  
Go to last post Go to first unread
Last post: 5/14/2019 7:24:24 PM(UTC)
Lansweeper CMD- CFI MS Update remover 2
by  Rodney Stowell  
Go to last post Go to first unread
Last post: 4/18/2019 6:55:01 PM(UTC)
Action Skype User
by  cctech   Go to last post Go to first unread
Last post: 4/18/2019 4:14:54 PM(UTC)
Action Email user
by  cctech  
Go to last post Go to first unread
Last post: 4/18/2019 3:48:50 PM(UTC)