is there any filter to get list of CI's using mac address

[varsha saste]

Hello I am finding any filter to get CI's using mac address i have issue in this on computer table the record not showing mac address but after opening record in network adapter tab i see a mac address. i want filter to find CI's using respective network adapters mac addresses.

[Alberto Consonn]

Hi,

the MAC Address is not available for the CI of class Computer, it's an attribute available only for the "Network" CIs, that's the reason why you can't find the MAC Address field as OOTB.

Hope this will be useful for you.

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[varsha saste]

Is there any way  to fetch computers CI's using networks mac address??

[Harshinya1]

Network adapter table is a relationship table. You can directly navigate to that table as below. you will find Cis and their Mac address

Hope this helps

[Alexey7]

Maybe it will be repetitive, but on the first screenshot you are looking for MAC address at the cmdb_ci_computer table, on the second screenshot you're looking at different table cmdb_ci_network_adapter. You can populate mac_address field on cmdb_ci_computer table to be able to search and filter by MAC address.