Overview

This workflow collects device battery data from AirDroid Business, writes it into an Excel workbook, and sends the report link through Outlook. It supports both all-device queries and a named device scope, making it a reusable step in a standard operating procedure for routine battery reporting.

The Problem This Workflow Solves

Teams responsible for monitored devices often need a current battery report for a full fleet or a specific group. They must confirm the scope, check that the query succeeds, and share the result with the right recipients. If any part fails, they need a clear result code before they continue.

  • Clear scope checks. The workflow rejects an empty custom scope before it tries to query devices.
  • Consistent reporting. It turns battery snapshots into the same nine-column Excel layout every run.
  • Direct handoff. It sends the workbook link to the recipients you specify through Outlook.
  • Readable results. It returns status details that show where the run stopped or succeeded.

Who This Is For

  • Device operations teams. They can export battery status for routine inspection and device tracking.
  • Administrators using named scope. They can target selected groups or devices when a full-fleet report is not needed.
  • Teams sharing report links. They can send the workbook to named recipients through Outlook.

What Sets This Workflow Apart

  • Scope validation first. The workflow checks recipient addresses and custom scope input before it starts the report task.
  • Built-in query routing. It switches between all devices and named devices without changing the reporting format.
  • Workbook link check. It verifies that the Excel file returns an accessible link before the email goes out.
  • Result-specific return values. It returns different status details for scope, query, export, link, and delivery outcomes.

How It Works

1
  1. Prepare the request
  2. The workflow reads the device scope, recipient addresses, and report time zone, then prepares the report context.
2
  1. Validate scope and recipients
  2. It checks that recipients are valid and that a custom query has at least one group or device name.
3
  1. Query battery snapshots
  2. The workflow resolves a named scope when needed, then queries battery data for the selected devices.
4
  1. Export and notify
  2. It formats the report time, writes the battery rows into Excel, checks the workbook link, and emails the link.

What You'll Need

  • AirDroid Business access
    • You need authorized access to query devices and, when needed, resolve group or device names.
  • Excel and Outlook credentials
    • You need authorized connections for writing the workbook and sending the report email.
  • Scope and recipient inputs
    • You must enter valid recipient email addresses. For a custom scope, provide at least one group name or device name.
  • Optional report time zone
    • You can select a report time zone for the workbook file name and email time display. UTC is the default.

How to Use

  1. Step 1. Choose the device scope.
  2. Decide whether to query all visible devices or limit the report to specific groups or device names.

  3. Step 2. Enter recipient addresses.
  4. Provide one or more Outlook email addresses, separated by semicolons or commas.

  5. Step 3. Set the report time zone.
  6. Select the time zone that should appear in the workbook file name and the email text.

  7. Step 4. Confirm authorized connections.
  8. Make sure AirDroid Business, Excel, and Outlook authorization is available before you run the template.

  9. Step 5. Review the returned result.
  10. Check the success status, result code, and workbook link when the run completes.

FAQs

What happens if the recipient list is empty or invalid?
The run ends early and does not send an email. The result includes an invalid-recipient status.
Can I run the report for a custom device scope?
Yes. When you do not query all devices, you must provide at least one group name or device name.
What does the workflow return when the workbook link is missing?
It returns a workbook-link-missing status and notes that the Excel workbook was created without an accessible link.
Which battery fields are included in the export?
The export includes last online time, online status, device name, group, model, battery level, charging status, health status, and battery temperature.
Was This Page Helpful?

More Workflows for Inspiration

🔧
Account Activity Log Query and Export
Exports account activity logs from the chosen days, then emails a OneDrive workbook link.
Learn more >
🔧
Device Unenroll and Transfer Log Query
Query recent device unenrollment and group transfer logs, then send an Excel report link by email.
Learn more >
🔧
Auto-add Tags to Alerting Devices
When an alert fires, this workflow tags the target device for faster filtering and follow-up.
Learn more >