plugin_proval_vssadminstorage

Purpose

This table contains the VSSAdmin storage details.

Dependencies

• VSS Resize
• Vssadmin List Storage Audit
• VSSAdmin Storage Audit

Tables

plugin_proval_vssadminstorage

Column	Type	Explanation
computerid	INT	Computer ID of the agent
ShadowCopyVolume	VARCHAR	Volume letter where VSSAdmin is enabled
ShadowStorageUsed	VARCHAR	Volume storage used by VSS storage
ShadowStorageAllocated	VARCHAR	The total allocated storage space for VSS storage
ShadowStorageMax	VARCHAR	Maximum storage for the VSS storage
TimeStamp	DATETIME	Stores the date when the script was last executed

SQL

CREATE TABLE IF NOT EXISTS `labtech`.`plugin_proval_vssadminstorage` (
  `computerid` INT(11) NOT NULL,
  `ShadowCopyVolume` VARCHAR(50) NOT NULL,
  `ShadowStorageUsed` VARCHAR(50) NOT NULL,
  `ShadowStorageAllocated` VARCHAR(50) NOT NULL,
  `ShadowStorageMax` VARCHAR(50) NOT NULL,
  `TimeStamp` DATETIME NOT NULL,
  PRIMARY KEY (`computerid`, `ShadowCopyVolume`),
  CONSTRAINT `plugin_proval_vssadminstorage_ibfk_1` FOREIGN KEY (`computerid`) REFERENCES `labtech`.`computers`(`ComputerID`) ON UPDATE NO ACTION ON DELETE CASCADE
);