Find Outdated Edge Installations
On May 5th, Microsoft released Edge 113 for Windows, Linux, and Mac. In this release, Microsoft once again added additional features and updated a number of policies. The new features include:
- More improvements to enhanced security mode. Updates include consolidating the security level settings to the Balanced and Strict modes.
- Switch from Microsoft Autoupdate to EdgeUpdater for macOS. Microsoft Edge for macOS will start using a new updater named EdgeUpdater. If you are using update preferences for Microsoft Autoupdate to prevent browser updates, you will need to change that to the new EdgeUpdater UpdateDefault policy before Microsoft Edge 113 to prevent automatic updates going forward.
- New policy for PDF View Settings. The RestorePdfView policy lets Admins control PDF View Recovery in Microsoft Edge. When enabled, or if you haven't configured the policy, Microsoft Edge will recover the last state of PDF view and you on the section where you ended reading in the last session.
- Updated Microsoft Root Store policy. The MicrosoftRootStoreEnabled policy will now be supported in Microsoft Edge version 113 and 114. It will be removed in Microsoft Edge version 115.
The Edge 113 release also includes the latest security updates of the Chromium project. You can find more details about all changes in Microsoft's Release Notes for Microsoft Edge Stable Channel. With the report below, you can easily find which computers in your network do not have this latest version of Edge installed. Run the report to get an overview of all machines in your environment that still need to be updated.
Edge 113 Lansweeper Classic Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename As AssetType, tblAssets.Username, tblAssets.Userdomain, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.IPAddress, Software.softwareName As Software, Software.softwareVersion As Version, Software.SoftwarePublisher As Publisher, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, Coalesce(tsysOS.OSname, tblSccmAsset.OsCaption, tblSccmAsset.OperatingSystemNameandVersion) As OS, tblAssets.Version As OSVersion, Case When tblErrors.ErrorText Is Not Null Or tblErrors.ErrorText != '' Then 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg Else '' End As ScanningErrors, tblAssets.Lastseen As [Last successful scan], tblAssets.Lasttried As [Last scan attempt] From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner Join tblState On tblState.State = tblAssetCustom.State Left Join (Select tblsoftware.assetid, tblSoftwareUni.softwareName, tblsoftware.softwareVersion, Case When tblSoftwareUni.softwareName Like '%Microsoft Edge' And ((Cast(ParseName(tblsoftware.softwareVersion, 4) As int) < 113) Or (Cast(ParseName(tblsoftware.softwareVersion, 4) As int) = 113 And Cast(ParseName(tblsoftware.softwareVersion, 2) As int) < 1774) Or (Cast(ParseName(tblsoftware.softwareVersion, 4) As int) = 113 And Cast(ParseName(tblsoftware.softwareVersion, 2) As int) = 1774 And Cast(ParseName(tblsoftware.softwareVersion, 1) As int) < 35)) Then 1 Else 0 End As [out of date], tblSoftwareUni.SoftwarePublisher From tblsoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID Where tblSoftwareUni.softwareName Like '%Microsoft Edge' And tblSoftwareUni.SoftwarePublisher Like '%Microsoft Corporation%') As Software On Software.AssetID = tblAssets.AssetID Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode Left Outer Join tblSccmAsset On tblAssets.AssetID = tblSccmAsset.AssetId Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID, Max(tblErrors.Teller) As ErrorID From tblErrors Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID = ScanningError.ID Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype = tblErrors.ErrorType Where Software.softwareName Like '%Microsoft Edge' And Software.SoftwarePublisher Like '%Microsoft Corporation%' And tblState.Statename = 'Active' And Software.[out of date] = 1 Union Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename As AssetType, tblAssets.Username, tblAssets.Userdomain, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, Software.softwareName As Software, Software.Version As Version, Software.SoftwarePublisher As Publisher, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblMacOSInfo.SystemVersion As OS, tblAssets.Version As OSVersion, Case When tblErrors.ErrorText Is Not Null Or tblErrors.ErrorText != '' Then 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg Else '' End As ScanningErrors, tblAssets.Lastseen As [Last successful scan], tblAssets.Lasttried As [Last scan attempt] From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner Join tblState On tblState.State = tblAssetCustom.State Left Join (Select tblMacApplications.assetid, tblSoftwareUni.softwareName, tblMacApplications.Version, Case When tblSoftwareUni.softwareName Like '%Microsoft Edge%' And ((Cast(ParseName(tblMacApplications.Version, 4) As int) < 113) Or (Cast(ParseName(tblMacApplications.Version, 4) As int) = 113 And Cast(ParseName(tblMacApplications.Version, 2) As int) < 1774) Or (Cast(ParseName(tblMacApplications.Version, 4) As int) = 113 And Cast(ParseName(tblMacApplications.Version, 2) As int) = 1774 And Cast(ParseName(tblMacApplications.Version, 1) As int) < 35)) Then 1 Else 0 End As [out of date], tblSoftwareUni.SoftwarePublisher From tblMacApplications Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblMacApplications.softid Where tblSoftwareUni.softwareName Like '%Microsoft Edge%') As Software On Software.AssetID = tblAssets.AssetID Inner Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID, Max(tblErrors.Teller) As ErrorID From tblErrors Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID = ScanningError.ID Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype = tblErrors.ErrorType Where Software.softwareName Like '%Microsoft Edge%' And tblState.Statename = 'Active' And Software.[out of date] = 1 Union Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename As AssetType, tblLinuxUser.UserName, tblAssets.Userdomain, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, subquery1.Software, subquery1.Version, subquery1.Publisher, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tblLinuxSystem.OSRelease As OS, tblAssets.Version As OSVersion, Case When tblErrors.ErrorText Is Not Null Or tblErrors.ErrorText != '' Then 'Scanning Error: ' + tsysasseterrortypes.ErrorMsg Else '' End As ScanningErrors, tblAssets.Lastseen As [Last successful scan], tblAssets.Lasttried As [Last scan attempt] From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID Inner Join tblLinuxUser On tblAssets.AssetID = tblLinuxUser.AssetID Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id Inner Join (Select tblLinuxUser.AssetId, Max(tblLinuxUserLogon.LogonTime) As MaxLogontime From tblLinuxUser Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id Group By tblLinuxUser.assetid) As subquery2 On subquery2.MaxLogontime = tblLinuxUserLogon.LogonTime Inner Join (Select tblSoftwareUni.softwareName As Software, tblSoftwareUni.SoftwarePublisher As Publisher, tblLinuxSoftware.LastChanged, tblLinuxSoftware.assetid, Case When tblLinuxSoftware.Version Like '%-%' Then Left(tblLinuxSoftware.Version, CharIndex('-', tblLinuxSoftware.Version) - 1) When tblLinuxSoftware.Version Like '%R%' Then Left(tblLinuxSoftware.Version, CharIndex('R', tblLinuxSoftware.Version) - 1) Else tblLinuxSoftware.Version End As Version From tblLinuxSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID Where tblSoftwareUni.softwareName = 'microsoft-edge-stable') As subquery1 On subquery1.assetid = tblAssets.assetid Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID, Max(tblErrors.Teller) As ErrorID From tblErrors Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID = ScanningError.ID Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype = tblErrors.ErrorType Where subquery1.Software = 'microsoft-edge-stable' And tblState.Statename = 'Active' And ((Cast(ParseName(subquery1.Version, 4) As int) < 113) Or (Cast(ParseName(subquery1.Version, 4) As int) = 113 And Cast(ParseName(subquery1.Version, 2) As int) < 1774) Or (Cast(ParseName(subquery1.Version, 4) As int) = 113 And Cast(ParseName(subquery1.Version, 2) As int) = 1774 And Cast(ParseName(subquery1.Version, 1) As int) < 35)) Order By Domain, AssetName, Software