[racktables-users] Re: Another Report Question
- From: "Aaron Dummer" <aaron@xxxxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Tue, 03 Feb 2009 12:32:47 -0600
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:
