Device status report use cases
Available in:
Overview
The device status report provides visibility into devices, users, and organizations in your Code42 environment to help you address common problems and questions. This article explains how to run a report via the administration console, and provides several sample use cases.
- For a detailed explanation of all report capabilities, see the Device Status report reference.
- You can also create your own customized report solution with the Code42 API.
Code42 server version 6.7.2 introduced several updates to the Device Status report. Click below to expand or collapse the details for your version.
Code42 server version 6.7.2 and later
Click the + icon in the heading above to show use cases for Code42 server 6.7.2 and later. Click the x icon to hide them.
Run a device status report
- Sign in to the administration console.
- Select Reporting > Device Status.
- Enter criteria to narrow your search, such as user, device status, or OS details.
- Click Run Report.
- (Optional) Click the column selector icon
to show or hide additional columns. - (Optional) Click Export Records to download a CSV file of the search results.
Example use cases of the device status report
Use case 1: Backup status
Using the device status report, you can easily identify which devices have not connected recently and, therefore, may have data that is not backed up.
Run the report
- From User Status, select Active.
- (Optional) Add additional criteria as necessary to refine your search.
- Click Run Report.
View results
Option A: Sort by last connected date
This method requires you to page through the results if there are more than 100 rows.
- Add the Last Connection Date column:
- Click the column selector icon .
- Select Last Connection Date.
- Click anywhere outside the column selector to return to the search results.
- Click the column selector icon
- In the search results, click the Last Connection Date column heading to sort the results in ascending order (oldest connections listed first).
Option B: Export to CSV
This method allows you to access all of the results at once, even if there are more than 100 rows.
- Click Export Records.
The CSV file is generated and downloads. - Open the CSV file in a spreadsheet application, such as Microsoft Excel.
- Sort the results by the
lastConnectedDatecolumn.
Use case 2: Plan device migration
The device status report can identify devices running a particular operating system in an organization and help determine which devices need to be migrated to a newer operating system.
Run the report
- Submit a search query with the following parameters selected:
- Organization: Specify the organization you are planning to migrate.
- OS: Select the operating system of the devices to be migrated.
- Click Run Report.
- Show the operating system version for each device:
- Click the column selector icon .
- Select OS Version.
- Click anywhere outside the column selector to return to the search results.
- Click the column selector icon
View results: Export to CSV
This method allows you to sort by OS Version and access all of the results at once, even if there are more than 100 rows.
- Click Export Records.
The CSV file is generated and downloads. - Open the CSV file in the spreadsheet application, such as Microsoft Excel.
- Sort the results by the
osVersioncolumn.
Use case 3: Purge cold storage to free space
To locate archives that can be purged from cold storage, the device status report shows all devices with archives in cold storage, along with the date on which the devices last connected.
This is an example only. Before purging any archives from cold storage, confirm that the archives are no longer needed. Depending on your company's data retention policy, you may need to keep archives for a defined period of time.
Run the report
- Leave all search fields blank and click Run Report.
This returns all of the archives in your Code42 platform. - Review the values in the Cold Storage column:
- True indicates that a device's archive is in cold storage.
- False indicates that a device's archive is not in cold storage.
View results: Export to CSV
The best way to view the results is to export to a CSV file because you are receiving a list of all of the devices and archives in your Code42 environment. Viewing the results within the device status report requires you to page through the results if you have more than 100 devices.
- Click Export Records
The CSV file is generated and downloads. - Open the CSV file in a spreadsheet application, such as Microsoft Excel.
- Filter the results to show only the devices that have the
coldStoragecolumn set totrue.- True indicates that a device's archive is in cold storage.
- False indicates that a device's archive is not in cold storage.
- Sort the filtered list by
lastConnectedDateto identify the archives that are no longer needed. - Purge the archives to free up space.
Use case 4: Search external reference fields
The device status report also searches external reference fields for users, devices, and organizations. The external reference fields store optional free-form text comments added by administrators.
Run the report
- Search for devices with one or more of the custom metadata fields:
- User External Reference: Enter User ID or other reference information in the User field.
- Device External Reference: Enter device ID or reference information in the Device field.
- Organization External Reference: Enter organization ID or reference information on the Organization field.
- Click Run Report.
- Click the column selector icon
. - Select Device External Reference, Organization External Reference, or User External Reference.
- Click anywhere outside the column selector to return to the search results.
View results: Export to CSV
- Click Export Records.
The CSV file is generated and downloads. - Open the CSV file in the spreadsheet application, such as Microsoft Excel.
- Sort the results by
userExtRef,deviceExtRef, ororgExtRefcolumn.
Use case 5: Identify Code42 app upgrade problems
The device status report enables you to identify Code42 app devices that did not upgrade successfully. Once you identify devices that did not upgrade, take the necessary steps to troubleshoot the device configuration. In most cases, manually uninstalling and reinstalling the Code42 app corrects the issue.
Run the report
- From Device Status, select Active.
- (Optional) Add other filter criteria as appropriate to narrow the search. For example:
- Use the OS filter to limit results to only Windows devices.
- Use the Organization filter to limit results to a specific organization.
- Click Run Report.
View results
Option A: View results in the administration console
This method requires you to page through the results if there are more than 100 devices.
- Add the last connection date and Code42 app version for each device:
- Click the column selector icon .
- Select Last Connection Date and Client Version.
- Click anywhere outside the column selector to return to the search results.
- Click the column selector icon
- In the search results, click the Last Connection Date column heading to sort the results in ascending order (oldest connections listed first).
- Check for devices displaying an old version number that also have not connected since the date you upgraded your devices.
The last three digits of the version number denote the Code42 app version. For example, a device listing the version number 1446267600650 means the device is running Code42 app version 6.5.0.
Option B: Export results to CSV
This method allows you to access all of the results at once, even if there are more than 100 devices.
- Click Export Records.
The CSV file is generated and downloads. - Open the CSV file in a spreadsheet application, such as Microsoft Excel.
- Sort the results by the
lastConnectedDatecolumn. - Check for devices displaying an old version number that also have not connected since the date you upgraded your devices.
The last three digits of the version number denote the Code42 app version. For example, a device listing the version number 1446267600650 means the device is running Code42 app version 6.5.0.
Code42 server version 6.5.2 and earlier
Click the + icon in the heading above to show use cases for Code42 server 6.5.2 and earlier. Click the x icon to hide them.
Run a device status report
- Sign in to the administration console.
- Navigate to the Reporting web app.
- (Version 6.5.x and later) Choose Reporting in the left menu.
- (Version 6.0.x and earlier) From the application selector in the upper right, choose Reporting.
- Select the Device Status report.
- Enter your search parameters, such as user, device status, and OS.
- Click Run Report.
- (Optional) Click Export All As CSV to generate and download the report as a CSV file.
- (Optional) Click the table configuration options icon
to show or hide columns.
Example use cases of the device status report
Use case 1: Backup status
Using the device status report, you can easily identify which devices have not backed up for a long period of time.
Run the report
To find the active devices that have not backed up for a period of time:
- From User Status, select Active.
- (Optional) Under Restrict to UID, refine your search by Organization, User, Device, or Destination as necessary.
- Click Run Report.
View results
Option A: Sort by last connected date
This method requires you to page through the results if there are more than 50 rows.
In the search results, click the Last Activity column heading to sort your results in descending order (most recent connections listed first).
Option B: Export to CSV
This method allows you to access all of the results at once, even if there are more than 50 rows.
- Click Export All As CSV.
The CSV file is generated and downloads. - Open the CSV file in a spreadsheet application, such as Microsoft Excel.
- Sort the results by the
lastConnectedDateoutput value.
Use case 2: Plan device migration
The device status report can identify devices running a particular operating system in an organization and how many devices will need to be migrated to replacements.
Run the report
To identify devices running a particular operating system within an organization:
- Submit a search query with the following parameters selected:
- Organization: Specify the organization you are planning to migrate.
- OS: Select the operating system of the devices to be migrated.
- Show OS version for each device:
- Click the table configuration options icon ().
- Select OS Version.
- Click OK.
- Click the table configuration options icon (
View results
Export to CSV
This method allows you to sort by OS Version and access all of the results at once, even if there are more than 50 rows.
- Click Export All As CSV.
The CSV file is generated and downloads. - Open the CSV file in the spreadsheet application, such as Microsoft Excel.
- Sort the results by the
osVersionoutput value.
Use case 3: Purge cold storage to free space
To locate archives that can be purged from cold storage, the device status report shows all devices with archives in cold storage, along with the date on which the devices last connected.
This is an example only. Before purging any archives from cold storage, confirm that the archives are no longer needed. Depending on your company's data retention policy, archives may need to be kept for a defined period of time.
Run the report
- Submit a search query with all of the search parameters left blank in order to search all of the archives in your Code42 platform.
- Show the cold storage for each device:
- Click the table configuration options icon ().
- Select Cold storage.
- Click OK.
- Click the table configuration options icon (
View results: Export to CSV
The best way to utilize the results of this query is to export the results to a CSV file because you are receiving a list of all of the devices and archives in your Code42 environment. Viewing the results within the Reporting web app would likely require you to page through the results.
- Click Export All As CSV.
The CSV file is generated and downloads. - Open the CSV file in a spreadsheet application, such as Microsoft Excel.
- Filter the results to show only the devices that have
coldStorageoutput values set totrue.- True indicates that a device's archive is in cold storage.
- False indicates that a device's archive is not in cold storage.
- Sort the filtered list by
lastConnectedDateto identify the archives that are no longer needed. - Purge the archives to free up space.
Use case 4: Search with custom metadata fields
The device status report also searches reference fields, which are used to store descriptive information for users (userExtRef), devices (computerExtRef) and organizations (orgExtRef).
Run the report
- Search for devices with one or more of the custom metadata fields:
- User External Reference: Enter User ID or other reference information in the User field.
- Device External Reference: Enter device ID or reference information in the Device field.
- Organization External Reference: Enter organization ID or reference information on the Organization field.
- Click the table configuration options icon ().
- Select Device External Reference, Organization External Reference, or User External Reference
- Click OK.
View results
- Click Export All As CSV.
The CSV file is generated and downloads. - Open the CSV file in the spreadsheet application, such as Microsoft Excel.
- Sort the results by
userExtRef,computerExtRef,orgExtRefoutput value.
Use case 5: Identify Code42 app upgrade problems
The device status report enables you to identify Code42 app devices that did not upgrade successfully. Once you identify devices that did not upgrade, take the necessary steps to troubleshoot the device configuration. In most cases, manually uninstalling and reinstalling the Code42 app corrects the issue.
Run the report
- From Device Status, select Active.
- (Optional) Add other filter criteria as appropriate to narrow the search. For example:
- Use the OS filter to limit results to only Windows devices.
- Use the Restrict to UID filter to limit results to a specific organization.
- Click Run Report.
View results
Option A: View results in the Reporting web app
This method requires you to page through the results if there are more than 50 devices.
- Add the last connection date and Code42 app version for each device:
- Click the table configuration options icon ().
- Select Last Connected Date and Version.
- Click OK.
- Click the table configuration options icon (
- In the search results, click the Last Connected Date column heading to sort the results in ascending order (oldest connections listed first).
- Check for devices displaying an old version number that also have not connected since the date you upgraded your devices.
The last three digits of the version number denote the Code42 app version. For example, a device listing the version number 1446267600512 means the device is running Code42 app version 5.1.2.
Option B: Export results to CSV
This method allows you to access all of the results at once, even if there are more than 50 devices.
- Click Export All As CSV.
The CSV file is generated and downloads. - Open the CSV file in a spreadsheet application, such as Microsoft Excel.
- Sort the results by the
lastConnectedDatecolumn. - Check for devices displaying an old version number that also have not connected since the date you upgraded your devices.
The last three digits of the version number denote the Code42 app version. For example, a device listing the version number 1446267600512 means the device is running Code42 app version 5.1.2.