Is there a way to populate the Company field on the CI records?

[Astrid Peraza1]

We are currently using Discovery to manage our inventory. We have discovery schedules setup with an specific location that run every day for different IP addresses range. However, we are running into the issue that the Company field is not being populated for the CIs, therefore the assets created don't have a company either. When I run Discovery, the location is set up properly, but the company stays empty. I have tried different types of Business Rules, but nothing seems to work. We are not domain separated, which means all of our inventory is in the global domain.

Is there something that can set the Company of the record to be  the company of the Location?

Thank you.  

[Michael Ritchie · Accepted solution]

Did you try a business rule that runs on insert and update IF the company is NULL?  Then in the Set Actions set the company to the same as location.company?  This shouldn't require scripting.

[Astrid Peraza1]

Yes, I have created a Business Rule with those conditions and the action you are suggesting, but it still doesn't work, the company is still being set to empty for new records and  it does't populate the company for the existing ones. 

[John Vo1]

Michael,

Where do you put IF company is NULL?

Thanks,

John

[Baala T]

Hi Astrid,

Few things to be checked,

• Does the Run As account has access to Company Table?
• Are we hard coding the Company Name, if so check one of discovered CI in XML view, the company name would have been set as sys_id

Regards,
Bala T