Microsoft Teams Audit

Find Microsoft Teams Installations in Your Network

Microsoft decided that there will be no future for Skype for Business. Instead, Microsoft Teams will be taking over and Skype will go end of life on the 31st of July 2021. Due to this change, many companies will have to make the switch from Skype for Business to Teams. Without knowing exactly what you have in your IT environment, this can easily take much more effort than it should. So it's important to discover the users that have Microsoft Teams installed in your network.

With the audit below, you can easily find on which workstations Microsoft Teams is already installed and which are still missing an installation. Additionally, if you also need to uninstall Skype for Business, you can use the Skype for Business audit to find all installations.

Microsoft Teams Audit Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  Case
    When Teams.Software Is Not Null Then 'Yes'
    Else 'No'
  End As [Teams Installed],
  Teams.Version,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When Teams.Software Is Not Null Then '#d4f4be'
    Else '#ffadad'
  End As backgroundcolor
From tblAssets
  Left Join (Select Top 1000000 tblSoftwareUni.softwareName As Software,
        tblSoftware.softwareVersion As Version,
        tblSoftwareUni.SoftwarePublisher As Publisher,
        tblAssets.AssetID
      From tblSoftware
        Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
        Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblSoftwareUni.softwareName Like '%Microsoft Teams%' And
        tblAssetCustom.State = 1) As Teams On Teams.AssetID = tblAssets.AssetID
  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
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename = 'Windows'
  And tblComputersystem.Domainrole <= 1
Order By tblAssets.Domain,
  tblAssets.AssetName