---
title: "Device History"
slug: "device-history"
updated: 2022-11-09T10:13:19Z
published: 2022-11-09T10:13:19Z
canonical: "docs.zetaly.io/device-history"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zetaly.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Device History

Stored in devHist Comes from [devData](/v1/docs/smf-74-subtype-4-coupling-facility-activity)

| DB Column name | Aggregation Function | FROM DB Column name | Configurable | In GROUPBY | Description |
| --- | --- | --- | --- | --- | --- |
| scope |  |  |  |  |  |
| startTime | MIN |  |  | X |  |
| endTime | MAX |  |  |  |  |
| seconds | MAX |  |  |  |  |
| sid |  |  |  | X |  |
| sysplex |  |  |  | X |  |
| systemName |  |  |  | X |  |
| storageArray |  |  |  | X |  |
| storageGroup |  |  |  | X |  |
| lcu |  |  |  | X |  |
| devices | COUNT |  |  |  |  |
| typeNum |  |  |  | X |  |
| modelNum |  |  |  | X |  |
| manufacture |  |  |  | X |  |
| plant |  |  |  | X |  |
| seqNum |  |  |  | X |  |
| tag |  |  |  | X | Only get character 2 and 3 of tag |
| unit |  |  |  | X |  |
| devType |  |  |  | X |  |
| volCapacityGb | SUM | cylinders |  |  | $\frac{cylinders*830.04}{1024*1024}$ |
| cylinders |  |  |  | X |  |
| sampleCount | MAX |  |  |  |  |
| numUcbs | SUM |  |  |  |  |
| hpavAlias | SUM |  |  |  |  |
| sschCount | SUM |  |  |  |  |
| measCount | SUM |  |  |  |  |
| connTime | SUM |  |  |  |  |
| pendTime | SUM |  |  |  |  |
| actvTime | SUM |  |  |  |  |
| discTime | SUM |  |  |  |  |
| busyTime | SUM |  |  |  |  |
| cmrTime | SUM |  |  |  |  |
| queueCount | SUM |  |  |  |  |
| missedCount | SUM |  |  |  |  |
| resvCount | SUM |  |  |  |  |
| allocCount | SUM |  |  |  |  |
| mountCount | SUM |  |  |  |  |
| nreadyCount | SUM |  |  |  |  |
| timerCount | SUM |  |  |  |  |
| errorCount | SUM |  |  |  |  |
| tapeMounts | SUM |  |  |  |  |
| pavSuccess | SUM |  |  |  |  |
| pavUnsuccess | SUM |  |  |  |  |
| isDasd |  |  |  | X |  |
| isTape |  |  |  | X |  |
| actionId |  |  |  |  |  |