iPhone iOS 12.3 iMessage Vulnerability Audit

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,
Case
When tblIntuneDevice.Model LIKE '%2G' and tblIntuneDevice.OsVersion = '3.1.3' then 'Up to date'
When tblIntuneDevice.Model LIKE '%3G' and tblIntuneDevice.OsVersion = '4.2.1' then 'Up to date'
When tblIntuneDevice.Model LIKE '%3GS' and tblIntuneDevice.OsVersion = '6.1.6' then 'Up to date'
When tblIntuneDevice.Model LIKE '%4' and tblIntuneDevice.OsVersion = '7.1.2' then 'Up to date'
When tblIntuneDevice.Model LIKE '%4S' and tblIntuneDevice.OsVersion = '9.3.5' then 'Up to date'
When tblIntuneDevice.Model LIKE '%5' and tblIntuneDevice.OsVersion = '10.3.3' then 'Up to date'
When tblIntuneDevice.Model LIKE '%5C' and tblIntuneDevice.OsVersion = '10.3.3' then 'Up to date'
When tblIntuneDevice.Model LIKE '%5S' and tblIntuneDevice.OsVersion > '12.3.0' then 'Up to date'
When tblIntuneDevice.Model LIKE '%6%' and tblIntuneDevice.OsVersion > '12.3.0' then 'Up to date'
When tblIntuneDevice.Model LIKE '%6S%' and tblIntuneDevice.OsVersion > '12.3.0' then 'Up to date'
When tblIntuneDevice.Model LIKE '%SE' and tblIntuneDevice.OsVersion > '12.3.0' then 'Up to date'
When tblIntuneDevice.Model LIKE '%7%' and tblIntuneDevice.OsVersion > '12.3.0' then 'Up to date'
When tblIntuneDevice.Model LIKE '%8%' and tblIntuneDevice.OsVersion > '12.3.0' then 'Up to date'
When tblIntuneDevice.Model LIKE '%X%' and tblIntuneDevice.OsVersion > '12.3.0' then 'Up to date'
else 'Out of date'
End as [Patch Status],
Case
When tblIntuneDevice.Model LIKE '%2G' and tblIntuneDevice.OsVersion = '3.1.3' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%3G' and tblIntuneDevice.OsVersion = '4.2.1' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%3GS' and tblIntuneDevice.OsVersion = '6.1.6' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%4' and tblIntuneDevice.OsVersion = '7.1.2' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%4S' and tblIntuneDevice.OsVersion = '9.3.5' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%5' and tblIntuneDevice.OsVersion = '10.3.3' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%5C' and tblIntuneDevice.OsVersion = '10.3.3' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%5S' and tblIntuneDevice.OsVersion > '12.3.0' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%6%' and tblIntuneDevice.OsVersion > '12.3.0' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%6S%' and tblIntuneDevice.OsVersion > '12.3.0' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%SE' and tblIntuneDevice.OsVersion > '12.3.0' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%7%' and tblIntuneDevice.OsVersion > '12.3.0' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%8%' and tblIntuneDevice.OsVersion > '12.3.0' then '#d4f4be'
When tblIntuneDevice.Model LIKE '%X%' and tblIntuneDevice.OsVersion > '12.3.0' then '#d4f4be'
else '#ffadad'
End as backgroundcolor,
  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 = 'iPhone' And tblState.Statename = 'Active'
Order By tblAssets.AssetName