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