Respond to a lost device
An employee reports that they left their laptop on the train; it has a personal key in Excel and an Access application with the ODBC driver set up. They still have their phone with the authenticator app. Access from this laptop should end immediately, the rest of their work shouldn't.
Solution overview
Depending on what's lost, you withdraw more or less. Everything takes effect with the next request, without a restart.
| Lost | Immediately | Afterward |
|---|---|---|
| Laptop with a personal key | Revoke this key (Revoked), end the person's open sessions | New key for the replacement device |
| Phone with the authenticator app | Reset the second factor (reset-totp); ends the person's sessions | Set up the factor again |
| Laptop and phone, or suspected misuse | Disable the person (Enabled = false) | Clarify the situation, then issue anew |
| Company PC with Windows sign-in | Disable the account in Active Directory; in the service, disable the person | – |
Implementation
- Find the device's key:
PersonalKeyswith$filter=Person eq 'Erika Muster'; the label (for example “Private laptop”) and “last used” with its origin show which one it is. - Revoke:
PATCH /admin/v1/odata/PersonalKeys('k…')with{ "Revoked": true }and the version read inIf-Match. A revocation can't be lifted. - End sessions: read
SessionTokenswith$filter=Person eq 'Erika Muster' and Revoked eq falseand set{ "Revoked": true }on each session. This also ends a code still valid on the laptop. - Phone lost:
reset-totpwith{ "person": "Erika Muster" }; the person sets up the factor again at the next sign-in. - Check: An attempt with the revoked key appears in
SignInEventswithOutcome=refusedandReason=revoked. If it comes from an unknown origin, that's a hint of misuse.
Result: The laptop reaches nothing anymore; the company PC and the person's other keys keep working.
Notes
- Data on the device—an Excel file, an Access database with copies—is beyond the service's reach. Whether it's encrypted is up to device management.
- One key per device keeps this case small: you revoke one key instead of all.
- Every step is in the change log with actor and time.
Related topics
en/wiki/data-conectivity/database-gateway/how-to/respond-to-a-lost-device.txt · Last modified: by Wolfgang van der Stille