Opselith
POWERSHELL / MICROSOFT.GRAPH.IDENTITY.DIRECTORYMANAGEMENT
ProAdvancedRead-onlylow

Find stale Entra devices

Find Microsoft Entra devices whose approximate last sign-in is older than a threshold and export them to CSV.

Open in PowerShell Builder →Browse all scripts

Pro generation after license validation · Review before running · Opselith does not connect to your tenant

What this PowerShell script does

Finds Entra devices with an approximate last sign-in older than a chosen number of days

Requirements

  • Inactive days - e.g. 90
  • CSV output path - Example: C:\Temp\report.csv

Environment

  • Module: Microsoft.Graph.Identity.DirectoryManagement
  • Permissions: Device.Read.All
  • Output: CSV report
  • Context: Microsoft Graph PowerShell
  • Risk: Low
Review before you run The full Pro script is generated by Opselith after license validation. Test outside production first.
NEXT STEP

Ready to generate

Configure Find stale Entra devices in the Builder, review the generated PowerShell and run it yourself in your own PowerShell session.

Configure this script →Open Builder
More about this script

Why use this template?

Use this Pro PowerShell script when you need to find entra devices with an approximate last sign-in older than a chosen number of days. It can be previewed in the Builder; Pro access is required to generate it for your own environment.

The template uses Microsoft.Graph.Identity.DirectoryManagement and requires Device.Read.All. Output: CSV report. Level: Advanced. Action: Read-only. Risk: Low.

Review before running

The script remains preview-only until Pro access is enabled. Review it before running it, and test it outside production first. “Read-only” describes the script itself; anything you add around it can still change data.

Preview the script

  1. Open the template in the PowerShell Builder.
  2. Review the purpose, requirements, permissions, output and risk.
  3. Activate Pro when you are ready to generate the full script, then test it outside production.

Pro templates remain previewable before purchase or activation. No tenant connection is required. When you generate a Pro script, only the configuration values needed for that template are sent to Opselith after license validation.Preview Find stale Entra devices →

How to use this result

Use this report to identify devices with an ApproximateLastSignInDateTime older than the number of days you choose.

When this helps

  • Prepare a stale-device review before cleanup or device-lifecycle work.
  • Compare older Entra device records by OS, trust type, management and compliance metadata.

How to read the result

  • ApproximateLastSignInDateTime is an approximate Entra activity signal, not an exact last-use timestamp.
  • Devices with a blank activity timestamp are intentionally excluded from the stale-date comparison and need separate review.

Things to check

  • Microsoft notes that some active devices can have a blank timestamp.
  • Entra device activity is not the same as Intune last check-in, Intune compliance or proof that the physical device is unused.

What to do next: Validate candidate devices against ownership, Intune/management data and recovery requirements before disabling or deleting anything.

Related tasks

Official references

Before you runModule, permissions, inputs, compatibility and script checks
OPS / SCRIPT DETAILS

Script details

Finds Entra devices with an approximate last sign-in older than a chosen number of days Review these details before generating or running the script.

entrafinddeviceinactive
Generated here. Run by you.Opselith does not connect to your tenant or run PowerShell. After generating, review the script and run it in your own PowerShell session.

What it works with

Module: Microsoft.Graph.Identity.DirectoryManagement

Microsoft Graph PowerShell lets the script work with Microsoft Entra and Microsoft 365 data through Microsoft Graph.

Context: Microsoft Graph PowerShell

Compatibility: PowerShell 7 is the supported target for this cloud template.

Permissions and changes

Permissions: Device.Read.All

Risk: Low

Read-only: designed to collect information without intentionally changing the target environment.

Changes: Read-only. The script reads data and does not intentionally change the target environment.

Inputs

  • Inactive days - e.g. 90 (Required)
  • CSV output path - Example: C:\Temp\report.csv (Required)

What to expect

Output: CSV report

Expect a CSV file at the path you choose. Open it in Excel or another CSV viewer and review the rows.

Example: C:\Temp\report.csv

This template is in the Pro library. Generating the full script requires eligible Pro or tester access. Opselith receives only the values needed to build the script; it does not connect to your tenant, run PowerShell or store the generated script. You review and run the result in your own PowerShell session.

Example use

Finds Entra devices with an approximate last sign-in older than a chosen number of days

Enter the required values in the Builder, review the generated script and confirm the output before running it.

Before you run: Make sure your account has Device.Read.All. Check that the Microsoft.Graph.Identity.DirectoryManagement PowerShell module is available and that you are using the supported PowerShell version. Review the generated script and output path, then test outside production first.
Script checksWhat has been verifiedQA reviewed
Static checksPassed
PSScriptAnalyzerPending
Real-world run testNot yet recorded
Last checkedNot yet recorded

Real-world run results are shown only after Opselith reviews and accepts a tester report.

Tester: report a result →
TEST STATUSWhat Opselith has checked

Last reviewed: 10 Sept 2026

PSScriptAnalyzer: Awaiting a release PSScriptAnalyzer gate that includes this script. No analyzer pass is claimed yet.

Pending or Not yet recorded means there is no accepted result on file yet. A passed analyzer check does not mean the script has been run in a real tenant.

NEXT IN THE LIBRARY

Scripts for similar admin tasks and Microsoft services.

Browse Microsoft Entra PowerShell scripts →
POWERSHELLFind stale Intune devicesintune · find · devicePOWERSHELLExport Entra devicesentra · export · devicePOWERSHELLFind duplicate Intune device namesintune · find · device