plugin_proval_Mapped_Drive_CurrentUser

Purpose

This table stores the mapped drive details of the currently logged-in users.

Dependencies

• Mapped Drive Audit - Current User
• Mapped Drive Audit - Current User

Tables

plugin_proval_Mapped_Drive_CurrentUser

Column	Type	Explanation
Computerid	INT	Computer ID of the agent
username	VARCHAR	Username for which the mapped drive is detected
Path	VARCHAR	Path of the mapped drive
Timestamp	DATETIME	Script last run date on the agent

SQL

CREATE TABLE IF NOT EXISTS `labtech`.`plugin_proval_Mapped_Drive_CurrentUser` (
  `computerid` INT(11) NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `Path` VARCHAR(5000) NOT NULL,
  `TimeStamp` DATETIME NOT NULL,
  CONSTRAINT `plugin_proval_Mapped_Drive_CurrentUser_ibfk_1` FOREIGN KEY (`computerid`) REFERENCES `labtech`.`computers`(`ComputerID`) ON UPDATE NO ACTION ON DELETE CASCADE
);