[racktables-users] Re: Another Report Question

Agreed!

 

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:41 PM
To: racktables-users@xxxxxxxxxxxxx
Subject: [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: