Browse by Tags

List of PCs by OU
Sunday, July 24, 2011 9:57 AM

select R . Name0 as 'PC' , right( OU . System_OU_Name0 , CHARINDEX ( '/' , reverse ( Max ( OU . System_OU_Name0 )))- 1 ) as 'OU' from dbo . v_R_System R left outer join dbo . v_RA_System_SystemOUName OU on R . ResourceID = OU . ResourceID Group by R . Name0 , OU . System_OU_Name0 Order by R . Name0 Read More...

by Garth Jones

Filed under: SMS, Code, SCCM, vNext, OU