Mapped Drive Audit - Current User

Summary

This document gathers details of the mapped network drives for the current user logged into the machine.

Dependencies

• Mapped Drive Audit - Current User
• plugin_proval_Mapped_Drive_CurrentUser

Columns

Column	Description
Client	Client name of the agent.
Location	Location name of the agent.
Computer	Computer name of the agent.
Operating System	Operating system information of the agent
LastContact	Last contact of the agent
Username	Logged-in username for which the mapped drive is detected
Path	Path of the mapped drive
TimeStamp	Timestamp of the last script run

SQL Representation

SELECT 
  c.clientid, 
  c.locationid, 
  c.computerid, 
  cl.name as `Client`, 
  l.name as `Location`, 
  c.name as `Computer`, 
  c.os as `Operating System`, 
  c.LastContact, 
  ppc.UserName, 
  ppc.Path, 
  ppc.Timestamp 
FROM 
  computers c 
  JOIN locations l ON l.LocationID = c.LocationID 
  JOIN clients cl ON cl.ClientID = c.ClientID 
  JOIN plugin_proval_Mapped_Drive_CurrentUser ppc ON ppc.computerid = c.ComputerID