(v1) Expand Mac Address usage on Service Desk

Target release	2020.3
Document status	DONE
Document owner	David Engblom
Designer	David Engblom
QA	Karis Hathaway (Deactivated)
Last Modified	07 Apr 2020

Goals

To provide more places to see and update the MAC Address on Equipment records.
Allow third-party scanners to scan the MAC Address into the form.

Background and strategic fit

This functionality is necessary to make it easier to manage Equipment with a MAC Address and/or Serial Number, but may not have an Asset Tag or Equipment ID.

Assumptions

Any existing records that already have a MAC Address value, set will need to be unique. PCR will work with customers to pre-populate any data and will provide an AdHoc to fix duplicate MAC Address values.

Requirements

#	Title	User Story	Importance	Notes
1	MAC Address Unique	The user requires that the MAC Address value is unique across the application.	MUST HAVE	The MAC Address will be a unique value across all Equipment Records and enforced by a database constraint.
2	MAC Address on Grids	The user would like to see the Mac address on additional grids.	MUST HAVE	The following columns will be added to the Incident Equipment Grid, Order Equipment Grid, and Actions Equipment Grid. Equipment ID Asset Tag Serial Number MAC Address The current Equipment column will be changed to "Catalog" and just display the Equipment Catalog Name and Description. (Currently, this column contains a combination of Asset Tag/Equipment ID/Serial Number and the Equipment Catalog Description)
3	MAC Address on Printouts	The user would like to see the Mac address on Service Desk Printouts.	MUST HAVE	The following information will be added to the Service Desk Incidents, Orders and Actions Printouts. Equipment ID Serial Number MAC Address
4	MAC Address on Incidents	The user would like to see the Mac address on the Incident Equipment Form.	MUST HAVE	The MAC Address field will be enabled on Incident Equipment Form, just like it is on Service Desk Orders and Actions.
5	Barcode scanner support	The user would like to use a Barcode scanner to scan in the MAC Address on Service Desk Equipment forms.	MUST HAVE	The MAC Address field on Service Desk Equipment will accept both formatted and non-formatted MAC Addresses. Which will allow for third-party scanners to save a value into the field whether it is entered with or without a format. When the record is saved, PCR-360 will apply the format to the MAC Address, just like it does on the Equipment Form Network Tab.
6	Searching MAC Addresses	The user would require consistent MAC Address searching from the Equipment grid.	MUST HAVE	Saving a MAC Address from the Equipment form does not save the format separators; this allows for searching to work. However, when saving from the Service Desk EQP form the format separators are saved - this behavior needs to be consistent.
7	MAC Address Updating	The user would like MAC Address to NOT be updated on the Equipment until Service Desk Equipment is completed.	MUST HAVE	Saving a MAC Address from the Equipment form does not save the format separators; this allows for searching to work. However, when saving from the Service Desk EQP form the format separators are saved - this behavior needs to be consistent.
8	MAC Address on Bulk Add Equipment	The user would like to bulk add Equipment records, with the MAC Addresses.	NICE TO HAVE	MAC Address and other identifiers (Equipment ID, Asset Tag) should not be updated on the Equipment until the Service Desk Equipment is completed

User interaction and design

Questions

Below is a list of questions to be addressed as a result of this requirements document:

Question

Outcome

Will the new columns be displayed or hidden by default?

The Asset Tag, Equipment ID, Serial Number, and MAC Address columns will be shown by default.

The Catalog column will be visible on the grid when opening the Equipment Tab. The new columns will, by default, be placed as the last columns on the Equipment Grid.

The order and display of the columns can be changed by customers using Grid Perspectives.

Not Doing

We are not adding a Service Desk Equipment Import at this time. If we do add this import in the future, it will include the MAC Address.