[racktables-users] Re: Another Report Question

I think a flexible reporting system would be a nice addition to Racktables ;) 


On 3 feb 2009, at 19:35 , Luis Fernando Lacayo wrote:


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: 





http://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 ..."

Other related posts: