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'
