[racktables-users] Re: Custom Reports
- From: "Farrington, Ryan" <rfarrington@xxxxxxxxxxxxx>
- To: "'racktables-users@xxxxxxxxxxxxx'" <racktables-users@xxxxxxxxxxxxx>
- Date: Thu, 27 Jan 2011 14:50:18 +0000
Shan,
Do you have PHP logging errors? I would check there to find where the
contributed code is throwing an error and trace it down from there. There was
an update to the warranty.php on the 14th of January, did you grab your
warranty.php before or after that time?
The basics of the report is a simple SQL query pasted below and it is looking
for already expired warranties.
--- SNIP ---
SELECT a.string_value as ExpirationDate, r.id, r.name, r.barcode, r.asset_no
FROM AttributeValue a Left JOIN RackObject r ON a.object_id = r.id where
attr_id=22 and STR_TO_DATE(a.string_value, '%m/%d/%Y') <= curdate()
--- END SNIP ---
Ryan Farrington
Senior Systems Engineer
MedAssets
Direct 972.244.0312 | Cell 972.836.6431 |
5556 Tennyson Pkwy
Suite 200, Plano, TX 75024
www.medassets.com
*****Attention*****
This electronic transmission may contain confidential, sensitive, proprietary
and/or privileged information belonging to the sender. This information,
including any attached files, is intended only for the persons or entities to
which it is addressed. Authorized recipients of this information are prohibited
from disclosing the information to any unauthorized party and are required to
properly dispose of the information upon fulfillment of its need/use, unless
otherwise required by law. Any review, retransmission, dissemination or other
use of, or taking of any action in reliance upon this information by any person
or entity other than the intended recipient is prohibited. If you have received
this electronic transmission in error, please notify the sender and properly
dispose of the information immediately.
-----Original Message-----
From: racktables-users-bounce@xxxxxxxxxxxxx
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Shannon Young
Sent: Thursday, January 13, 2011 11:32 AM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Custom Reports
Hi All,
I see that this has been asked before but implementing it seems to not work
still. I’m currently running Racktables 0.18.5 on Ubuntu server and I’m trying
to pull a report that will show all my servers with the current warranty
information. I tried using the current warranty.php found
http://racktables.svn.sourceforge.net/viewvc/racktables/contribs/ renaming it
to inc/local.php and it creates the “Warranty Expires” tab in Reports however
it is a blank page.
Can any one point me in the right direction on how I might be able to export
this data without having to manually do so?
Any help greatly appreciated!
Shan
Other related posts:
