Case sensitivity in Name, Serial Number, etc

[robin850]

Having 2 records in my CMDB with identical names, other than one is UPPERCASE and one is lowercase, is not fun.

How did these get here and what can be done to prevent this?

We don't import this data nor do we manually enter it. It all comes in from the midserver or from the snc_discovery.js script.

What is the trick?


cheers,

robin850

[aleck_lin]

Not that I'm aware of, but if you can create a business rule that enforces the casing. Or maybe even using field normalization.

[michaelmassey]

Thanks for the input. I looked at field normalization, but did not see string as a field type to use it on. I will go with the Business Rule.

Thanks,
Michael