Best way to associated environment to CI in CMDB

[SudhirOjha]

HI,

I need to associate environments with CI i.e. servers, DB .

Which is the best way to associate environments to CI .

Thanks

Sudhir

[AshishKM]

You can create an Environment field (field type Choice )  in cmdb_ci table and add all applicable environment in choice list. This way you can use environment in all child tables. For all bulk upload map the CI environment with this field in transform map.

Environment List:

Stage , Production, Test, Development , Sandbox , Disaster Recovery , POC  ect.

Thanks,

Ashish

Please mark correct/or/hit helpful for others if it helps you.

[SanjivMeher]

There is a table cmdb_ci_environment, where you can store all the environments you have.

Then create relationship between environment and CI.

[SudhirOjha]

We have already a relationship table with CI- cmdb_environment_to_ci table.

but problem is that it doen't have exposed to itil users as other cmdb table.

[SanjivMeher]

Then you can create the required ACL to expose it