Cornell Audit requested inventory of our all IT-related devices in Arts and Sciences, including the Chemistry Department
File format
- Data should be outputted to a CSV or Excel (Office 2016) file format.
What is covered
- Computers: desktops, laptops, servers, tablets
- Q: Printers?
Not phones.
Date type requested
From Frank:
| Data requested | Example | Our inventory field | Notes |
|---|---|---|---|
| Device Name | Dell | Asking Frank what he really wants. | |
| Type (desk/Laptop, tablet,networked printer) | desktop | ||
| OS | Mac | Asking Frank what he really wants. | |
| Department | CHEM | ||
| MAC address | 00:21:9B:4F:0B:11 | For laptops with no ethernet: Don't include OR use wireless MAC OR use dongle's MAC. Don't bother with second MACs. | |
| Last Updated (if available) | 7/20/2017 | ||
| NetID of Primary Owner | oh10 | Group, if not specific. | |
From Steve:
| Data requested | Example | Our inventory field | Notes |
|---|---|---|---|
| Brand | Dell | ||
| Type | desktop | ||
| User | Oliver | Group, if not specific | |
| A MAC address | 00:21:9B:4F:0B:11 | Laptops with no ethernet use wireless MAC or dongle's MAC | |
| OS | Mac | ||
| OS level | 10.12 | ||
| Location: Building | Baker | Room optional. If home, resolution of "off site" is good enough. | |