Export Custom Fields using Reports in PDQ Inventory

PDQ Inventory

Custom Fields iconSo, you’re ready to make the switch to Central Server mode in PDQ Inventory and indulge in all the sweet, sweet goodness it provides?  Hurray! Welcome to the club!

But, what about all that awesome custom data in your local database? You know, that data that you painstakingly input by hand for each and every computer in your database?

How are you going to get all that fancy data into the database housed on the server?!

“Good news, everybody!” It’s fairly straightforward to grab and export this info using a PDQ Inventory report. I’ve broken it down for you into 3 easy parts. (If you would rather use PowerShell, see Part 2 of this blog.)

Part 1: Identify Custom Fields to Export

You will need to identify you have the correct Custom Fields that you wish to export.

  1. While the console is in Local mode (prior to switching to Client mode), select Options > Custom Fields to identify you are viewing the Custom Fields you want to export.
  2. Take a screenshot so you will have the list of the Custom Fields names in front of you.

Custom Fields

Part 2: Create a Report of Custom Fields

You’ll need to add the Custom Fields individually as columns to be able to see them in the report.

  1. While still running in Local mode, select New Report > Basic Report.

Create a new Basic Report

  1. Give it a name like ‘Corgis Rule’ or something you’ll remember.
  2. Leave the first row, as is. This will ensure the data entered for each Custom Field will display per computer.
  3. On the second row under Table, select Computer.
  4. Under Column, select one of your Custom Field Names (this is where your screenshot will come in handy). Adjust the Title, if needed.

Last Use Snagit

  1. Rinse and repeat for each Custom Field.
  2. Click Save.

Each Custom Field is located in the Computer Table

Part 3: Run the Report of Custom Fields

With all of the columns defined, you’ll simply need to run the report and save it to file. You can export to your selected file type, however, a .csv file is required to use the Custom Fields Import Wizard.

  1. Click Run Report.
  2. Save the data as a .csv file by clicking Save Data to File.

Custom Fields Export.csv

  1. Your Custom Fields are now safely tucked away for future use.
  2. To import these Custom Fields into another PDQ Inventory console, please refer to this wonderful guide.

Wrapping Up

This blog’s main intent is to help you get your Custom Fields data exported in preparation for a migration to Central Server. However, you can also use the export as a backup for your custom data, or even a simple way to sync up different PDQ Inventory databases.

Whatever the case may be, I hope that it helps you out.

See Part Two when we showcase how to export Custom Field data via PowerShell. Because… PowerShell!

For a real-time demo, see the video listed below:

Leave a Reply

Your email address will not be published. Required fields are marked *