SQL Query - SCCM Breakout OU into Rows

Select Distinct ResourceID, 
replace(
		REVERSE(
				LEFT(
						REVERSE(VOU.System_OU_Name0),
						CHARINDEX('/',REVERSE(VOU.System_OU_Name0))
					)

			  )
	   ,'/',''
	  ) as OU

,LEN(VOU.System_OU_Name0) - LEN(REPLACE(VOU.System_OU_Name0, '/', '')) as depth
,VOU.System_OU_Name0
FROM CM_CEN.dbo.v_RA_System_SystemOUName VOU