Overview
This workflow queries recent device unenrollment and group transfer logs, then packages the matching records into an Excel report. It sends the result by email so teams can review changes in one place. The template works as a repeatable reporting step for device management and operations follow-up.
The Problem This Workflow Solves
Teams that manage device records need a clear way to check whether devices were unenrolled or moved between groups within a chosen period. They also need the time zone, record type, and recipient list to match the review task before they decide whether to investigate further or share the findings.
- Clearer log review. The report groups matching unenrollment and transfer records in one place.
- Faster sharing. The workflow emails recipients a report link or a direct result message.
- Defined record scope. The query uses the selected time range and record types.
- Known report limits. The workflow flags large result sets and shows when records exceed export capacity.
Who This Is For
- Device management teams. They review unenrollment and group transfer activity across managed devices.
- Operations reporting owners. They need an email-ready record of recent account activity.
- Teams with shared review lists. They send the report to authorized recipients who need the same log view.
What Sets This Workflow Apart
- Input validation. The workflow checks the date range, time zone, and recipient emails before querying.
- Record-type choice. The workflow can query unenrollment records, group transfer records, or both.
- Report handling. The workflow creates an Excel report when records exist and sends a plain result when they do not.
- Large-result handling. The workflow limits one report to 3,000 records and marks partial exports clearly.
How It Works
- Check query settings
- The workflow checks the recent-day range, report time zone, selected record types, and recipient emails before it continues.
- Stop invalid requests
- If the inputs are invalid, the workflow stops and returns the input issue without querying records or sending email.
- Confirm record scope
- If no record type is selected, the workflow sends a notification that no query was performed.
- Query matching logs
- The workflow reads device unenrollment and group transfer logs for the chosen date range and selected record types.
- Continue if needed
- When more pages exist, the workflow keeps reading logs in pages of up to 50 records each.
- Build the report
- The workflow organizes the matching records into an Excel sheet, grouped by operation time and limited to 3,000 exported records.
- Create the share link
- If the report is created, the workflow generates a public read-only OneDrive link for direct viewing.
- Send the result
- The workflow emails recipients with the report link, or with a no-record or failure message when needed.
What You'll Need
- Authorized connections for AirDroid Business, Excel, OneDrive, and Gmail
- The workflow needs bound credentials so it can query logs, create the workbook, share the file, and send email.
- Query window and report time zone
- Enter 1 to 90 recent days and select the time zone used for report timestamps.
- Record types to include
- Select unenrollment records, group transfer records, or both; at least one type must be enabled.
- Recipient email addresses
- Provide up to 10 authorized email addresses, separated by commas, to receive the result message.
How to Use
- Step 1. Connect the required services.
- Step 2. Set the query conditions.
- Step 3. Run the workflow and review the email.
Bind the AirDroid Business, Microsoft Excel, Microsoft OneDrive, and Gmail credentials needed for querying, report creation, sharing, and email delivery.
Enter the recent-day range, choose the report time zone, select the record types, and add the recipient email addresses.
Start the workflow, then check the email result to open the report link or read the message explaining the outcome.