Report to pull Name, Serial, Model and Object Creation in SCCM for Specific OU

SELECT
A.Name0,
B.SerialNumber0,
A.Model0,
MAX(O.System_ou_name0) AS ‘OU’,
C.Creation_Date0 AS ‘Creation Date’

FROM
v_GS_COMPUTER_SYSTEM A,
v_GS_PC_BIOS B,
v_R_System C,
v_RA_System_SystemOUName O

WHERE
A.ResourceID = B.ResourceID AND
A.ResourceID = C.ResourceID AND
A.ResourceID = O.ResourceID AND
J.System_ou_name0 like ‘Domain Name/COMPUTERS’

GROUP BY A.Name0, B.SerialNumber0, A.Model0, O.system_ou_name0, C.Creation_Date0

————————————-

Please note that the OU Path will need updated to be used in your environment, this is easily tweeked to do multiple OUs as well.