Overview
This workflow checks AirDroid Business devices against an offline-day threshold, gathers matching records, and writes them into an Excel workbook. It supports a repeatable reporting step for teams that need a current offline device list and a shareable file with workbook details after export.
The Problem This Workflow Solves
Teams responsible for monitored devices often need a current list of devices that have remained offline past a chosen threshold. They also need the cutoff, device details, and export status in one place before they decide whether further investigation, reporting, or sharing is needed.
- Clear offline cutoff. The workflow filters devices by a defined number of offline days.
- Fewer manual checks. It gathers matching device records into one workbook for review.
- Shared report details. It returns workbook name, link, and ID after a successful export.
Who This Is For
- Device operations teams. They can list devices that stay offline and need follow-up.
- Reporting and inventory owners. They can export offline device records for review and comparison.
- Teams preparing bulk changes. They can check which devices may miss upcoming tasks because they are offline.
What Sets This Workflow Apart
- Input validation. The workflow rejects decimal values and numbers below one before querying devices.
- Page-based querying. It retrieves devices page by page and stops if a query error appears.
- Workbook output. It creates or updates an Excel workbook and returns access details on success.
How It Works
- Validate the offline-day threshold
- The workflow checks that the entered day count is an integer from 1 to 90 before it continues.
- Prepare query data
- It initializes the device list, paging state, and offline cutoff time used for the search.
- Query offline devices page by page
- The workflow retrieves offline devices in pages, stopping after an error or after the page limit.
- Build the Excel workbook
- It formats the file name with the selected report time zone, arranges device fields, and writes the workbook.
- Return the export result
- The workflow returns success details, or it returns the relevant failure code and error description.
What You'll Need
- AirDroid Business access
- An authorized connection is needed to query device records.
- Excel workbook access
- An authorized Microsoft Excel credential is needed to create or write the report workbook.
- Offline day threshold
- Enter a whole number from 1 to 90 to define the minimum offline period.
- Report time zone
- Select the time zone used for the workbook file name timestamp, or keep the default UTC.
How to Use
- Step 1. Connect the required credentials
- Step 2. Enter the offline-day threshold
- Step 3. Choose the report time zone
- Step 4. Run and review the output
Set up the AirDroid Business and Microsoft Excel credentials before you run the workflow.
Provide a whole number between 1 and 90 to define which devices should be included in the report.
Select the timestamp time zone for the workbook name, or leave the default UTC setting in place.
Start the workflow and review the returned workbook details, or check the failure code and error description if it stops.
