This report is part of a series. See .
Actions
- Supply list of zombie servers to infrastructure team.
- Ask infra team to verify lack of application consumer per server. (Maybe missing apps is just a data quality issue? Seasonal variation?)
- Ask infra team to determine which servers can be repurposed or decommissioned.
- When cost model is complete, add cost to this report.
Data
REQUIRED
Servers.Server Count
Servers.App Consumer
USEFUL
Servers.Server ID
Servers.Location
Servers.OS
Servers.Environment
Servers.Purpose
Servers.Virtualization Profile
Servers.CPU Cores
Build the report
REPORT TITLE
(top) Ribbon > Report > HTML.
In Edit Content window, paste:
<span style="font-size:x-large">Zombie Servers (No App Relationship)</span>
KPI
(top) Ribbon > Report > KPI.
Select the newly added KPI.
(left) Project explorer > Tables > Servers > Server Count: Drag to KPIs area in KPI Configuration panel.
(left) Project explorer > Tables > Servers > App Consumer: Drag to Filters area in KPI Configuration panel.
Right-click App Consumer in Filters area > Edit.
Unselect all filter values (click None).
Check just the box for (Blank) > OK.
BAR CHART: COUNT BY OS
(top) Ribbon > Report > Chart.
Select newly added chart.
(left) Project explorer > Tables > Servers > OS: Drag to Axis area in Ad Hoc Component Configuration (AHCC) panel.
(left) Project explorer > Tables > Servers > Server Count: Drag to Values area in AHCC panel.
(left) Project explorer > Tables > Servers > App Consumer: Drag to Filters area in AHCC panel.
(top) Ribbon > Data > Sort: Servers Master Data.Server Count.
Right-click App Consumer in Filters area > Edit.
Unselect all filter values (click None).
Check just the box for (Blank) > OK.
Right-click chart > Properties:
Chart > Legend location: Hidden.
General > Name: Zombie Servers: Count by OS.
General > Show header: Check box.
BAR CHART: COUNT BY ENVIRONMENT
Right-click Zombie Servers: Count by OS chart > Copy to clipboard.
(bottom right) Report clipboard > Paste all.
Click and drag pasted chart to any new location.
Remove OS from Axis area in Ad Hoc Component Configuration panel.
(left) Project explorer > Tables > Servers > Environment: Drag to Axis area in AHCC panel.
Right-click chart > Properties:
General > Name: Zombie Servers: Count by Environment.
BAR CHART: COUNT BY PURPOSE
Right-click Zombie Servers: Count by OS chart > Copy to clipboard.
(bottom right) Report clipboard > Paste all.
Click and drag pasted chart to any new location.
Remove OS from Axis area in Ad Hoc Component Configuration panel.
(left) Project explorer > Tables > Servers > Purpose: Drag to Axis area in AHCC panel.
Right-click chart > Properties:
General > Name: Zombie Servers: Count by Purpose.
DETAILS TABLE
(top) Ribbon > Report > Table.
Select newly added table.
(left) Project explorer > Tables > Servers > Server ID: Drag to Rows area in AHCC panel.
(left) Project explorer > Tables > Servers > Location: Drag to Rows area in AHCC panel.
(left) Project explorer > Tables > Servers > OS: Drag to Rows area in AHCC panel.
(left) Project explorer > Tables > Servers > Environment: Drag to Rows area in AHCC panel.
(left) Project explorer > Tables > Servers > Purpose: Drag to Rows area in AHCC panel.
(left) Project explorer > Tables > Servers > Virtualization Profile: Drag to Rows area in AHCC panel.
(left) Project explorer > Tables > Servers > CPU Cores: Drag to Values area in AHCC panel.
(left) Project explorer > Tables > Servers > Server Count: Drag to Values area in AHCC panel.
(left) Project explorer > Tables > Servers > App Consumer: Drag to Filters area in AHCC panel.
Right-click App Consumer in Filters area > Edit.
Unselect all filter values (click None).
Check just the box for (Blank) > OK.
Right-click table > Properties:
General > Name: Zombie Servers: Details.
General > Show header: Check box.