SG-SCCM Invalid serial numbers

Emanuele Zof
Tera Expert

‎09-20-2022 12:54 AM

Hi all,

"SCCM 2016" plugin use "SncSerialNumber" function so the condition to determine if a serial number is "valid = false" are:
1) Serial number is empty.
2) Serial number is composed of the same repeating character.
3) Serial number meets any of the conditions listed under dscy_invalid_serial.

Reference: KB0744965

Question:
1) Does SG-SCCM plugin use the above to determine if a serial number is valid?
2) If yes, have I to add custom entries on "dscy_invalid_serial" table?
3) If no, which logic is used and where I could setup custom values?

Thanks for the help.

  • 1,245 Views
3 REPLIES 3

Not applicable

‎09-20-2022 05:50 AM

All Service Graph connectors go through the Cleanse Serial Number operation.  This operation has a list of invalid serial numbers.  You can modify that list to account for your invalid serial numbers.

Please see this post for further details.

0 Helpfuls

Emanuele Zof
Tera Expert
In response to

‎09-21-2022 12:40 AM

Hi jgates,

thanks for the response, could you please clarify the below:

  • the Cleanse Serial Number operation script first check the validity of the input via the function: 
    • var valid = new global.SerialNumberManager().isValid(input)
  • then loop throught the invalidStrings array and check the related validity:
    • for (j = 0; j < invalidStrings.length; j++) {
                      if (inputLowercase.includes(invalidStrings[j])) {
                          output[i] = '';
                          break;
                      }
                  }
  • I seen that global.SerialNumberManager isValid function uses the SncSerialNumber(), so check the entries against dscy_invalid_serial table
  • So I doesn't understand why are performed two checks for input validity (since some of the entries on invalidStrings are already into dscy_invalid_serial table)

Thanks for the help.

HeyMarkWarmack
Tera Expert

‎05-15-2025 10:22 AM

Did anyone resolve this?  After Yokohama upgrade my 'SCCM Computer Identity' job is showing a handful of serial_number errors.  Just an annoyance.

Example error: 

CEX0014912 - Service Graph Connector for Microsoft SCCM
Error - SCCM Computer Identity
CISET0018227
Identification Reconciliation Engine(IRE) Processing errors-> 1: Found duplicate records in table [cmdb_ci_hardware] using fields [serial_number].
Found duplicate records in lookup table [cmdb_serial_number] (sys_ids: [2248cd77336d5614d8b0d4e45d5c7b7b, c43e01a147e635540b5a3627e26d43a9])  using fields [serial_number,serial_number_type] and reference field [cmdb_ci]
 
I see the Valid = false entries in the cmdb_serial_number.list table but feel like I am playing wack-a-mole and think there has to be a rule or something that isn't enabled to flip those so I don't get the errors.  I used to have 100% zero import errors for SG-SCCM, SG-Intune and SG-JAMF.  The only one right now is the "SCCM Computer Identity" job.
 
Anyone have any Yokohama info??
Thanks!
0 Helpfuls