This website uses cookies. By continuing to browse or login to this website, you consent to the use of cookies. Learn more.
OK
Chris_Jelinek
Absent Member.. Absent Member..
Absent Member..
‎2012-03-19 14:31
195 views

what is the purpose of the id field in the device table?

SM 7.11

a) By replicating data from ucmdb to SM the id field is not populated in every case, so some records have left it as NULL on creation.

b) if a ucmdb object gets renamed and it is reconciled via the ucmdb.id then the corresponding SM object also gets renamed, but the id field is left unchanged, so multiple records of the device table have the same id value (not to be confused with logical.name, that must be unique).

 

What are the effects I have to cope with, if having duplicate or NULL valued id fields?

 

One known effect is: Audit records can't be associated correctly.

Are there other disadvantages?

 

BR Chris

0 Likes
Reply
Report Inappropriate Content
1 Reply
Vadim Gorda
Fleet Admiral Fleet Admiral
Fleet Admiral
‎2012-03-20 06:02

Hello,

I am not 100% sure but it miight be a key for that table. I ma not using OOB system so you have to recheck that.

Best Regards
Vadim

HOW TO ASSIGN POINTS - Kudos - what, where, how, and why
New Forum Locations by ITRC Tree
New Forums Site Map
Want Good Answers? Ask Good Questions...
0 Likes
Reply
Report Inappropriate Content
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.