PRUEBA AHORA

Microsoft Office 2010 End Of Life Audit

Security Software

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. Office 2010 end of life audit

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'

Show

Hide