Department Detail of AD Users Script

Summary

This dataview stores the AD Users department information.

Dependencies

• plugin_proval_computer_department
• Computer Department Auditing [DV]

Columns

Column	Description
Client Name	Client Name of the DC Server
Location Name	Location Name of the DC Server
Computer Name	Computer Name of the DC Server
Operating System	Operating System of the DC Server
Department	Department information of the AD Users of the DC Server
UserName	User name list of the DC server

SQL Representation

SELECT 
  cl.name AS `Client Name`, 
  l.name AS `Location Name`, 
  c.name AS `Computer Name`, 
  c.os AS `Operating System`, 
  pp.UserName, 
  pp.department AS `User Department` 
FROM 
  computers c 
  JOIN clients cl ON c.clientid = cl.clientid 
  JOIN locations l ON l.locationid = c.locationid 
  JOIN plugin_proval_computer_department pp ON pp.computerid = c.computerid