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
