Microsoft Teams Status

EBOOZ · January 13, 2021, 9:41pm

Do you know if this one supports refresh-tokens? My previous attempt to get this up and running failed because my token expired and didn’t refresh. This was a known REST-API in HA at that moment.

mclever · January 14, 2021, 5:04am

@Mey Any idea when this will get merged?

PrayerfulDrop · January 26, 2021, 5:25pm

Getting the following warning:

2021-01-26 11:00:35 WARNING (MainThread) [homeassistant.components.template.template_entity] Template loop detected while processing event: <Event state_changed[L]: entity_id=sensor.teams_activity, old_state=<state sensor.teams_activity=; friendly_name=Microsoft Teams activity, icon= @ 2021-01-26T10:29:00.470623-06:00>, new_state=<state sensor.teams_activity=Not in a call; friendly_name=Microsoft Teams activity, icon=mdi:phone-off @ 2021-01-26T11:00:35.097926-06:00>>, skipping template render for Template[{% if states('sensor.teams_activity') == '' -%}
  Offline
{%- endif %}]
2021-01-26 11:00:35 WARNING (MainThread) [homeassistant.components.template.template_entity] Template loop detected while processing event: <Event state_changed[L]: entity_id=sensor.teams_activity, old_state=<state sensor.teams_activity=; friendly_name=Microsoft Teams activity, icon= @ 2021-01-26T10:29:00.470623-06:00>, new_state=<state sensor.teams_activity=Not in a call; friendly_name=Microsoft Teams activity, icon=mdi:phone-off @ 2021-01-26T11:00:35.097926-06:00>>, skipping template render for Template[{% if states('sensor.teams_activity') == '' -%}
  mdi:microsoft-teams
{%- endif %}]

EBOOZ · January 29, 2021, 10:27pm

Issue with creating sensors - log attached · Issue #2 · EBOOZ/TeamsStatus (github.com)

metbril · February 16, 2021, 8:59am

A potential workaround for self-referencing template sensors would be to have the PowerShell script set the value of an input helper (input_text or input_select). For the UI etc. you could then (also) create a template sensor that inherits the input helper entity.

hillbicks · March 11, 2021, 8:36am

Hey guys,

this looks amazing! Unfortunately my organisation also doesn’t allow access to the API and I also don’t have elevated rights on my machine. The elevated rights are needed to access the teams logfile, right?

So, without these, it is not going to be possible to get the status from teams?

dcnoren · March 11, 2021, 3:14pm

I have it running without admin rights. https://github.com/EBOOZ/TeamsStatus requires admin rights only because he wants to use a service daemon. Another option is to take the guts of his script and schedule tasks via task scheduler.

Download https://github.com/EBOOZ/TeamsStatus/blob/ec83df37311f26493f3034c1303f73e2d177f673/Get-TeamsStatus.ps1 and https://github.com/EBOOZ/TeamsStatus/blob/ec83df37311f26493f3034c1303f73e2d177f673/Settings.ps1
Place into a folder in your user directory, wherever you wish (desktop, docs, whatever)
Edit settings as needed
Create the entities in Home Assistant as documented by EBOOZ
Test the script by running Get-TeamsStatus.ps1 with PowerShell. Ctrl+c to kill it
Open task scheduler - you can create tasks as you without any admin rights required, in most orgs (may depend on GPO)
Set action to start a program, “powershell.exe”. Set arguments to be -WindowStyle Hidden -File “C:\Users\UserID\pathToFolder\Get-TeamsStatus.ps1”
Set triggers; I did two triggers, one at login, and one at workstation unlock. Make sure it won’t run if already running, make sure it runs on battery, and on settings tab make sure it won’t stop the task.

Hopefully you’re familiar with task scheduler… if not, google.

hillbicks · March 11, 2021, 3:26pm

Awesome man!. I’ll try this out either today or tomorrow!

Thanks for the info.

dcnoren · March 12, 2021, 1:30am

So, for what it’s worth, I created a pull request on EBOOZ’s repo to add in a webcam monitor capability with registry key. Basically it monitors the following key which is “0” if the camera is on (replace username):

Get-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\CapabilityAccessManager\ConsentStore\webcam\NonPackaged\C:#Users#USERNAME#AppData#Local#Microsoft#Teams#current#Teams.exe -Name LastUsedTimeStop | select LastUsedTimeStop

You can add in to his script in the elseif block at line 136.

    ElseIf ($TeamsActivity -like "*Pausing daemon App updates*" -or `
        $TeamsActivity -like "*SfB:TeamsActiveCall*" -or `
        $TeamsActivity -like "*name: desktop_call_state_change_send, isOngoing: true*") {
        
		$webcam = Get-ItemProperty -Path "HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\CapabilityAccessManager\ConsentStore\webcam\NonPackaged\C:#Users#$UserName#AppData#Local#Microsoft#Teams#current#Teams.exe" -Name LastUsedTimeStop | select LastUsedTimeStop
		
		if ($webcam.LastUsedTimeStop -eq 0){
			$Activity = $lgInACallWebcamOn
			$ActivityIcon = $iconInACall
		}
		else {
			$Activity = $lgInACall
			$ActivityIcon = $iconInACall
		}
        Write-Host $Activity
    }

In settings, replace line 18 with these two lines:

$lgInACall = "In a call - camera off"
$lgInACallWebcamOn = "In a call - camera on"

Dielee · March 15, 2021, 10:48am

Hello all!

As my teams state from the log file no longer works, I have built a python application to fetch the teams state directly from MS Graph api.
Its available as docker image!

Have a look at here:

markdark · March 17, 2021, 10:18am

@EBOOZ Thanks for your great PowerShell solution for Teams. I have used this one to control my sonos in my home office. It will pause and then resume after a call/meeting. Works splended!

I have creeated a Gist for others if they are interested: https://gist.github.com/mark-veenstra/01aeccf357ced3c5be048f6b2c704e97

PrayerfulDrop · March 17, 2021, 2:04pm

This is much better than running as a service or the Azure solutions for me. With the service if my computer sleeps the service seems to hang and requires a restart. For the Azure service (though VERY good too) I only want to monitor my laptop and not all my devices. The “In a Call” status I tend to do a lot of automations with and if I am doing the Teams call on my phone I don’t want those automations to occur as I am most likely not home.

dcnoren · March 17, 2021, 3:25pm

Yep, same for me. Just keep in mind if your computer is awake but locked, the scheduled task is still running - so getting on teams on your phone will change status and your PC will relay that to Home Assistant. You may be able to somehow set the task to be killed on PC logoff or lock, or just sleep your PC in those cases.

PrayerfulDrop · March 17, 2021, 6:57pm

Yes but it doesn’t register “In a Call.” This is where my automations are derived from.

ericgla · March 23, 2021, 12:06am

I just pushed RTC-Call-Monitor to Github and may be an alternate solution.

I end up using multiple conference services during my work day, and rather than have an integration for each service, I wrote an application that monitors the UDP packet rate along with network block matching to detect a call for most of the popular web conference providers.

simonk · March 23, 2021, 6:03pm

This looks great, I’ll try it later

ReadMe mentions modifying appsettings.config do you mean appsettings.json?

Can this just be run from windows scheduler to get it to start at boot?

Regards
Simon

PrayerfulDrop · March 23, 2021, 7:58pm

Follow his instructions here: Microsoft Teams Status - Feature Requests - Home Assistant Community (home-assistant.io)

ericgla · March 23, 2021, 8:17pm

There was a mistake in the readme. The correct file is appsettings.json. I’ll be adding support to install the app as a windows service in the next day or so.

simonk · March 23, 2021, 8:29pm

That sounds good, I’ll propbly hold off until then to try it then.

Thanks
Simon

PrayerfulDrop · March 23, 2021, 9:35pm

I am very interested in this also. You may want to spin off another conversation thread. Also interested in your code that updates HA.