TDT-Asset Device Collection and Inventory Cleanup

Kate Smith-Ziegler Updated by Kate Smith-Ziegler

We do not recommend using the "collected" tags as they do not indicate a date and can be confused with prior year disbursements or collections.
Keeping your current cart setup for next year? Skip down to the "Inventory Cleanup" section. You only need to upload a new "collected group" if you will be changing device assignments next year.

Collecting Devices in June: Transfer Devices to a Collection Group. Video Tutorial

  1. Create a Google spreadsheet with the same titles found in the image below. Your identifier should use the naming convention "Your school_collected devices YEAR" and add all of the collected asset tags to this sheet.
  2. Download your Google spreadsheet as a CSV.
    1. File => Download=> CSV
  3. Open TDT-Asset (link to TDT)
    1. Go to Assign => New Group Assignment => Bulk Assignment CSV
    2. Choose assignment type and match by identifier.
    3. Browse for your CSV and choose it in your finder.
    4. Click upload.
  4. You will likely get an error massage that says "Owner Does Not Exist" because you are creating a new group.
    1. Click on the message => Click "Auto-Create and Assign to Owners"
  5. If you get an error message about any incidents that need to be removed before a device can be assigned, you will need to review each asset tag for those incidents. You can then transfer them to the group once the incident is cleared.
    1. Make sure to resolve any incidents before assigning the device to the group.

Inventory Cleanup: Device Report

Objective: Identify and mass-disable lost devices in the TDT-Asset Inventory system by filtering out known and active deployments.

A disabled device will count as a lost device. You do not need to mark the devices as lost unless they were reported lost by a student directly.
  1. Explore and Prepare the Data
    1. Run a device report using the filters below, replace your school building as the device building, and click export to CSV at the bottom of the page. Make sure to name your CSV something that will help you identify it in the next step.
  1. Import the data to Google sheets
    1. Open a Google sheets and click file==> import=> upload=> browse for the file you just downloaded => click on the file=> click upload. Choose "insert new sheet" and import data.
    2. You can also access the sheet by uploading it to your Google drive and opening it from there.
  2. Filter and Remove your collected group and/or any groups you know to be collected. We need to separate the devices we know are accounted for.
    1. Locate the column containing the owner identifiers and filter for the group names you just uploaded or know to be collected. You can move these to another sheet as your confirmed inventory.
    2. Filter the remaining sheet for active devices in the column labeled, "GoogleAdminConsole:Status". It should list active vs. disabled devices. Active devices are enabled in the Google Admin Console.
      1. Filter out disabled devices so that you are only looking at the Enabled/ Active ones. Reminder, all devices that are listed as disabled are already counted as lost. No action is required for them.
    3. Explore your list of "Active" devices.
      1. Are there any other students or groups that have devices that you are aware of? Which devices in this remaining list need to be assigned properly, investigated, or disabled? If you recognize a group that you recently assigned, remove them from the list, as this remaining list will become the "lost" list for disabling.
      2. Create a new tab for all of the devices (serial numbers) you consider to be lost and need to disable. Any devices that are not accounted for should be disabled. In the next step, we will mass disable devices.

Bulk Disable (Mass Disable)

Objective: To disable any devices that can not be accounted for. If a device comes back, it can be properly assigned to an active group, and re-enabled.

Note: NEVER simply enable a device without making sure the assignment is correct. It could be that the device school is wrong and another school has identified this device as missing from their inventory. If the assignment is not corrected, you risk this device being disabled again until it is properly assigned.

  1. Utilizing a new tab in your sheet, use column A for serial numbers of devices you want to bulk disable.
  2. Download this sheet. Make sure to be in the specific sheet you plan to download.
    1. File => Download=> CSV
  3. Go to TDT-Asset
    1. Click Devices=> Device Management=> Bulk Integration Actions => Bulk Disable
    2. Click to upload the csv file from your computer.
    3. Choose "Match by Serial Number."
    4. Click "Disable Devices"

How did we do?

Running Reports on TDT Asset (One2One)

TDT-Asset Device Deployment and Inventory Cleanup

Contact