Overview
This workflow checks one device group for offline, low battery, low storage, and configuration anomalies, then compiles the results into an online Excel summary. It suits repeatable operational checks where teams need a consistent report, a shareable link, and a clear run result for follow-up.
The Problem This Workflow Solves
Teams responsible for monitored devices often need to review one group, confirm which anomaly types matter, and decide whether any devices need follow-up. They also need a summary they can share quickly, with thresholds, counts, and a clear result that shows whether the query and export completed.
- Group-level view. The workflow gathers anomaly counts for one selected group instead of forcing separate checks.
- Clear follow-up link. It sends an online Excel link so recipients can open the summary directly.
- Consistent thresholds. It applies the same configured limits when checking offline, battery, and storage conditions.
- Readable outcome. It returns a run result and error message when a step does not complete.
Who This Is For
- Device operations teams. They check one group for anomalies and share the summary with other stakeholders.
- Store or regional inspection routines. They use the workflow for recurring group reviews and follow-up reporting.
- Teams managing alert thresholds. They compare offline, battery, and storage conditions against chosen limits.
What Sets This Workflow Apart
- Recipient validation. The workflow stops early if no valid email address is provided.
- Group confirmation. It checks whether the entered group name matches an accessible group before querying devices.
- Deduplicated anomaly count. It counts anomaly devices once per device ID, even if multiple conditions apply.
- Query failure return. It preserves query error information and a retryable flag when device search fails.
How It Works
- Validate input and recipients
- The workflow checks the group name, anomaly types, thresholds, and recipient emails before it starts any device query.
- Resolve the target group
- It confirms the group exists and is accessible, then prepares the query state for the selected device group.
- Query devices in pages
- The workflow reads devices page by page, applies the selected anomaly rules, and keeps a running summary.
- Build and send the report
- It formats the summary, writes an online Excel file, creates a read-only link, and emails the link.
- Return the run result
- The workflow returns execution status, counts, workbook details, or an error message when a step fails.
What You'll Need
- AirDroid Business access and a valid device group
- You need authorized AirDroid Business credentials, and the group name must exactly match the console entry.
- Email and file-sharing connections
- You need Outlook, Microsoft Excel, and Microsoft OneDrive credentials, and Excel and OneDrive must use the same account.
- Run inputs and display settings
- You must enter recipient emails, choose at least one anomaly type, set matching thresholds, and select a time zone.
How to Use
- Step 1. Prepare the connected services
- Step 2. Enter the run details
- Step 3. Run and review the result
Connect the required AirDroid Business, Excel, OneDrive, and Outlook accounts before you run the template.
Provide the device group name, recipient addresses, anomaly types, thresholds, and display time zone.
Start the workflow and review the returned status, error message, counts, and workbook link if the run succeeds.
