SQL question - report the relationships

SQL question - report the relationships

Hello

I need a list of the relations between my assets.The want to know, which PC has a relationship to what display, which printer is connected to the PC and who is the user of the PC. In fact, I want to have a part of the information which is shown in the Relationship tab of a workstation but in list form for every PC (asset of type workstation) in my inventory. (the red zones in the attached screenshot)


The list should show following fields

Asset-name of type PC;component-name of type display;asset-name of type printer;username

PC-1123;D-012;P-34;jdoe
PC-1224;;sdoe
PC-1225;D-123;;tdoe
PC-1229;;;


Thanks a lot for your help

Best regards, Marc


                  New to ADSelfService Plus?