Find Dell Command Update, Dell Update, Alienware Update, Dell System Inventory Agent, or Dell Platform Tags Installations
As part of the Dell BIOS driver vulnerability, CVE-2021-21551, we have created a report to find Dell’s update solutions that utilize this driver. Using this report you are able to find all machines in your environment that have one of the Dell update utilities installed and also what version it currently is. This allows you to ensure you are always running the latest version and in the specific case of CVE-2021-21551, you can identify machines you will need to take action on. For more information about the vulnerability, take a look at the Dell BIOS driver vulnerability blog post.
Dell Update Software Query
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftware.Lastchanged As SoftwareLastChanged
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 tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tblSoftwareUni.softwareName Like '%SupportAssist%' or tblSoftwareUni.softwareName Like '%Command%'
Or tblSoftwareUni.softwareName Like '%System Inventory Agent%' Or tblSoftwareUni.softwareName Like '%Update%'
Or tblSoftwareUni.softwareName Like '%Platform Tags%') and tblSoftwareUni.SoftwarePublisher LIKE '%Dell%' And tblState.Statename =
'Active'
Order By tblAssets.IPAddress Desc
