Silverlight End of Life Audit

Find End of Life Silverlight Installations

Silverlight has been Microsoft’s long-running media application used in Internet Explorer for media streaming, multimedia, animations and web applications. Similar to the more popular Adobe Flash. The last version, Silverlight 5 is going end of life on October 12, 2021. To help you identify where you still have old Silverlight installations, we’ve created a report that provides an overview of all Windows and Mac installations of Silverlight so you can remove them.

You can read more about the Silverlight end of life in our Silverlight blog post.

Silverlight End of Life 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,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.Version,
tblSoftwareuni.softwareName As Software,
tblSoftware.softwareVersion As [Software Version],
tblSoftwareuni.SoftwarePublisher As Publisher,
'2021-10-12' As EOLDate,
tblAssets.Lastseen,
tblAssets.Lasttried
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 tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareuni On tblSoftwareuni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareuni.softwareName Like '%Silverlight%' And tblState.Statename =
'Active'
Union
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblMacOSInfo.SystemVersion As OS,
tblAssets.Version,
tblSoftwareuni.softwareName As Software,
tblMacApplications.Version As [Software Version],
tblSoftwareuni.SoftwarePublisher As Publisher,
'2021-10-12' As EOLDate,
tblAssets.Lastseen,
tblAssets.Lasttried
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 tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblMacApplications On tblMacApplications.AssetID =
tblAssets.AssetID
Inner Join tblSoftwareuni On tblSoftwareuni.SoftID = tblMacApplications.softid
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareuni.softwareName Like '%SLLauncher%' And tblState.Statename =
'Active'
Order By Domain,
IPAddress

Show

Hide