Column Index

One entry per intake sheet column. Headings match the column names exactly, so searching a column name lands here.

Name

The family: MacBook Pro, MacBook Air, or MacBook.

ioreg -l | grep -i '"product-name"'

"product-name" = <"MacBook Pro (14-inch, Nov 2023)">

Works in recoveryOS, where system_profiler frequently doesn't. Booted into macOS, system_profiler SPHardwareDataType reports the same thing on its Model Name line.

Intel Identifiers name the family themselves (MacBookPro15,2 → MacBook Pro). Apple Silicon ones don't (Mac15,6 names nothing) — use the command above or look the Identifier up.

Serial

ioreg -l | grep -i IOPlatformSerialNumber

"IOPlatformSerialNumber" = "RW2D0HDQRJ"

Works in Recovery and booted. Also printed on the chassis bottom, and included in system_profiler SPHardwareDataType when booted.

Identifier

sysctl -n hw.model

Mac15,6

Record it exactly as surfaced — MacBookAir8,1, no spaces around the comma, matching the original casing. The model lookup keys on this exact string, and its Identifier filter takes it directly.

Model

The A-number — A1989, A2442. Engraved on the bottom of the chassis next to the regulatory marks, readable without powering the unit on.

If the engraving is worn or the bottom case was replaced, look the Identifier up on the model lookup and read the Model Number column.

Some rows list an A-number per screen size (A1278 (13") / A1286 (15")) — pick by the display size you measured in Step 1.

Battery

# Recovery
ioreg -rc AppleSmartBattery | egrep "DesignCapacity|MaxCapacity|CycleCount"

# Booted into macOS — preferred
system_profiler SPPowerDataType

Record health % and cycle count. The unit MaxCapacity reports differs by era, and Apple Silicon needs AppleRawMaxCapacity instead — full interpretation and the health formula are in Step 7.

Rated maximum cycles by model are in the Battery column of the model lookup.

Year

Derived from the Identifier via the model lookup — the Year column.

Not reliably available from any command: sysctl reports the Identifier, not a release date, and the serial number's date encoding was dropped for randomized serials in 2021.

RAM

sysctl -n hw.memsize

17179869184

Raw bytes, not GB. Match the number against the table rather than doing the math:

Apple Silicon reports unified memory here the same way — the number means the same thing, it just isn't upgradeable.

HD

diskutil info disk0 | grep "Disk Size"

Disk Size: 500.3 GB (500277792768 Bytes)

Disk Size reports raw formatted capacity, which reads a few percent under the marketed size. Round up to the nearest standard capacity:

Drop the | grep to also see SMART Status and the SSD's model name. Cross-check in Disk Utility with Show All Devices on — see Step 9.

If no internal disk is listed, record HD = none and flag the unit.

CPU

sysctl -n machdep.cpu.brand_string

Intel(R) Core(TM) i5-8210Y CPU @ 1.60GHz   →   record: i5-8210Y

Confirm the architecture with uname -m: arm64 = Apple Silicon, x86_64 = Intel.

Physical Issues

No command. Visual inspection from Step 1: cosmetic damage, screen condition, keyboard, missing screws, liquid damage indicators, engraving, missing charger, missing SSD.

Functional Issues

Power-on checks from Step 1, plus Apple Diagnostics (Intel: hold D; Apple Silicon: hold power → ⌘D) — record any reference codes.

Booted into macOS, these confirm specific subsystems:

diskutil info disk0 | grep -i smart          # SSD health
system_profiler SPCameraDataType             # camera present?
system_profiler SPAirPortDataType            # Wi-Fi card recognized?
system_profiler SPThunderboltDataType        # ports alive
system_profiler SPDisplaysDataType           # display + GPU
ls /Library/Logs/DiagnosticReports           # .panic files = failing RAM / board / thermals
softwareupdate --list                        # latest supported macOS

Firmware Locked

firmwarepasswd -check

Intel only. Run it in Recovery — you're already root, no sudo needed. Apple Silicon has no firmware password; record N/A.

No if you never saw a padlock at boot. If you did, see Step 3 for removal.

OS Reset

Disk Utility → Erase Volume Group on Macintosh HD, then reinstall macOS from the macOS Utilities window. Full procedure and the T2/Apple Silicon warning: Step 9.

These verify the unit is actually clean afterwards:

fdesetup status            # FileVault — should read Off
dscl . list /Users         # one admin account, no leftover human names
scutil --get ComputerName  # should default to the model name
csrutil status             # SIP should be enabled
sw_vers                    # which macOS it shipped out on

Erasing does not clear Activation Lock or DEP enrollment — check Step 8 first.

Activation Lock

# Booted into macOS
system_profiler SPHardwareDataType | grep -i "Activation Lock"

Activation Lock Status: Disabled

One of enabled, disabled, unsupported, unknown. Record unsupported on pre-T2 Intel machines, which have no Activation Lock at all. Full procedure in Step 8.

MDM Enrolled

profiles status -type enrollment

Enrolled via DEP: Yes
MDM enrollment: Yes (User Approved)

One of yes, no, unknown. Enrolled via DEP: Yes means the unit re-enrolls itself after any erase, so it stays a blocker regardless of what OS Reset says. Same rule as above — record unknown when you couldn't check, never no.

Processed At / Ingested By

Manual. Date/time you finished intake, and your name.

Both are stamped automatically by the app: the wizard and the CSV importer record the moment you commit and the operator you signed in as. Columns with these names in an imported file are ignored — attribution on an append-only ledger has to reflect who actually put the row there.