Prevent the CMDB from updating the alm hardware table upon insert or update

[TylerJ333505898]

Currently we are trying to auto import data via the Qualys service graph plugin. This plugin auto updates the alm hardware table but our organization wants this to be isolated at this time. is there a way to prevent anything but a manual update from making changes to the alm_hardware table or to at least prevent cmdb_ci changes to affect this table? 

[Vishal Jaswal]

Hello @TylerJ333505898 

Remove the role for updating alm hardware table from the user account which you are using to import the data.

[TylerJ333505898]

The issue is the system is updating the table not a specific user

[Vishal Jaswal · Accepted solution]

Hello @TylerJ333505898 

Business Rule "Create Asset on insert" ends up updating the alm_hardware table that is why updated by is system:

[Shivalika]

Hello @TylerJ333505898 

Is there any specific user that reflects when qualys updates are made ? Like if update is my qualys - what name reflects ? 

Then you can add conditions in before update business rule that "Updated by" - abort action. This is actually best practise there must be specific service accounts made for these imports and updates. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY