ServiceNow cmdb_ci table

[sonal_crest]

Does cmdb_ci table contains all the company managed devices data? Also, can we apply any filter on cmdb_ci table to fetch company managed devices data?

[CMDB Whisperer]

That's because MAC Address and IP Address are configuration data.  They are not inherent to an asset (well arguably MAC Address may be, but it is still considered configuration data.)  Configuration data is how the device is configured.  And yes you can always dot-walk from one to the other at will.  For example, I can view a list of Configuration Items and their Asset fields (if those asset fields are not already on the CI as well, which many of them are).  If I am looking at cmdb_ci_computer records I can just dot walk via the asset attribute to see  any asset field I want to see, such as cmdb_ci.computer.asset.warranty_expiration for example. 

Just be careful going in the other direction because not all CI classes have the same fields, so you won't necessarily know which fields on a CI when you are coming from the asset class, so some of the fields will be empty if the class of that CI doesn't have that attribute.