Hello Community,
I’m trying to create a report and dashboard in the Zurich release of ServiceNow that shows all of our network assets along with their In‑Service (Install) Date and End‑of‑Life (EOL) Date.
Specifically, I need to include these CI types:
- Switches
- Routers
- Firewalls
- UPS
- Servers (physical and virtual)
I created a report using the cmdb_ci table, but my report only shows counts (bar chart) and not the actual CI records with their dates. I want a List report that displays each CI with columns for:
- Name
- Class
- Install / In‑Service date
- End‑of‑Life (EOL) date
- Manufacturer
- Serial number
I attempted filtering by CI class (e.g., Router, Switch), but I am not sure which CI classes I need to include to capture all network devices and ensure EOL/Install dates appear.
Questions:
- What is the correct set of CI classes to filter for switch, router, firewall, UPS, and server assets?
- Which table fields represent the Install Date and EOL Date?
- Is there a best‑practice way to create a report that consolidates all these CIs in one list?
- Once the report is created, how do I properly add it to a dashboard in the Platform Analytics workspace?
Any guidance or examples would be greatly appreciated.
Thank you!
