Test Definitions. Test Number Test Description Asset Number Tests

Download (0)

Full text

(1)

Test Definitions

Test Number

01.0

Test Description

Asset Number Tests

Definition of Test

All tests in the 01 series have to do specifically with asset number.

Test Number

01.1

Test Description

Check for MOD137

Definition of Test

The asset number is tested to see if it complies with the MOD137 checksum scheme. If MOD137 checksum asset tags were used, this test should be invoked to ensure all asset numbers are valid.

Test Number

01.2

Test Description

Check for duplicates

Definition of Test

The database is scanned for duplicate asset numbers. The sources may range from using generic placeholders such as "No data" to wholly duplicated records. The report will show the serial numbers of the two offending records. This allows tracking back to the data to find out why duplicates have been reported. There should be no duplicate asset numbers in an asset tracking system. The test for duplicates is not performed on records that have blank asset numbers, as they must first be fixed with a value.

(2)

01.3 Check for blanks

Definition of Test

All records are tested for blank asset numbers. There should be no blank asset numbers in an asset tracking system. The detailed report lists every record that was found to have a blank asset number.

Test Number

01.4

Test Description

Check for acceptable length

Definition of Test

All records are tested to ensure the length of the asset number falls within an acceptable range. Ideally, only one uniform length should be used - 8 digits with the 8th digit being a MOD137 checksum digit. All records that fail to comply are shown in the detailed report along with the actual length found. Length tests are not performed on those records that have blank asset numbers.

Test Number

02.0

Test Description

Serial Number Tests

Definition of Test

All tests in the 02 series have to do specifically with serial number.

Test Number

02.1

Test Description

Check for duplicates

Definition of Test

The database is scanned for dulicate serial numbers. The causes are similar to duplicate asset numbers. The detailed report will show the asset numbers of the offending records, allowing tracking back to the data for further investigation. Duplicate tests are not performed on records that have blank serial numbers.

(3)

02.2 Check for blanks

Definition of Test

All records are tested for blank serial numbers. The detailed report lists every record that was found to have a blank serial number.

Test Number

02.3

Test Description

Check against specs

Definition of Test

All records that have a non-blank serial number are tested against serial number templates previously defined. For instance, a template for Compaq serial numbers may have been defined as "XXXXXXXXXXXX", which specifies a 12-digit long serial number composed of alphanumeric characters. The test is conducted by first attempting to look-up the specific asset type and manufacturer in the templates table. Failing that look-up, just the manufacturer is used to see if a generic template has been defined for that manufacturer. If so, the template is used. If no template has been defined, or if the manufacturer cannot be found in the templates table, the test is skipped. The detailed report shows the reason for failing the specification test for each record that failed.

Test Number

03.0

Test Description

Check for blank model

Definition of Test

All records are tested for blank models. The detailed report lists every record that was found to have a blank model.

Test Number

04.0

Test Description

Check for blank prod desc

Definition of Test

All records are tested for blank product descriptions. The detailed report lists every record that was found to have a blank product description.

(4)

05.0 Check for blank cost center

Definition of Test

All records are tested for blank cost centers. The detailed report lists every record that was found to have a blank cost center.

Test Number

06.0

Test Description

Check for blank assignee

Definition of Test

All records are tested for blank assignees. The detailed report lists every record that was found to have a blank assignee.

Test Number

07.0

Test Description

Check for blank site

Definition of Test

All records are tested for blank sites. The detailed report lists every record that was found to have a blank site.

Test Number

08.0

Test Description

Check for blank type

Definition of Test

All records are tested for blank asset types. The detailed report lists every record that was found to have a blank asset type. There should be no records with blank asset type in an asset tracking system.

(5)

09.0 Check for blank manufacturer

Definition of Test

All records are tested for blank manufacturers. The detailed report lists every record that was found to have a blank manufacturer.

Test Number

10.0

Test Description

Different mfr for same prod

Definition of Test

The database is scanned looking for records that show different manufacturers for the same product description. For instance, a product description of "Laserjet 600MP" may show manufacturers of "DELL, COMPAQ, HP". Also, it may show manufacturers of "HP" and "HEWLETT PACKARD". This test can show assets which were miscoded as well as

standardization issues with manufacturer naming. The detailed report shows each occurrence found, but not each record that participated. To correct, a query on the specific product description should be used to narrow the record scope, the each record in that scope should be checked for correctness.

Test Number

11.0

Test Description

Different type for same prod

Definition of Test

The database is scanned looking for records that show different asset types for the same product description. For example, a product description may show "SMARTUPS 1200", yet the asset types may show "UPS, EXTERNAL MODEM", which usually indicates improper asset coding for asset type. The detailed report shows each occurrence and not each record that participated in the occurrence. To correct these issues, a query must be used on the reported offending product description in order to narrow the scope to just those records. Then each record in that scope must be scanned for correctness.

Figure

Updating...

References