Difference between Switch Port tables dscy_switchport and cmdb_switch_port

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 07:44 AM
Hi,
I have noticed that on Switch CIs there is a tab called "SwitchPort" which references the dscy_switchport table.
However for Firewall CIs there is a tab called "Switch Port" which references cmdb_switch_port table.
Can anyone help me understand the two different tables?
Thanks
Alec
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2024 10:56 AM - edited 07-16-2024 11:00 AM
All I know is that [dscy_switchport] is part of the [cmdb_ci] table hierarchy whereas [cmdb_switch_port] is a standalone table. In any case, I believe both switches and firewalls should use the same table for switch ports related list. You may want to ask ServiceNow Technical Support why this is not the case. It could be a misconfiguration they would want to correct.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2024 07:55 AM
Thanks Slava, I know that Switches and Routers use the same and it is my expectation that Firewalls should be using the same.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2024 08:01 AM
Hi Alec,
On the [dscy_switchport] table, the record names are frequently updated during discovery although they are expected to remain the same. The sys_id and mac addresses do not change. This can be verified by enabling auditing on the [dscy_switchport.name] field.