[racktables-users] Re: Custom Reports?

  • From: "Farrington, Ryan" <rfarrington@xxxxxxxxxxxxx>
  • To: <racktables-users@xxxxxxxxxxxxx>
  • Date: Wed, 20 Jan 2010 10:39:32 -0500

I am by no means a SQL expert but with the size of our data (approx 400
machines) this runs in .0026s




-----Original Message-----
From: racktables-users-bounce@xxxxxxxxxxxxx
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Jason
Ledford
Sent: Tuesday, January 19, 2010 6:26 PM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: Custom Reports?

post your sql.  I have a report (based on help from this list) and I can
plug the sql in see if it works.  if it does I will forward you the
report file I have to drop in place.

_________________________
From: racktables-users-bounce@xxxxxxxxxxxxx
[racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Farrington, Ryan
[rfarrington@xxxxxxxxxxxxx]
Sent: Tuesday, January 19, 2010 2:09 PM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Custom Reports?

I was hoping to provide a custom report for all hardware listed with No
Warranty expiration (attr_id=22) and all hardware where the warranty is
older than the current date.  I have the query to get the results and
was hoping for the reports area to allow for a plugin of sorts where I
do not have to chew into a mountain of code to get this. Does anyone
have an idea where I could begin?



Ryan Farrington
Senior Systems Engineer

MedAssets
5556 Tennyson Pkwy
Suite 200
Plano TX 75024
Direct - 972-244-0312
Cell - (972) 757-3028


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential, proprietary, and/or
privileged material. Any review, retransmission, dissemination or other
use of, or taking of any action in reliance upon this information by
persons or entities other than the intended recipient is prohibited. If
you received this in error, please contact the sender and delete the
material from all computers





The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential, proprietary, and/or privileged 
material. Any review, retransmission, dissemination or other use of, or taking 
of any action in reliance upon this information by persons or entities other 
than the intended recipient is prohibited. If you received this in error, 
please contact the sender and delete the material from all computers

Other related posts: