M.A. Hochberg’s Technology for Teaching

Here’s how I printed the labels for our computers. If you already have the serial numbers in a spreadsheet, you can skip steps 1-3.

1. Use ARD to get a report for each computer. The report needs to include the serial number. You can include as much or little information as you would like. As this is the hardest part of the process, I get all the information as I don’t want to do it again. I can use this report for many other things so it is very worthwhile.
2. Export the report and open it in Excel. It’s well formatted so I just click on “finish” immediately.
3. I made a working copy of the spreadsheet and deleted any columns I didn’t need for this project.
4. I used the spreadsheet to figure out the MID for each computer and added it as a new column.
5. Now I added two more columns: one for the OS and one for the Base Image.
6. Once those were done, I saved and closed the file.
7. I opened MS Word and used the label and data merge tools to create the labels for each computer.

Here’s a sample of the label. I included the “Info 1” field as that will be our local name for the computer. This will make it much easier to be sure that I have the right label on each computer too.

This entry was posted on Tuesday, June 9th, 2009 at 4:21 pm and is filed under Tech Support, User Support. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.