Android Patch Level Audit
Mobile Devices SecurityDiscover Android Devices with an Outdated Security Patch Level
Discover devices in your IT environment that have an outdated security patch level. Every month, Google releases a new Android security update which contains details of all the security-related issues that are being fixed in that month’s security update. Mobile devices contain some of the most sensitive information, therefore it is critical that the latest security patches are applied if possible.
Lansweeper scans mobile devices using Microsoft Intune and with it, retrieves the security patch level of Android devices.
![Android patch level example](https://cdn-website.lansweeper.com/wp-content/uploads/Android-patch-level-example-1024x162.png)
Android Patch Level Lansweeper On-Prem Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypeIcon10 As icon, tblADusers.Username, tsysAssetTypes.AssetTypename As AssetType, tblIntuneDevice.Manufacturer, tblIntuneDevice.Model, tblIntuneDevice.OperatingSystem As OS, tblIntuneDevice.OsVersion, tblIntuneDevice.AndroidSecurityPatchLevel As [Security Patch Level], tblIntuneDevice.SubscriberCarrier, tblIntuneDevice.Imei, tblIntuneDevice.SerialNumber, tblIntuneDevice.EnrolledDateTime, tblIntuneDevice.LastSyncDateTime, tblAssets.Lastseen, tblAssets.Lasttried From tblAssets Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tblIntuneDevice On tblIntuneDevice.AssetId = tblAssets.AssetID Left Join tblADusers On Lower(tblIntuneDevice.EmailAddress) In (Lower(tblADusers.email), Lower(tblADusers.UPN)) Where tsysAssetTypes.AssetTypename = 'Android' And tblState.Statename = 'Active' Order By tblAssets.AssetName