SQL 2005 code to list Assets and all associated Components

SQL 2005 code to list Assets and all associated Components

I am trying to produce a Visio drawings showing links between Business Process and the dependant Assets and Components neccessary to deliver the Service.
 
I've asked for the question a few times now and would be very grateful if someone could assist.
 
Regards
Dave

                  New to ADSelfService Plus?