Paul, try this: select RackObject.name, Port.name, Port.label from Port, RackObject where RackObject.id = Port.object_id order by RackObject.name; Luis On Tue, 2009-02-03 at 12:23 -0600, Paul Seymour wrote: > 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. > > > > I’m trying to build a new query to see what I can find. Any help you > can provide would be great J. > > > > > Paul Seymour > > Datacenter Operations > > Lore Systems > > pseymour@xxxxxxxx > > Office – 703-542-2200 x141 > > Cell – 703-231-1086 > > P Lore Systems is an industry leader in Green IT & Datacenters. > > Please consider the environment before printing this > email. > > > > > > > From:racktables-users-bounce@xxxxxxxxxxxxx > [mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Rob Buijs > Sent: Tuesday, February 03, 2009 1:00 PM > To: racktables-users@xxxxxxxxxxxxx > Subject: [racktables-users] Re: Another Report Question > > > > > > That's all the code i have. I run it in a mysql query browser. There > is no php wrapper if that's what you're asking for. > > > > > > > > > On 3 feb 2009, at 18:52 , Paul Seymour wrote: > > > > > > > Do you mind copy/pasting the code? > > > > > > Paul Seymour > > > Datacenter Operations > > > Lore Systems > > > pseymour@xxxxxxxx > > > Office – 703-542-2200 x141 > > > Cell – 703-231-1086 > > > P Lore Systems is an industry leader in Green IT & Datacenters. > > > Please consider the environment before printing this > email. > > > > > > From: racktables-users-bounce@xxxxxxxxxxxxx > [mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Rob Buijs > Sent: Tuesday, February 03, 2009 12:45 PM > To: racktables-users@xxxxxxxxxxxxx > Subject: [racktables-users] Re: Another Report Question > > > > > > This is what i use for a list of all rackobjects and most of it's > objects: > > > > > > select distinct R.name > , RO.name > , RO.label > , A.attr_name > , CASE A.attr_type > when "string" then AV.string_value > when "dict" then D.dict_value > when "float" then AV.float_value > else "Stuk" > end Value > from RackObject RO join AttributeValue AV on RO.id = AV.object_id > join Attribute A on A.attr_id = AV.attr_id > left join RackSpace RS on RO.id = RS.object_id > left join Rack R on R.id = RS.rack_id > left join Dictionary D on AV.uint_value = D.dict_key > where A.attr_name not like 'Nagios%' > order by R.name, RO.name, A.attr_name > > > > > > > > > On 3 feb 2009, at 18:39 , Paul Seymour wrote: > > > > > > Searching through the archives I found some information on custom > reports. Here’s the URL specifically: > > > > > > //www.freelists.org/post/racktables-users/Feature-Request,4 > > > > > > Because I am no good at SQL queries, I was wondering if there was any > way to get a list of ALL objects (not just servers) and their ports > and labels. I really don’t need the asset tags, barcodes, or > has_problems. Can anybody give me a helping hand? > > > > > > Paul Seymour > > > Datacenter Operations > > > Lore Systems > > > pseymour@xxxxxxxx > > > Office – 703-542-2200 x141 > > > Cell – 703-231-1086 > > > P Lore Systems is an industry leader in Green IT & Datacenters. > > > Please consider the environment before printing this > email. > > > > > > > > > > > > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.0.233 / Virus Database: 270.10.17/1932 - Release Date: > 02/03/09 07:57:00 > > -- ______________________________________________________ Luis Fernando Lacayo Chicago Public Schools Senior Unix Administrator ITS/ UNIX Infrastructure Office: 773-553-3835 Cell: 773-203-4493 lflacayo@xxxxxxxxxxxxx ______________________________________________________ "In God we trust, the rest we monitor ..."