Zero-configuration dashboard charts and reports provide at-a-glance insights about your data center. They enable you to make more informed decisions without all the hard work.

Category	Type	Widget Name	Date Created	Description

Items Inventory	SQL	Archived Item History	2017-01-12	This SQL can be applied to a dcTrack SQL Widget to report Archived items. To use this SQL on your dcTrack dashboard, download the txt file below and paste the contents into a dcTrack SQL Widget.
Space	SQL	Cabinet Elevation	2017-05-08	This SQL can be applied to a dcTrack SQL Widget to report all items in all cabinets sorted by Location, Cabinet, and U position. Each cabinet u position is indicated with the device that o...
Items Inventory	SQL	Query all the sensors with their associated devices	2017-08-02	This grid widget provides sensor details: Sensor port name, actual value, PDU name, Cabinet, and make/model of the cabinet.
Space	Chart	Cabinet Space By Location and Cabinet Group	2017-10-10	Shows the number of used vs. unused Rack Units filtered by Location, Cabinet Status,Item Status, and Cabinet Group. The percentage reflects the remaining cabinet space capacity or open rack units.
Items Inventory	Chart	Item Count By Customer and Type	2017-12-06	Shows the number of items for each selected customer grouped by the selected item types.
Items Inventory	Chart	Item Age in Years	2018-01-02	Shows the number of items of a certain age rounded down to nearest year based on the selected date and customer. Items less than 1 year old will show as 00:00:00. The items included are f...
Connectivity	SQL	Data Panel Ports	2018-02-01	Provides a list of data panels and their ports and connection status.
Cooling	Chart	Latest Temperature Per Rack By Cabinet Group	2018-03-02	Shows the min, max or average temperature in each cabinet for the selected sensor positions. The bars in the chart can be for all cabinets in the location having at least one sensor, or li...
Space	Chart	Available Cabinet Space By Field	2018-03-28	Shows the count of available rack units by key cabinet fields with drill down details including the total number of rack units, the number of used rack units, and the number of availabl...
Enterprise Overview	Chart	Permissions by Role	2018-05-31	Shows a count of Roles and object type to which the role is applied as well as drill-down data that shows each principal name (user or group) that has been given each specific role and on ...
Items Inventory	Chart	Hosts Per OS By Item Type	2018-06-04	Shows the number of devices (hosts) that run each operating system filtered by Location, IT Class, and Item Type. All Operating Systems can be shown or the ones running on the most or leas...
Connectivity	Chart	Data Ports Usage Per Port Properties and Cabinet	2018-06-08	Shows the number of connected and free (not connected) ports for the selected data port property within the selected location and filtered by item class and cabinet
Space	Chart	Cabinet Space By Cabinet Group per Cabinet	2018-06-13	Shows the number of used vs. unused Rack Units filtered by Location, Cabinet Status, Item Status, Cabinet Group, and Cabinet. The percentage reflects the remaining cabinet space capacity o...
Items Inventory	Chart	Item Count By Owner	2018-11-30	Shows the count of items by key owner field including installed and optionally, planned items. Items counted include the Cabinet, Device, Network, Rack PDU, and Probe classes. The Item Own...
Items Inventory	Chart	Months to Contract Expiration By Class	2018-12-04	Shows the Time interval in months between now the contract expiration date for the selected class of item in all locations. Items that have passed their expiration date are displayed as "e...
Power	SQL	Outlets with Draw and No Connection	2019-05-08	A SQL grid widget that uses measured values from Power IQ to illustrate which outlets are drawing power, but lack a connected device in dcTrack.
Power	SQL	Total Budget Watts per Rack	2019-05-08	A SQL grid widget that sums up the budget watts allotted for each device per rack.
Connectivity	SQL	Used Network Ports per Rack	2019-05-08	A SQL grid widget that shows all used network ports, connector type, connector name per rack.
Other	HTML	Windy.com Wind direction	2020-04-03	This HTML can be applied to a dcTrack HTML Widget to show the current Wind direction in the United States on your dashboard. Add a new HTML Widget to the dashboard, edit the widget set...
Other	HTML	Covid-19 Cases	2020-04-03	This HTML can be applied to a dcTrack HTML Widget to show the current Covid-19 Global Cases from Johns Hopkins University site on your dashboard. Add a new HTML Widget to the dashboard...
Other	HTML	Recent USGS Earthquakes	2020-04-03	This HTML can be applied to a dcTrack HTML Widget to show the recent USGS Earthquakes on your dashboard. Add a new HTML Widget to the dashboard, edit the widget settings and copy/paste...
Other	HTML	Lightning Strikes	2020-04-03	This HTML can be applied to a dcTrack HTML Widget to show the current Wind direction in the United States on your dashboard. Add a new HTML Widget to the dashboard, edit the widget set...
Space	SQL	Cabinet Elevations Without Passive Class	2020-07-13	A SQL grid widget that shows Location Code, Cabinet, Asset Name, U Position, Status, Class, Form Factor where the Class is device, network or rack PDU.
Connectivity	SQL	Data Ports Usage	2020-07-13	A SQL grid widget that shows Location Code, Cabinet, Asset Name, U Position, Total Data Ports on the Asset, Total Used Ports and Total Available Ports.
Connectivity	SQL	Rack PDU without a Power Source	2020-07-13	A SQL grid widget that shows Location Name, Location Code, Cabinet, Rack PDU, UPosition, and Inlet Name. This widget shows all RPDUs that has no power source.
Items Inventory	SQL	Models with 1 Power Supply	2020-07-13	This SQL grid widget shows Location Code, Cabinet, Asset Name, UPosition, Make and Model This widget is used to show all the assets that only have 1 power supply in the models library to d...
Space	SQL	Percent Cabinet Space Availability	2020-07-13	This SQL widget shows data center, row name, cabinet name, percentage of the cabinet that is used, percentage of the cabinet that is available. These values are calculated adding up the he...
Space	SQL	Percent Cabinet Space Available for Specific RUs	2020-07-13	This SQL widget shows data center, cabinet name, percent used of RUs 1-31 , percent used of RUs 1-31. These values are calculated adding up the height of devices within the RU 1-31 range a...
Data Reports	SQL	Library Version	2020-07-22	This SQL grid widget shows the library versions on your dcTrack system ordered decending.
Items Inventory	SQL	Depreciation	2020-07-24	This SQL grid widget displays asset name, purchase date, the age of the asset and the current value of the asset. The age of the asset is calculated by taking the current date minus the pu...
Power	SQL	Available Rack PDU Outlets Per Cabinet	2020-07-24	This SQL grid widget shows location, cabinet group, cabinet, rack PDU and outlet name of the available ports.
Power	SQL	Total Power Outlets per Cabinet by Type	2020-07-24	This SQL grid widget shows cabinet, connector type, and the total number of those outlet types in that cabinet.
Connectivity	SQL	Unconnected Power Supplies	2020-07-24	This SQL grid widget shows location, cabinet, asset name, UPosition, make, model, total number of power supplies on the asset, the name of the power supplies that are available.
Items Inventory	SQL	Item with MAC Address	2020-07-27	This SQL grid widget shows MAC Address, asset name, class and subclass.
Power	Chart	Actual and Planned Power vs Capacity	2020-07-30	This multi bar chart shows the actual and planned power versus the capacity per cabinet. The chart can be modified with the location and cabinet parameters.
Power	Chart	Fixed Energy Per Rack	2020-07-30	This line with focus chart shows a line for each cabinet denoting the Energy in Watt Hours for the selected location. The sum is derived from the Rack PDU level readings for the selected p...
Items Inventory	Chart	Item Age in Years by Customer	2020-07-30	Shows the number of items of a certain age rounded down to nearest year based on the selected date and customer. Items less than 1 year old will show as 00:00:00. The items included are fi...
Power	Chart	Actual and Planned Power vs Capacity by Pod	2020-07-30	Shows the sum of the actual active power in Watts plus the budget power for all planned items in the cabinet vs. the capacity of the cabinet for the selected cabinets. The actual values ar...
Items Inventory	Chart	Item Age in Months-Custom	2020-09-22	This multi-bar chart shows the number of items of a certain age in months based on the selected date. The items included are filtered by location and class. Negative dates indicate dates p...
Connectivity	SQL	Connections Work Orders	2020-09-23	This SQL grid widget shows work order information with circuit information including: work order number, status, request number, action, source location, source cabinet, source U Position,...
Items Inventory	Chart	Item Count By Model and Location	2020-09-23	A multi bar chart that shows all items of the selected make/model and class stacked by location.
Items Inventory	Chart	Item Count by Function and Class	2020-09-28	This multi-bar chart shows the count of all items in one or more classes and grouped by the selected function. The items are filtered by Location
Space	Chart	Cabinet Space Capacity in Percent	2020-09-29	Shows the capacity for space inside the cabinets in each location based on the number of rack units in percent. When an item is mounted to either or both front and back rails, that rack un...
Power	Chart	Active Power per PDU with Room Capacity	2020-10-20	Shows a line for each Rack PDU denoting the active power in Watts for the selected location. The sum is derived from the Rack PDU level readings for the selected period, granularity and st...
Space	Chart	Free Rack Unit Trend by Cabinet Group	2020-10-21	Shows the historical number of free Rack Unit for each day of the past year or for each month of the full history, for the selected locations and cabinet groups.
Space	Chart	Cabinet Space Used by Cabinet Group	2020-10-27	Shows the amount of used Rack Units filtered by Location, Cabinet Status, Item Status and Cabinet Group. The needle position reflects the used cabinet space capacity.
Power	Chart	Active Power One line Per Rack PDU by Cabinet Group	2020-10-27	Shows a line for each Rack PDU denoting the active power in Watts for the selected location. The sum is derived from the Rack PDU level readings for the selected period, granularity and ...
Items Inventory	Chart	Items by Function or Type Pie	2020-10-29	Shows how many items in each type or function there are for a Location where each slice of the pie is for a type or function. Excludes Archived items.
Items Inventory	Chart	Item Age in Months by Class/Subclass	2020-11-02	Shows the item age in months by various date fields by class/subclass for multiple locations.
Space	Chart	Rack Units per Type and Power /wo Archived Status	2020-11-11	Shows the number of used rack units by Type and the number of open rack units by available rack PDU outlets. Excludes items with status 'Archived.'
Space	Chart	Cabinet Space Remaining by Cabinet Group and Custom Fields	2020-12-03	Shows the number of used vs. unused Rack Units filtered by Location, Cabinet Status, Item Status, Cabinet Group and cabinet custom field pick. In the details grid, the percentage reflects ...
Space	Chart	Free Contiguous RUs by Cabinet Group	2020-12-09	Shows the count of contiguous RU chunks available in the selected cabinet group and cabinets.
Connectivity	SQL	Source to Destination Data Circuit Trace	2020-12-10	Shows source location, cabinet, asset name, port name, destination location, cabinet, asset name, port name in a SQL grid widget.
Items Inventory	SQL	Cabinet Details	2020-12-10	Shows location, cabinet name, item name, U Position, rails used, cabinet side, shelf position, make, model, RU height, serial number. Also includes chassis name, slot label, slot position,...
Connectivity	SQL	Data Ports	2020-12-10	Show location, cabinet name, item name, U Position, port name, sort order, port usage, connector type, color, media, speed, and protocol.
Connectivity	SQL	Data Circuit Details	2020-12-10	Shows Source Cabinet, U Position/Rails Used, Serial Number, Asset Tag, Item Name, Port Name, Circuit Status, Connector Type, Destination Cabinet, U Position/Rails Used, Serial Number, Asse...
Connectivity	Chart	Power Port Usage by Cabinet Group and Custom Field	2020-12-15	Shows the number of connected and free (not connected) power ports by Rack for each connector type currently in use within the selected location filtered by item class, cabinet group and custom field.
Power	Chart	Active Power One Line per Custom Field	2020-12-15	Shows a line for each custom field pick denoting the active power in Watts for the selected location, cabinet group, and custom field pick. The sum is derived from the Rack PDU level rea...
Items Inventory	Chart	Cabinet Count by Cabinet Group and Custom Field	2020-12-17	Shows how many cabinets in each cabinet group or custom field pick there are for a Location where each slice of the pie is for a group or custom field pick. Excludes Archived items.
Connectivity	SQL	Full Data Circuit Trace	2020-12-17	This SQL grid widget shows source location, cabinet, asset, nodes 1 -8 assets and ports, destination asset, and destination cabinet in both the forward and reverse direction.
Space	Chart	Percent Cabinet Space Remaining Gauge	2020-12-18	Shows the percent of remaining (or open) Rack Units filtered by Location, Cabinet Status, Cabinet Group.. The needle position reflects the percent remaining cabinet space capacity or open rack units.
Space	Chart	Cabinet Usage by Location and Cabinet Group	2021-01-07	Shows the number of used vs. unused Rack Units by Location filtered by Location, Cabinet Status, Item Status, and Cabinet Group. The percentage in the details grid reflects the remaining c...
Items Inventory	Chart	Item Age in Years by Item	2021-03-05	Shows the age of an asset in years based on selected item date field, class, make/model and cabinet. Where an age of 0 means the rounded year is less than 0.01. A negative age indicates a...
Change	SQL	Changes Made to Assets	2021-03-05	Shows the changes made to assets in a cabinet and any additions. These changes include location, name, status, asset tag, serial number, position, and cabinet.
Power	Chart	Actual Power by IT Device	2021-03-05	Shows the active power in Watts within the selected location and cabinets. The sum is derived from the IT Device level readings from all IT Devices. The chart can show one line that is the...
Power	Chart	Actual vs Capacity per Custom Field Pick	2021-03-05	Shows the sum of the actual active power in Watts and capacity in the cabinet(s) in the specified custom field pick. The actual values are based on the latest available readings from Power IQ.
Connectivity	SQL	Power Supplies Not Connected	2021-03-08	Shows all power supplies that are not connected in dcTrack.
Connectivity	SQL	Power Circuit Labels	2021-03-08	Shows the node number, the source asset, the source port, a label from asset to the next node and its inverse as a label. This widget produces labels for only direct connects and not the e...
Power	Chart	Budget Power Capacity vs Location Capacity Gauge	2021-03-16	Shows the amount of remaining power capacity for the selected location where the max value is the location power capacity in the settings/location page. When the consuming budget watts is ...
Space	Chart	Cabinet Space Remaining WO Blanking Plates Gauge	2021-03-16	Shows the amount of remaining (or open) Rack Units filtered by Location, Cabinet Status and Item Status. Blanking panels are not counted as used space. The needle position reflects the rem...
Power	Chart	Actual Power by Function	2021-04-02	Shows the actual active power per device and rack PDU function. The actual values are based on the latest available readings from Power IQ.
Connectivity	Chart	Data Port Usage By Cabinet	2021-04-16	Shows the number of connected and free (not connected) ports by Rack for each connector type currently in use within the selected location filtered by item class.
Space	Chart	Custom Range Cabinet Space Capacity	2021-04-23	Shows the capacity for space inside the cabinets in each location based on the selected starting and ending RU. The starting RU and ending RU range is 1 - 47. If the ending RU is larger th...
Space	Chart	Used RU Forecast	2021-04-23	Shows the forecast for used rack units based on installation date and custom field Decommission Date. The current date is represented by the current date minus one month, quarter or year; ...
Power	Chart	Potential Power vs Location Capacity by Country	2021-05-03	Shows, for each country, the total for the potential power from all power supplies factoring in the power supply redundancy and which are connected. Total capacity is calculated to be the ...
Items Inventory	Chart	Item Counts by Country	2021-05-03	Shows the number of items in each country grouped or stacked by class. Excludes items in the Archived and Storage status.
What-if	Chart	What If: RU and Power by Project	2021-05-05	Shows the impact on RU usage and/or Budget Power per project.
Power	Chart	Actual and Planned Power vs Capacity per Row	2021-05-05	Shows 3 data points for each selected row. The budget power, sum of all planned items in the selected cabinets as a bar labeled Planned, the actual active power, the sum of all installed i...
Enterprise Overview	Chart	Item Permissions Granted By Class	2021-05-05	Shows a count of assigned access roles by item class for all locations. The drill-down data shows the role assigned on each item along with the user or group that has been assigned a permi...
Connectivity	Chart	Data Port Usage by Row and Cabinet per Property	2021-05-05	Shows the number of connected and free (not connected) ports for the selected data port property within the selected location and filtered by row, cabinet, item class/subclass, function an...
Items Inventory	Chart	Item Percentage by Row	2021-05-05	This multi bar chart shows the percentage of assets based on the selected attributes, location and sub-locations.
Items Inventory	Chart	Contract Ending Dates Pie	2021-05-11	Shows how many items in each date range are approaching their contract end date.
Power	Chart	Actual Active Power vs Location Capacity	2021-05-11	Shows 2 bars for each selected location. The actual active power, the sum of all installed items in the selected location labeled Actaul, and the location capacity. The actual values are...
Change	Chart	Assets Changed in Cabinet	2021-05-11	Shows the count of changes made in a cabinet over a given period. A change is defined as an insert or an update to the following fields: Location, Cabinet, Cabinet Side, Name, Front Faces,...
Power	Chart	Inlet Utilization	2021-05-18	Shows count of inlets where the watts used is some percent range of the calculated nameplate value.
Items Inventory	Chart	Storage Inventory by Model	2021-05-20	This widget shows the item count for each model that in the Storage, Planned or Off-Site Status. The bars are grouped by Project Number.
Items Inventory	Chart	Host and VM Count by VM Manager	2021-07-14	Shows the number of items for each VM Manager. Only the items that are integrated with a VM Manager and have Integration Status are included in the count. VM and Host attributes like Opera...
Power	Chart	Actual Power: Min/Max/Avg Bar Chart	2021-07-15	Shows 3 bars for each selected cabinet. The min actual active power for the selected cabinet, period and granularity labeled 'Minimum', the average actual active power for the selected ca...
Space	Chart	Cabinet Space Capacity by Country	2021-07-15	Shows the capacity for space inside the cabinets in each country based on the number of rack units. When an item is mounted to either or both front and back rails, that rack unit is consid...
Connectivity	SQL	Structured Cabling Port Availability	2021-10-04	This grid widget shows which ports on a data panel are in use and available as well as what their far end panel/port is.
Power	Chart	Actual Active vs Average Active Power by Cabinet	2021-10-04	Shows 1 bars for each selected cabinet. The actual active power for the selected cabinet labeled Actaul, and the average actual power. The actual values are based on the latest available...
Enterprise Overview	Chart	Local Permissions by Role	2021-10-04	Shows the count of local users with the Role.
Items Inventory	Chart	Cabinet Count by Customer	2021-11-08	Shows the number of cabinets in each location per customer by status.
Change	Chart	Types of Completed Requests by Location Over Time	2021-11-09	Shows a line for each data center denoting the total completed request by type for the selected building. The sum is derived from the aggregate of completed requests by type for the select...
Parts Inventory	Chart	Part Stock Levels with Threshold	2021-11-10	Shows the total part stock by location : model and part usage status vs a line for the restocking threshold.
Enterprise Overview	Chart	Location Drawing File Status	2021-12-03	Shows the count of location with and without a drawing file uploaded.
Parts Inventory	Chart	Part Actions	2021-12-27	Shows the total part actions by location and action.
Connectivity	SQL	Connectivity with Data Port Comments	2021-12-28	This grid widget provides columns found in the connectivity tab for data connections as well as a column for the comments of the end node data port.
Power	Chart	Capacity vs Remaining Power by Sublocation	2022-01-07	Shows the total and remaining power capacity at the selected sublocation level. The Estimated Remaining Capacity is calculated by take the sum of the budget watts on planned and installed ...
Change	SQL	Data Connection Audit Trail	2022-01-26	This widget shows the source and destination asset and port as well as the what the connection was changed from, what it was changed to, by who and when.
Data Reports	SQL	IP Subnets with IP Addresses Assigned	2022-02-15	This grid widget illustrates the data imported by the subnet import sheet. The columns include Location, Subnet Start, CIDR, Mask, Gateway, Subnet Name, VLAN Number, and Hostname Suffix.
Change	Chart	Cabinet Contents Audit Report	2022-02-15	Shows the number of items that were added or removed from a cabinet.
Connectivity	SQL	Items Without Connections	2022-02-16	This grid widget shows all items that do not have any data connections and do not have any power connections.
Change	SQL	Serial Number Audit Trail	2022-02-18	This SQL grid widget shows what a serial number was, what it was changed to and when over the past 3 months.
Data Reports	Chart	Average Time from Creation to Installation	2022-03-09	Shows the count of items in the day range. The range is defined as the number of days it took from creation of an item to installation. This excludes items in the Archived status. NA repre...
Items Inventory	Chart	Rack PDU Model Search	2022-04-05	Shows all Rack PDU Models in the library by Make and summarizes port information in the drill-down view for easy searching. Makes with fewer than 10 models are excluded.
Change	SQL	Location Audit Trail	2022-04-06	This grid widget shows the location audit trail for device and network assets.
Enterprise Overview	Chart	Count of Items with Tickets	2022-04-28	Shows the count of items with one or more tickets by class.
Power	Chart	Budget Power Capacity by Country	2022-05-09	Shows, for each country, the total for the budgeted power from all power supplies factoring in the power supply redundancy and which are connected. Total capacity is calculated based on th...
Power	Chart	Power Supply Variance	2022-05-09	This dcTrack dashboard widget shows the percent deviation from mean of a device's power supply readings within the selected location. This indicates a problematic device power supply with ...
Items Inventory	SQL	Duplicate Serial Numbers	2022-05-25	This grid widget shows items that share the same serial numbers.
Enterprise Overview	Chart	User Permissions by Role	2022-05-25	Shows the count of users with the Role.
Change	Chart	Asset Audit Results Per Cabinet	2022-06-20	Shows each cabinet and the number of items that require an update and the number of new items.
Items Inventory	Chart	Count of Items Installed per Date Range with Average Trend Line	2022-07-08	Shows the count of items in the day range. The range is defined as the number of days it took from creation of an item to installation. This excludes items in the Archived status. NA repre...
Space	Chart	Free RU Trend in Percent	2022-07-08	Shows the percentage of free Rack Unit for each day of the past year or for each month of the full history, for the selected Locations.
Parts Inventory	Chart	Historical Parts Count	2022-07-08	Shows for each month the count of parts based off part transactions.
Items Inventory	Chart	Item Counts by Building	2022-07-08	Shows the number of items in each data center grouped or stacked down by class. Excludes items in the Archived and Storage status.
Items Inventory	Chart	Contract Expiration by Make and Model	2022-07-11	Shows how many items in each date range are approaching their contract end date.
Data Reports	SQL	Start and End U Position by Make and Model	2022-07-11	Show make, model, cabinet and starting and ending uPosition of an item.
Items Inventory	Chart	Items by Type and Data Center	2022-07-11	Shows the item count by data center and type.
Power	Chart	Rack Power Monitoring Status	2022-07-13	Shows the count of fully, partially and unmonitored racks. A fully monitored rack has a PowerIQ ID for each PDU in the cabinet. A Partially monitored rack has at least one integrated PDU. ...
Enterprise Overview	Chart	Rack Temperature Monitoring Status	2022-07-13	Shows the count of fully, partially and unmonitored racks. A fully monitored rack has a PowerIQ ID for each temperature sensor in the cabinet. A Partially monitored rack has at least one i...
Parts Inventory	Chart	Part Transactions Over Time by Part Model	2022-07-13	Shows the total part transaction count over time by part model.
Items Inventory	Chart	Item Creation Count by Date	2022-07-25	Shows the count of items created on a certain date that are currently in Planned or Installed status. The connections made to that item will be shown in the details grid.
Connectivity	SQL	Device Power Supply to Terminating Power Port	2022-07-27	This SQL grid widget shows the device to the terminating power port.
Items Inventory	Chart	Top Make by Data Center	2022-07-27	Shows the top makes by data center.
Items Inventory	Chart	Count of Planned Cabinets by Location	2022-08-23	Shows the count of planned racks by location.
Items Inventory	Chart	Battery Replacement Plan	2022-08-23	Shows the number batteries needing replacement.
Power	Chart	Power Distribution and Redundancy	2022-08-23	Shows the count of power supplies connected to each power panel per cabinet. In the drill down, the diverse panel column is only accurate when the widget is filtered by one power panel. In...
Power	Chart	Stranded Power by Cabinet	2022-09-07	Shows the Budgeted, Actual and Stranded Power for Cabinets in the selected location. The Budgeted bar is the sum of all power consuming items' effective power within the sub-location. The ...
Enterprise Overview	Chart	Count of Devices, Network, Rooms and Floors by Data Center	2022-09-07	Shows count of Cabinets, Devices, Network items, Floors and Rooms by data center.
Space	Chart	Cabinet Space Remaining Gauge By Custom Field	2022-09-27	Shows the amount of remaining (or open) Rack Units filtered by Location, Cabinet Status and Item Status. The needle position reflects the remaining cabinet space capacity or open rack unit...
Enterprise Overview	Chart	Available kW and RUs by Cabinet	2022-09-27	Show the available kW and RUs by cabinet. The used kW is the sum of the cached measured watts value. To ensure data accuracy, ensure to get readings in bulk via the Visualization tab befor...
Power	Chart	Power Chain Breakers Utilization With Actual Values	2022-11-03	Shows the Budgeted and Actual Breaker Utilization or consumption in kW or Amps for the selected location, for the selected level in the power chain and the selected parent items of that le...
Items Inventory	Chart	Time from Planned to Last Install	2022-11-10	Shows the count of items in the day range. The range is defined as the number of days it took from the first time the items was in the Planned status to the last time the item was in Inst...
Connectivity	Chart	Power Port Usage by Cabinet	2022-12-20	Shows the number of connected and free (not connected) power ports by Rack for each connector type currently in use within the selected location filtered by item class.
Power	Chart	Actual Active Power vs Cabinet Capacity	2022-12-22	Shows 1 bars for each selected cabinet. The actual active power for the selected cabinet labeled Actaul. The actual values are based on the latest available readings from Power IQ. Shows a...
Connectivity	SQL	Power Connections With Port Rating Attributes	2023-01-23	SQL grid widget that shows the starting item location, starting cabinet, starting item name, starting item port name, starting nameplate watts, starting budget watts, starting nameplate am...
What-if	Chart	What-if: Rack Units Space Capacity by Cabinet Customer	2023-02-27	Shows the number of Rack Units in each sub-location (Cabinet, Row, or Aisle) that fall in 3 categories. Occupied Now are rack units in use from items not in Planned status. Open are rack u...
Change	Chart	Ticket dcTrack Status Transition Metrics	2023-02-28	Shows the min, max and average number of hours for the duration between dcTrack Status transitions. 'Overall' measures the time from 'Not Started' to 'Complete'. 'In Progress' measures the...
Change	Chart	Tickets by Status and dcTrack Purpose Trend Chart	2023-02-28	Shows tickets by creation date filtered by ticket status and purpose.
Change	Chart	Tickets by Status and dcTrack Purpose	2023-02-28	Shows the count of tickets by ticket status, dcTrack purpose, user and location grouped by ticket status, purpose, user or location. The list of users are those with tickets assigned to th...
What-if	Chart	What if: Budget Capacity by Cabinet Customer	2023-03-16	Shows the total budget power in Watts in each sub-location (Cabinet, Row, or Aisle) that fall in 3 categories. Consumed Now is power consumed by items not in Planned status. Free is power ...
Power	Chart	Actual Active Power vs Location Capacity Gauge	2023-03-16	Shows the actual active power, the sum of all installed and planned items in the selected location as the needle, and the location capacity as the end of the gauge. The actual values are...
Power	Chart	Under Utilized Assets (Zombie Servers)	2023-03-16	Shows a trend line based on the selected period, granularity and statistic for each Device, Network or Probe Item whose Auto Power Budget percent of Nameplate is less than the selected Uti...
Power	Chart	Potential and Effective Power vs Capacity per Cabinet	2023-03-24	Shows the total effective and potential power vs the cabinet capacity in kW filtered by item Customer. The 'Remaining Potential Power' series is the portion of the potential power that exc...
Items Inventory	Chart	Item Count By Custom Device Status/Sub-Status	2023-03-24	Shows the number of items for each selected custom field pick. The data can be grouped by Location, Item Function, Item Type, Custom Device Status or Custom Device Sub-Status.
Power	Chart	Actual Active Power Per Cabinet with Row Capacity	2023-04-05	Shows a line for each rack denoting the active power in Watts for the selected location. Shows a line for the row capacity. The sum is derived from the rack pdu readings for the selected p...
Power	Chart	Actual Power Per Item by Cabinet	2023-04-05	Shows a bar for the sum of items of class device, network and probe in the selected item type denoting the active power in Watts for the selected location. The sum is derived from the devi...
Space	Chart	Available Rus by Cabinet Excluding Blanking Plates	2023-04-11	Show the available RUs by cabinet while excluding Blanking Plates from the used count.
Connectivity	Chart	Asset vs Model Connectivity	2023-05-03	Shows the count of items that don't meet, meet, or exceed the connectivity requirements as defined by the ports selected in the Required Ports parameter which lists all the ports of the se...
Items Inventory	Chart	Item Count by Model and Status Age	2023-05-03	Shows count of items by location, class, make, model and status age. The operand with the period will determine the range of status age. Example: Greater than Last Year will return the cou...
Items Inventory	Chart	Percent of Items Polling From PowerIQ	2023-05-03	Shows the percent of items are being polled in PowerIQ by location. Items that are considered to be polling have a PowerIQ ID, all power supplies have a measured value greater than -1, the...
Connectivity	SQL	Power Connection Import with Available Ports	2023-05-09	This grid widget shows the import template for power connections where the starting item is the power supply. This grid widget also shows all unused power supplies.
Change	Chart	Count of Project Components	2023-05-23	Shows the count of different project components to include: items, connections, requests and parts.
Space	Chart	Percent of Used and Available RUs by Data Center	2023-06-14	Shows the percent of used and available RUs by Data Center filterable by item type.
Items Inventory	Chart	Count of Valid/Invalid Items by Class	2023-07-17	Shows the count of items that are valid and invalid filtered by location and class.
Space	Chart	Rack Unit Consumption By Cabinet Function and Project	2023-07-19	Shows the Consumed vs remaining Space in Rack Units (RUs) broken down by Cabinet Function and Cabinet Project. Consumed space is considered space consumed by an installed asset regardless ...
Connectivity	SQL	Assigned IP Address and VLAN	2023-08-08	This grid widget shows location, item name, port name, IP Address and VLAN.
Power	Chart	Total Energy Usage Last Month By Customer	2023-08-08	Shows the total kwH used by a customer for the last month.
Power	Chart	Battery Amp Hour per Model Per Discharge VPC by Rate Hour	2023-08-15	Shows the value value at each amp-hour per model per Discharge VPC. When the Show in paramter is set to Minutes, all rate hours will be represented in minutes. When Hours is selected, only...
Items Inventory	Chart	Item Counts by Custom Field Date	2023-08-15	Shows for the period the count of items by location filtered by custom date.
Power	Chart	Power Consumption By Cabinet Function and Item Project	2023-08-23	Shows the Consumed vs remaining Power (kW) based on Budget Power of items in the selected project broken down by Cabinet Function. A negative value indicates a cabinet function that is usi...
Enterprise Overview	Chart	Item Count or Price by Location	2023-08-25	Shows count of items or total purchase price by location filtered by make and model. The total bar represents the sum of the selected locations.
Enterprise Overview	SQL	Cabinet and Power Usage per Location	2023-09-27	This SQL grid widget shows location, city, country, the total RUs, total used RUs, total Available RUs, Percent Used, Percent Available, the Measured Power stored in dcTrack in watts, and ...
Items Inventory	SQL	Data Panels Without Ports	2023-09-27	This SQL grid widget shows Location, Cabinet, Data Panel Name, Status, and UPosition of data panels that do not have data ports.
Connectivity	SQL	Items with 2 Power Supplies Connected to the Same in Cabinet PDU	2023-09-28	This SQL grid widget shows Source Location, Source Item, Source Port Names, Destination Location, Destination Cabinet and PDU of assets that have two power supplies and are both connected ...
Space	Chart	Used Rack Units Trend By Cabinet	2023-09-28	Shows the historical number of used Rack Unit for each day of the past year or for each month of the full history, for the selected Locations and cabinets.
Items Inventory	Chart	Physical vs Virtual Devices by Type	2023-10-26	Shows the Device class split between Virtual Machines vs. Physical Systems (i.e. Standard and Blade Servers subclass) filtered by Location and item Type. Excludes Archived Devices.
Parts Inventory	Chart	Part Consumption Over Time by Make and Model	2023-11-07	Shows the total part consumption over time by location, part action, class, make, model and part model part number.
Connectivity	Chart	art Widget- Duplicate Cord ID per Location by Connection Type	2023-11-07	Shows how many duplicate CordIDs there are per Location per connection type.
Power	Chart	Actual Power and Budget Power vs Capacity per Pod in Watts	2023-11-07	Shows the Actual active power plus planned Budget power per pod vs the pod Capacity. The Actual is the sum of all planned and installed Rack PDUs as reported from Power IQ. The Budget is s...
Cooling	Chart	Average Temperature per Location Gauge	2023-11-21	Shows the average latest temperature, the sum of all temperature sensors in the selected location as the needle. The actual values are based on the latest available readings from Power IQ.
Items Inventory	Chart	Item Replacement Plan	2023-11-21	Shows the number of items needing replacement. The replacement date is calculated by taking the selected date and adding the selected number of years. For example, if the purchase date is ...
Connectivity	Chart	Data Port Usage By Cabinet and Data Panel	2023-11-29	Shows the number of connected and free (not connected) ports by Rack for each connector type currently in use within the selected location filtered by data panel.
Space	Chart	RU Count by Item Customer Per Location	2023-12-05	Shows the count of RUs owned by an item customer.
Power	Chart	Actual Power Per Rack PDU by Cabinet with Grouping	2023-12-07	Shows a bar for each Rack PDU or each cabinet denoting the active power in Watts for the selected location. The sum is derived from the Rack PDU level readings for the selected period, gra...
Power	Chart	Actual Power By Device Model	2023-12-27	Shows the active power in Watts within the selected location and model. The sum is derived from the IT Device level readings from all installed network and device assets. Shows the budget ...
Power	Chart	Power Distribution and Redundancy on VPC	2023-12-27	Shows the count of power supplies connected to each side of the VPC per cabinet. A 'No' in the Redundant Panel column in the details grid means that server is not fed from a redundant pane...
Space	Chart	RU Count by Item Customer Pie	2023-12-27	Shows the RUs occupied by each customer in the rackable space of a cabinet within the selected location. The Pie Chart can be selected to show absolute values or percentages from the Widget Settings.
Items Inventory	Chart	Item Counts By Integration Status Per Location	2024-01-15	Shows the count of items filtered by integration status per location.
Connectivity	SQL	Structured Cabling	2024-01-15	This SQL grid widget emulates the structured cabling page under Connectivity.
Power	SQL	kW Usage Table	2024-01-22	Shows the Data Center name, the cabinet count, the kW capacity, kW used (sum of watts actual converted into kW), % Used, kW available (capacity - used) and % available.
Space	Chart	Custom Cabinet Space Capacity by Cabinet Group, Type and Function	2024-01-26	Shows the used and free space inside the cabinets in each location based on the selected bottom RU, top RU, cabinet group, cabinet type, cabinet function, and cabinets.
Space	Chart	RU Count of Customer By Cabinet	2024-01-26	Shows the count of RUs owned by a customer.
Space	Chart	Available RUs Per Cabinet by Cabinet Type	2024-02-02	Shows the available RUs per cabinet by cabinet type.
Power	Chart	Actual Power Per Rack PDU or Cabinet by Cabinet Group	2024-02-02	Shows a line for each Rack PDU or Cabinet denoting the active power in Watts for the selected location. The sum is derived from the selected entity readings for the selected period, granul...
Space	Chart	Cabinet Space Availability	2024-02-02	Shows the count of RUs occupied by status. Occupied is the count of RUs consumed by the items with the selected statuses within a location. Occupied + Planned is the count of RUs consumed ...
Power	Chart	Power Capacity	2024-02-02	Shows the location power capacity as 'Capacity'. Shows the sum of latest measured power readings as 'Latest Raw'. Shows the sum of measured data plus the sum of potential power for all pla...
Items Inventory	Chart	Item Count Per Location By Item Fields	2024-02-09	Shows item count of all installed and planned items per location filtered by make, model, function, type and customer.
Space	Chart	Chassis Slot Usage by Chassis Model and Function per Location	2024-02-21	Shows the number of occupied, free and total number of slots in all chassis and grouped by front vs back slots per Location, filtered by Location, Chassis Model and Chassis Function and Ch...
Cooling	Chart	Temperature Trend Chart by Sensor Positions	2024-03-07	Shows temperature sensor trend for the selected location, cabinets and sensor positions. The lines can be displayed as a sum at the selected 'Rollup to' parameter. Choosing Cabinet or Item...
Space	Chart	Floor Space Availability	2024-03-07	Shows a bar for the value in the custom field Cabinet Capacity for the selected location as Capacity. The count of cabinets installed in the location as Occupied . Occupied + Planned is th...
Data Reports	SQL	Latest Change on Planned Items	2024-03-14	This grid widget shows that latest change to a Planned item including Location Code, Status, Item Name, Class, Audit Action, Audit Field, Changed From, Changed To, Changed By and Changed Date
Power	Chart	Actual Active Power by Cabinet by Cabinet Fields	2024-03-25	Shows 3 bars for each selected cabinet, one for Minimum, one for Maximum and one for the Average Actual Power at the selected Period and granularity. The actual values are based on avail...
Items Inventory	SQL	Items in Planned Status Longer than 3 Months	2024-04-12	SQL grid widget that shows the location, cabinet, class, item name, UPosition and status date of items in planned status longer than 3 months.
Data Reports	SQL	Rack Center of Gravity	2024-06-20	This SQL grid widget shows the Location, Cabinet, the Center of Rack Gravity and the UPosition the center is on.
Items Inventory	Chart	Counts of Cameras per Location	2024-06-20	Shows the count of items with type 'Camera' per location.
Items Inventory	Chart	Item Count By Status Per Installation Date	2024-06-20	Shows the count of items in the selected status by installation date. The items are filtered by Location.
Items Inventory	Chart	Item Age In Years (with Custom Date Fields)	2024-06-24	Shows the number of items of a certain age rounded down to nearest year based on the selected date and customer. The widget can filter on standard and custom date fields. Items less than 1...
Enterprise Overview	Chart	Rack PPU Metric Counts Per Location	2024-06-24	Shows the total count or Rack PDUs in the selected location with selected model as 'Total Rack PDUs', the total number of Rack PDUs with an IP address as 'PDUs with IP', the total number o...
Space	Chart	Cabinet Utilization by Cabinet Customer	2024-06-24
Items Inventory	Chart	Item Count Per Class by Item Customer Pie	2024-06-24	Shows the item count by each class within the selected locations and customers. The Pie Chart can be selected to show absolute values or percentages from the Widget Settings.
Power	Chart	Budget Power Per Customer vs Location Capacity	2024-06-24	Shows, for each location, the total for the budgeted power from all power supplies factoring in the power supply redundancy and which are connected in kW. The capacity is the location capacity.
Items Inventory	Chart	Cabinet Count by Customer Limit	2024-06-24	Shows the number of cabinets in each location per customer by status. The limit parameter will show, for example, the top 5 customer counts regardless of status instead of the top 5 custom...
Power	Chart	Actual Power vs Capacity per Location Gauge (Without Cabinet Parameter)	2024-06-24	Shows the actual active power, the sum of all installed and planned items in the selected location and customers as the needle, and the location capacity as the end of the gauge. The actua...
Space	SQL	Cabinet Inspector	2024-06-25	This SQL grid widget simulates the cabinet inspector by showing: Location Code, Cabinet Name, Cabinet Power Capacity (W), total potential power of the cabinet's assets, total effective po...
Enterprise Overview	Chart	Available kW, PDU Outlets and RUs by Cabinet	2024-06-25	Show the available kW, PDU outlets and RUs by cabinet where the count of free PDU outlets is filtered on PDU Connector Type. The used kW is the sum of the cached measured watts value. To e...
Connectivity	Chart	Power Port Usage By Connector	2024-06-28	Shows the number of connected and free (not connected) ports in each location for the selected connector and item class. The detail drill down also includes a column to show connector compatibility.
Connectivity	Chart	Available Data Ports Per Item Name	2024-06-28	Shows the count of free data ports per item based on selected location, customer and subclass. The subclass parameter only contains those that have assets with data ports.
Power	Chart	Budget Power Capacity By Customer	2024-06-28	Shows the amount of remaining power capacity for the selected location and customer. The needle position reflects the remaining power capacity. The capacity is set to the location capacity.
Enterprise Overview	Chart	Cost ($) Of RUs or kW by Function Per Customer	2024-06-28	Shows the cost of RUs or kW by item Function per Customer. The cost per RU comes from the location custom field labeled 'Price Per U' of type numeric set at the data center level. The cost...
Connectivity	SQL	Data Connection with Structured Cabling	2024-07-15	This SQL grid widget shows Near end location, cabinet, UPosition, item name, port name, far end location, cabinet, UPosition, item name, port name, Cord ID (label), status and cord type. W...
Connectivity	SQL	Data Connection Labels	2024-07-26	This SQL grid widget shows the Near End Location, Cabinet, UPosition, Item Name and Port Name, the Far End Location, Cabinet, UPostion, Item Name and Port Name and labels. The near end lab...
Items Inventory	Chart	Item Age In Years with Custom Field Dates	2024-08-07	Shows the number of items of a certain age rounded down to nearest year based on the selected standard or custom date. Items less than 1 year old will show as 00:00:00. The items included ...
Space	SQL	RU Usage Per Customer	2024-08-14	This SQL grid widget shows the total RUs, total Used RUs and total Free RUs per cabinet customer.
Connectivity	SQL	Data Labels	2024-08-14	This SQL grid widget shows Near/Far End Location, Near/Far End Cabinet, Near/Far End U Position, Near/Far End Item Name, Near/Far End Port Name and Near/Far End Label. The labels are i...
Enterprise Overview	Chart	Free Rack Units and Free Rack PDU Outlet Trend per Cabinet	2024-08-28	Shows the historical number of free Rack Unit and free Rack PDU outlets for each day of the past year or for each month of the full history, for the selected Locations per cabinet. The dri...
Change	Chart	Count of Aged Work Order or Requests per Data Center	2024-09-11	Shows count of work orders or requests older than the selected period in the 'Work Order Issued' status per data center.
Space	SQL	Used RUs Per Location by Customer	2024-09-11	This grid widget shows the location code, the customer name and the total Used RUs from that customer.
Space	Chart	Cabinet Space Capacity of 4-Post Enclosure Cabinets	2024-09-16	Shows the capacity for space inside the 4-Post Enclosure cabinets in each location based on the number of rack units. When an item is mounted to either or both front and back rails, that r...
Items Inventory	Chart	Count of Items per Location	2024-09-16	Shows count of items per location by project number.
Items Inventory	Chart	Count of Items per Location by Class and Status Transition	2024-09-16	Shows count of items moved following the selected status transition by the filtered class and project.
Power	Chart	Latest Power with Max and Ideal Capacity Per Location	2024-09-24	Shows a a bar for the latest actual active power per location. Shows a line for max capacity (the capacity of the location) and the ideal capacity (the selected percentage of the max capacity).
Enterprise Overview	Chart	Available kW and Rus per Cabinet by Cabinet Details	2024-10-03	Show the available budget kW and RUs per cabinet filtered on cabinet location, grouping, customer, function and cabinet name. A negative availability in power indicates an overusage in com...
Enterprise Overview	SQL	Enterprise Counts	2024-10-25	This SQL grid widget shows the Location, count of Cabinets, Rack PDUs, Devices, Network Items, Blades, Data Panels, Passive Items, Data Circuits and Power Circuits in each location.
Data Reports	SQL	Power Panel and Busway Power Fed From	2024-11-01	This SQL grid widget shows the location, the Remote/Local Power Panel or Busway and what asset feeds it.
Data Reports	SQL	Asset Power Usage in kW	2024-11-08	This SQL grid widget shows item placement, actual and budget power in kW.
Enterprise Overview	Chart	dcTrack Licenses Remaining by Country	2024-11-13	Shows the number of licenses used and remaining for the selected country. Used Licenses = number of cabinets excluded archived cabinets.
Power	Chart	Actual Power + Effective Power + Remaining Power vs. Capacity per Cabinet	2024-11-27	Shows stacked bars for the sum of the actual active power in kW, the sum of effective power of devices in the cabinet and the remaining power calculated as the cabinet capacity - the acuta...
Power	Chart	Latest Power and Capacity By Customer	2024-11-27	Shows two bars for each customer: 1 for latest actual power and a bar per customer capacity for the selected cabinet customers and cabinet status.
Space	SQL	RU Usage by Item Customer and Status	2024-12-16	This SQL grid widget shows Location, Cabinet, Cabinet Total U Height, Cabinet Free U Space, Item Customer, Total Consumed Space (the total space occupied by Installed Items), Reserved U Sp...
Space	Chart	Floor Space Availability	2025-01-03	Shows the actual number of installed cabinets vs. an estimated number of additional cabinets that can be placed in each location, based on the room level custom field 'Max_cabinet.
Power	Chart	Building Actual Active Power	2025-01-03	Shows the sum of the active power in kW for the selected location. The sum is derived from the Rack level readings for the selected period, granularity. Each of the three lines represent m...
Data Reports	SQL	Avg and Max Nameplate (%) per Location and Model	2025-01-21	This SQL grid widget shows the Location Code, Make, Model, Average Nameplate (%), Max Nameplate (%) and the count of assets in the Location with that Make and Model.
Items Inventory	SQL	Items Without a PO Number	2025-03-03	This SQL grid widget shows the location, cabinet, item name, class, status and U Position of assets that do not have a PO number.
Enterprise Overview	SQL	Data Center Space and Power Utilization	2025-03-03	This SQL grid widget shows Data Center Location Name, Rack Count, Rack Units Used, Rack Units Available, Rack Units Utilization (%), Data Center Power Capacity (kW), Power Measured (kW) (...
Enterprise Overview	Chart	Asset Model vs Drawing Size Validation	2025-03-04	This chart displays a count of items with mismatches between the item's recorded size in its drawing file and the item's recorded size in the dcTrack models library. More information about...
Enterprise Overview	Chart	Current and Previous RU and Power Usage per Customer	2025-03-10	Shows the current and the selected period for power and RU usage per cabinet Customer.
Data Reports	SQL	Assets with 1 Power Supply and Connected PDU	2025-03-17	Shows Location Code, Cabinet, Item Name, U Position, Make, Model, Power Supply Name, PDU Rack Name, PDU U Position, PDU Name, and PDU Outlet Name.
Change	Chart	Count of Cabinets Per Location By Asset Audit Date	2025-03-17	Shows the count of cabinets for each location, filterable by asset audit date. The details grid displays each cabinet's location, name, asset audit date, and other general details.
Space	Chart	Cabinet Space Capacity by Cabinet Customer (Custom Details)	2025-03-26	Shows the capacity for space inside the cabinets in each location based on the number of rack units and cabinet customer. When an item is mounted to either or both front and back rails, th...
Data Reports	SQL	List of Empty Cabinets	2025-04-03	This SQL grid widget shows a list of cabinets and the location they are in that do not have any assets assigned to them. Cabinets that contain only Rack PDUs, Data Panels and/or Passiv...
Items Inventory	Chart	Count of Items Per Location By Model	2025-05-01	This chart counts the number of items in each location. The user can filter which items are counted in this total by selecting their preferred location(s), make(s), model(s), and class(es)...
Data Reports	SQL	Connection Warnings	2025-05-01	This SQL grid widget shows the power and data connections with 'This item is in a different cabinet that the item in the next node' and 'Port data rate does not match with the port data ra...
Power	SQL	Panel Schedule	2025-05-01	This SQL grid widget shows the Floor PDU, Power Panel, Breaker Details, Serviced Cabinet, Connected Asset, and the Connected load in kW and amps.
Data Reports	SQL	Compare Audit Trail Install Date vs Standard Installation Date Field	2025-05-01	This SQL grid widget shows item details, the standard field for Installation Date, the audit trail's first date record of when the asset moved to the Installed Status and who changed the status.
Connectivity	SQL	Assets with Connected Power Supplies	2025-05-01	This SQL grid widget shows the asset and some of its details and where its power supplies are connected to.
Connectivity	Chart	Counts of Models with Data Rates below 1GB	2025-05-01	Shows the count of models that have data ports with a data rate less than 1GB. The details provides a list of the models, the count of asset using that model and the library version that m...
Space	Chart	Percentage Cabinet Space Capacity by Cabinet Types	2025-05-01	This widget shows the cabinet space capacity per location. Here, the cabinet space capacity is expressed as as a percentage of total selected cabinet space per location, filterable by loca...
Power	Chart	Total Actual Active Power for Multiple Locations	2025-06-02	Shows a single line for the Actual Active Power sum of all the selected locations. The sum is derived from the Rack level readings for the selected period, granularity and statistic.
Data Reports	SQL	Temperature Delta	2025-06-02	This SQL grid widget shows Location, Cabinet, kW used in the cabinet, Position of the Temperature Sensor, Front Temperature Reading, Rear Temperature Reading and the difference between the...
Data Reports	SQL	Power Accuracy based on PDU Inlet Readings	2025-06-02	This SQL Grid widget shows Location, the total number of Rack PDUs in the data center, the total number of PDUs with power (PDUs with an Inlet Watts Measured value greater than 0), the tot...
Data Reports	SQL	Rack PDU Connectivity Mismatch	2025-06-02	This SQL grid widget shows the Location, Cabinet and Mismatch Outlets message.
Power	Chart	Top 10 Stranded Power per Cabinet	2025-06-02	Shows the Budgeted, Actual and Stranded Power for Cabinets in the selected location. The Budgeted bar is the sum of all power consuming items' effective power within the sub-location. The ...
Items Inventory	Chart	Count of Items per Location by Project Number	2025-06-03	The chart widget shows a count of items per location, secondarily grouped by project number. Results can be filtered by documented status transition, the period in which that status transi...
Power	Chart	Under Utilized Assets (Zombie Servers) by Item Status	2025-06-03	Shows a trend line based on the selected period, granularity and statistic for each Device, Network or Probe Item whose Auto Power Budget percent of Nameplate is less than the selected Uti...
Space	Chart	Cabinet Space Capacity per Hierarchy Level	2025-06-03	Shows the capacity for space inside the cabinets in the selected Hierarchy Level based on the number of rack units. When an item is mounted to either or both front and back rails, that rac...
Items Inventory	Chart	Item Count by Days to Upcoming Custom Date	2025-06-03	This widget provides a count of items per location. The series for this widget is the number of days until the custom field date comes to pass. (Options for the series include Past Date, l...
Data Reports	SQL	Asset View with Contract Details	2025-06-03	This SQL grid widget shows a number of asset details and contract details.
Power	Chart	Actual Power per Item By Device or Network Model	2025-06-03	Shows the active power in Watts within the selected location and model. The value is derived from the IT Device level readings from all installed or planned network or device assets. Shows...
Data Reports	SQL	Items Moved between Locations in the Past Week	2025-06-10	This SQL grid widget shows the date of the location move, the Item Name, Make, Model, Serial Number, Customer, the location the item moved from and the the location the item moved to in th...
Items Inventory	Chart	Count of Items Per Location By Item Model and Status	2025-06-10	This chart counts the number of items in each location. The user can filter which items are counted in this total by selecting their preferred location(s), make(s), model(s), class(es), an...
Power	Chart	Power Summaries	2025-06-10	Shows 1 bar per node for the selected measure. The actual values are based on available readings from PowerIQ.
Space	Chart	RU Usage	2025-06-19	Shows the RUs occupied in the rackable space of a cabinet within the selected location. The Pie Chart can be selected to show absolute values or percentages from the Widget Settings.
Power	Chart	Power Usage in kW	2025-06-19	Shows the kW consumed and available within the selected location. The used kW is calculated by summing the watts actual on the device power supplies. The Pie Chart can be selected to show ...
Power	Chart	Power Usage per Customer in kW	2025-06-19	Shows the kW consumed by Customer within the selected location. The used kW is calculated by summing the watts actual on the device power supplies. The Pie Chart can be selected to show ab...
Connectivity	Chart	Available PDU Outlets	2025-06-19	Shows the count of free PDU outlets per PDU based on selected location.
Power	Chart	Average and Max Active Power vs Capacities per Location	2025-06-19	Shows 4 bars for each selected location. The Data Center totl as the location's power capacity, Sold Power Capacity as the sum of the cabinet capacities for the selected customer, average ...
Power	Chart	Actual Power vs Capacity per Node Level	2025-06-19	Shows the actual active power sum of all installed and planned cabinet as the needle, and the sum of the capacity of the selected nodes as the end of the gauge. The actual values are based...
Power	Chart	Energy Summaries (kWh)	2025-07-31	Shows 1 slice per node for the Energy consumed in the selected period. The data points shown are in kW. The actual values are based on available readings from PowerIQ.
Space	Chart	Count of Empty Cabinets by POD	2025-08-07	Shows the count of empty cabinet by POD. A cabinet is considered empty when there is nothing racked below the selected top RU positions. This widget can group the data into different views...
Power	Chart	Actual and Planned Power vs. Capacity per Cabinet Customer	2025-08-07	Shows the sum of the actual active power in Watts plus the budget power for all planned items in the cabinet vs. the capacity of the cabinet for the selected customer and cabinets. The act...
Power	Chart	Global Power Usage per Customer in kW	2025-08-07	Shows the kW consumed by Customer across dcTrack. The used kW is calculated by summing the watts actual on the rack PDU outlets. '-Not Connected-' refers to a PDU outlet that has a draw, b...
Items Inventory	Chart	Global Installed Servers per Customer	2025-08-07	Shows the count of installed servers across dcTrack per customer. A server is indicated with an Item Type of 'Compute'. The Pie Chart can be selected to show absolute values or percentages...
Parts Inventory	Chart	Global Installed CPUs per Customer	2025-08-07	Shows the count of installed CPUs on servers per customer across dcTrack. A server is indicated with an Item Type of 'Compute'. The Pie Chart can be selected to show absolute values or per...
Power	Chart	Latest Rack PDU Total Active Power	2025-08-07	This widget shows the actual active power, the sum of all installed and planned rack pdus in the selected location, as the needle. The location's capacity value is shown at the end of the ...
Cooling	Chart	Latest Temperature Per Cabinet Customer	2025-08-13	Shows the min, max or average temperature in each cabinet for the selected sensor positions. The bars in the chart can be for all cabinets in the location having at least one sensor, or li...
Enterprise Overview	SQL	Heat Map	2025-08-18	This SQL grid widget shows Region, Data Center, Site Code, Backup Site, Number of Servers, Number of Most Critical Apps, Percent Rack Space Utilization and Percent Power Utilization.
Connectivity	Chart	Available Data Ports Per Item Names	2025-08-20	Shows the count of free data ports per item based on selected location, function and class/subclass. The subclass parameter only contains those that have assets with data ports in the sele...
Power	Chart	Idle Assets	2025-08-20	Shows a trend line based on the selected period, granularity and statistic for each selected IT class item whose Auto Power Budget percent of Nameplate is less than the selected Utilizatio...
Power	Chart	Power Trend by Item Fields	2025-08-21	Shows power trends for the selected location and cabinets. The lines can be displayed as a sum at the selected 'Rollup To' parameter. Choosing Cabinet or Item for the 'Rollup To' returns...
Space	Chart	Cabinet Count by Function	2025-08-21	Shows the number of cabinets by function.
Items Inventory	Chart	Count of Items Moved into Status	2025-09-22	Shows the count of items moved into the selected status over the selected period by status.
Power	Chart	Actual Power per Period by IT Item or Item Sum	2025-09-22	Shows the active power in Watts within the selected location for the selected customer(s), IT item class(es), and item(s) over time. The sum is derived from the IT item level readings ma...
Space	Chart	Cabinets with More than 36RU Free	2025-09-22	Shows the count of cabinets that have more than 36 RU free with one bar per selected aggregate.
Power	Chart	Actual Power + Remaining Power vs. Capacity per Location	2025-09-29	Shows stacked bars for the sum of the actual active power in kW, and the remaining power calculated as the location capacity - the actual power vs. the capacity of the location. The actua...
Data Reports	SQL	Items with Contract End Date	2025-09-29	This SQL grid widget shows asset details with the asset's contract end date.
Power	Chart	Actual Power By Device or Network Model Summaries	2025-10-09	Shows the active power and budget power in Watts within the selected location per model.
Cooling	Chart	Temperature and Humidity for Last Month	2025-10-29	Shows 1 bar for the average daily temperature last month and 1 bar for the average daily humidity last month per data center.
Space	Chart	Rack Units Usage Last Month	2025-10-29	Shows 1 bar for the rack usage at the first of the previous month and a bar for the rack usage at the end of last month.