Discovery importing company data that doesnt link to CI Configuration Items

Les1 · ‎11-05-2018

Discovery is populating core_company with data that i dont see linked to CI's (expected to see them on the CI record for Company). When i go to our CI list and display Company column, there are no Companies listed.

Why are companies being imported via discovery to the company table if not linked to a CI?

ver: Kingston patch 7

thanks for your help in advance!

robertgeen · ‎11-06-2018

Les,

I haven't dealt with the core_company table much but if I had to guess I would say that it's happening when Manufacturer or some field like that is being set on the CI. This would also cause it to create an asset which more then likely is putting entries into that table as well.

If you look at the schema map for the core_company table you can see that it's being referenced by many of the cmdb tables as a few of their attributes actually reference that table and that table I believe has auto-create on so that if you set a value that doesn't exist it will auto create it. I hope that helps.

View solution in original post

Les1 · ‎11-15-2018

Thanks! will definitely look into that further.

@Rook - about your question of our data- correct if i bring up a list of All CI's, the Company column is always null, but the Manufacturer column has the discovered 'company' data. OOTB the manufacturer column wasn't displaying so was a little confusing as we entered into our first Discovery.

So now seeing this, and being able to apply a filter on catalog items to filter against all these device companies, i think we're good. thanks for the helpful responses everybody!