Find Office 2010 Installations in Your Environment
Microsoft announced that starting on 13 October 2020, Microsoft Office 2010 will no longer be supported. Extended support will end which also means that Office will no longer receive updates. While you will still be able to use Office 2010, any vulnerabilities or other issues found will no longer be fixed. You can find more information in our Microsoft Office end of life blog post.
Microsoft recommends upgrading to either Office 365 or Office 2019. To help you in your migration to a newer version, we created the audit below which gives you an overview of Office installation in your IT environment so you can check which machines still need to be updated.
Microsoft Office 2010 End Of Life Audit Query
Select 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, Case When tblSoftwareUni.softwareName Like '%Office%2003%' Or tblSoftwareUni.softwareName Like '%Office%2007%' Or tblSoftwareUni.softwareName Like '%Office%XP%' Or tblSoftwareUni.softwareName Like '%Office%2000%' Then 'EOL' When tblSoftwareUni.softwareName Like '%Office%2010%' And GetDate() < '2020-10-13' Then 'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-10-13') As nvarchar) + ' days' When tblSoftwareUni.softwareName Like '%Office%2010%' And GetDate() >= '2020-10-13' Then 'EOL' Else 'Supported' End As [EOL Status], tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAssetCustom.Model, tsysOS.OSname As OS, tblAssets.SP, tblAssets.Lastseen, tblAssets.Lasttried, tblSoftware.Lastchanged, Case When tblSoftwareUni.softwareName Like '%Office%2003%' Or tblSoftwareUni.softwareName Like '%Office%2007%' Or tblSoftwareUni.softwareName Like '%Office%XP%' Or tblSoftwareUni.softwareName Like '%Office%2000%' Then '#ffadad' When tblSoftwareUni.softwareName Like '%Office%2010%' And GetDate() < '2020-10-13' Then '#ffd17a' When tblSoftwareUni.softwareName Like '%Office%2010%' And GetDate() >= '2020-10-13' Then '#ffadad' Else '#d4f4be' End As backgroundcolor 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 'Microsoft Office%' And tblSoftwareUni.softwareName Not Like '%Add-In%' And tblSoftwareUni.softwareName Not Like '%Excel Viewer%' And tblState.Statename = 'Active'