CommCellMediaInfo

The CommCellMediaInfo view provides a summary of media-related information.

Column	Description
mediaid	The unique ID generated when the media was discovered.
mediabarcode	The barcode label of the media.
mediagroupid	The unique ID for the media group.
type	The hardware type of the media.
format	The recording format on the media.
sidename	The unique ID generated for each side of the media.
mediaCreationTime	The data and time at which the media was discovered.
volumeid	The unique volume ID for the media.
volumename	The volume name.
blocksizeKB	The size measured in bytes of each block in the media.
totalspaceMB	The total amount of space available in the media.
usedspaceMB	The amount of used space in the media.
freespaceMB	The amount of free space available in the media.
writenum	The number of times data has been written to the media.
reusenum	The number of times the media has been re-used.
mediastatus	The status of the media. Media status can be Good, Expired, Bad, or Invalid.
volumestatus	The current status of the volume. Volume status can be Active, Full, Idle, Read Only or Bad.
volumefullreason \| volumefulljobid	The reason the volume is full and job marking it as full.
location	The location of the media. If the media is inside the library, indicates whether the media is available in a storage slot or a drive. If the media is exported, indicates the outside storage location recorded by the user, when the media was exported.
slotname	The slot number in which the media resides.
drivename	The drive name.
exportlocation	The outside storage location of the exported media recorded by the user when the media was exported.
lastwritetimeunixsec	The most recent time at which data was protected on the media. This time represents the number of seconds that have elapsed since 1970.
rawlastwritetime (not adjusted with daylight saving)	The most recent time at which data was protected on the media, not adjusted for daylight savings time.
lastwritetime	The most recent date and time at which data was protected on the media.
drivepoolname	The drive pool name.
library	The library name.
storagepolicy	The storage policy name.
storagepolicycopy	The storage policy copy name.
retentiondays	The number of days data is kept before it is pruned.
fullcycles	The number of cycles data is kept before it is pruned.
LabelErrors	The number of labeling errors that a media has encountered.
ReadWriteErrors	The number of read, write errors that a media has encountered.