How to create a report/dashboard showing network assets with Install Date and End-of-Life Date in Zu

[akarumuri]

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:

1. What is the correct set of CI classes to filter for switch, router, firewall, UPS, and server assets?
2. Which table fields represent the Install Date and EOL Date?
3. Is there a best‑practice way to create a report that consolidates all these CIs in one list?
4. 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!

[KPNow]

Hi @akarumuri :

To pull all these devices into a single list report, you’ll want to stick with the base Configuration Item (cmdb_ci) table or the Hardware (cmdb_ci_hardware) table which naturally inherits attributes like Manufacturer, Serial number, and Install date (install_date). For End-of-Life, ServiceNow typically tracks this via the end_of_life or warranty_expiration fields on the CI record, though if you're leveraging Hardware Asset Management (HAM), the normalized lifecycle date sits in the sn_ent_life_cycle_stage_status table linked through CSDM/HAM lifecycles. To capture every required asset without missing edge cases, set your report filter's class condition to "Is a A" (or use Class is one of) for IP Switch (cmdb_ci_ip_switch), IP Router(cmdb_ci_router), IP Firewall (cmdb_ci_ip_firewall), UPS (cmdb_ci_ups), and Server (cmdb_ci_server—which automatically captures all physical and virtual child classes like Linux, Windows, and VMware ESXi). In the Report Builder (or Platform Analytics Visualizations), set your Type directly to List, then customize your visible columns to add Name, Class, Install date, End-of-Life date, Manufacturer, and Serial number.

Once your list report is built and saved, navigating over to the Zurich Platform Analytics Workspace makes adding it to a dashboard straightforward. Open your target dashboard (or create a new one via Platform Analytics > Dashboards), click Edit in the top right to enter layout mode, and select Add Component (the plus icon). Choose Data Visualization, select your newly created report as the data source (or build a inline List visualization pointing to cmdb_ci using the exact same filters and column layouts), drag the widget card to resize it on your grid canvas, and click Save. This gives your team a centralized, live operational view of hardware lifecycles across both network and compute infrastructure without having to dig through separate CMDB tables.