Workstation Inventory Domain OU specific

Workstation Inventory Domain OU specific:

SELECT DISTINCT
SYS.Netbios_Name0 "Hostname", SYS.User_Name0, SYS.AD_Site_Name0,
ADCON.System_Container_Name0 "AD Location",
ADOU.System_OU_Name0 "AD OU",
ADGRP.System_Group_Name0 "AD Group",
OPSYS.Caption0 as C054, OPSYS.Version0,
MEM.TotalPhysicalMemory0 "RAM",
CSYS.Manufacturer0, CSYS.Model0,
Processor.Manufacturer0, Processor.Name0, Processor.MaxClockSpeed0,
DSYS.Size0 "HD Size (MB)"
FROM v_R_System SYS
LEFT JOIN v_RA_System_IPAddresses IPAddr on SYS.ResourceID = IPAddr.ResourceIDLEFT JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceIDLEFT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceIDLEFT JOIN v_GS_PROCESSOR Processor on Processor.ResourceID = SYS.ResourceIDLEFT JOIN v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID = OPSYS.ResourceIDLEFT JOIN v_GS_DISK DSYS on SYS.ResourceID = DSYS.ResourceIDLEFT JOIN v_RA_System_SystemContainerName ADCON on ADCON.ResourceID = SYS.ResourceIDLEFT JOIN v_RA_System_SystemOUName ADOU on ADOU.ResourceID = SYS.ResourceIDLEFT JOIN v_RA_System_SystemGroupName ADGRP on ADGRP.ResourceID = SYS.ResourceID
WHERE SYS.AD_Site_Name0 LIKE 'FRANKFURT'
ORDER BY ADOU.System_OU_Name0