Overview

This template queries device resource usage for all visible devices or a selected scope, then exports the results to Excel and emails a verified link. It fits a repeatable operational process for teams that need a consistent report on device CPU and internal storage.

The Problem This Workflow Solves

Teams responsible for monitored devices often need a current view of CPU and internal storage across all visible devices or a defined group. They also need to confirm the query scope, export the results, and share the report link with the right recipients.

  • Scope control. The workflow checks whether you want all visible devices or a named subset before querying.
  • Consistent reporting. It writes the same resource fields into an Excel workbook for easier review.
  • Verified sharing. It confirms the workbook link is accessible before Outlook sends the message.

Who This Is For

  • Device operations teams. They need a repeatable way to collect resource usage for managed devices.
  • Teams using group or device scopes. They need reports for selected groups, specific devices, or all visible devices.
  • Recipients of routine reports. They receive a workbook link by email after the report is generated and verified.

What Sets This Workflow Apart

  • Scope branching. The workflow can use all visible devices or resolve a custom group and device list.
  • Link verification. It checks that the workbook link works anonymously before sending the email.
  • Clear result outputs. It returns the run status, result code, and report details for follow-up.

How It Works

1
  1. Collect the run settings
  2. The workflow reads the query scope, recipient addresses, and report time zone before it starts the report process.
2
  1. Resolve the device scope
  2. It either targets all visible devices or resolves the selected group names and device names into a query scope.
3
  1. Query device resource usage
  2. The workflow retrieves CPU, online status, device identity, and internal storage fields for the chosen devices.
4
  1. Export and send the report
  2. It creates an Excel workbook, generates a public read-only link, verifies anonymous access, and emails the link through Outlook.

What You'll Need

  • AirDroid Business access
    • An authorized connection must be available to query devices and resolve the selected scope.
  • Excel, OneDrive, and Outlook connections
    • Authorized credentials must be available to create the workbook, share it publicly, and send the email.
  • Query scope and recipients
    • Enter all visible devices or provide at least one group name or device name, plus recipient email addresses.
  • Report time zone
    • Choose the report time display zone, which the workflow uses for the workbook name and email time text.

How to Use

  1. Step 1. Connect the required accounts
  2. Provide the AirDroid Business, Excel, OneDrive, and Outlook credentials needed for querying, exporting, sharing, and sending.

  3. Step 2. Enter the report parameters
  4. Select all devices or fill in group names or device names, then add the recipient email addresses and report time zone.

  5. Step 3. Run and review the result
  6. Start the workflow, then review the returned status, report details, and any failure description in the run record.

FAQs

Can I query all visible devices?
Yes. When all devices is selected, the workflow queries devices visible to the current credential, up to 6000.
What happens if I choose a custom scope?
You must provide at least one group name or device name. The workflow resolves that scope before querying resources.
What does the email contain?
The email includes a verified public workbook link and a short summary that reflects the query scope and report time.
What if sharing or email sending fails?
The workflow stops at the failing phase and returns the corresponding status code and description in the run result.
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 >