[racktables-users] Re: Another Report Question

Hah.  Thanks.  I ran the query against the racktables database, but it
only returned 3 items...

I just need to select all objects and list their Port.name and
Port.label.


Paul,
This query returns object_id, object name, port name and port label (includes all objects and ports). 

SELECT P.object_id,
             R.name AS object_name,
             P.name AS port_name,
             P.label
  FROM Port P
     JOIN RackObject R ON P.object_id = R.id


--
Aaron Dummer
aaron@xxxxxxxxxxx

Other related posts: