If you haven’t tried the feature recently, you’ll soon see that Sheets column filters provide raw data-exploring power on your Chrome device data. Filtering boosts your device management intelligence, efficiency, and decision-making.
Because Gopher for Chrome’s bulk update feature respects Sheets filters, you can quickly make metadata and OU updates on a filtered subset of devices.
Here are some examples of questions and filter combinations you might apply to your device data:
Which devices were enrolled before a specific date? Filter the Sheet to limit your view by the Last Enrollment Time column using the Filter by condition and use the Date is before > exact date… filter. Perhaps you enrolled a set of devices for a specific location within a certain date range. Once you identify the devices, you want to mass-populate Annotated Location and move them into a sub-organization by editing their Org Unit Path. | |
Which of my devices is missing an annotated asset ID? Filter by the Annotated Asset ID column and select only Blanks (click Clear, then select Blanks). This may be useful for identifying inconsistent asset tagging practices during enrollment and getting up to snuff with barcoding and inventory. |
| Document Version | Date | Description of Change |
| 1.0 | 12/16/2024 | Minor text changes, reverify
|
Comments
Article is closed for comments.