4 Replies Latest reply: Oct 12, 2011 9:57 AM by Gerardo Bartoccini RSS

Exporting reports via script

Gerardo Bartoccini

I am proficiently using the "export report" feature in blrptadmin.nsh.


It works fine with the following syntax:


./blrptadmin.nsh export report -ss Profile -su BLAdmin -pp password -sr GlobalReportAdmins -at 1 -redfile redfilename


where redfilename contains:


BladeLogic|Dir/1|RPT_test03|Is LatestRun=TRUE;Server Site=Primary |HTML|/opt/bmc/BladeLogic/2.0/reports/portal/webcontent/ReportBuilt/ExportedReports|report


Everything works fine for reports that don't prompt for inventory date.

For reports that prompt for inventory date, it fails.


I have attempted to add the inventory date as follows:


BladeLogic|Dir/1|RPT_test03|Is LatestRun=TRUE;Server Site=Primary;Inventory Date: 'Oct 31, 2011 12:00 AM'|HTML|/opt/bmc/BladeLogic/2.0/reports/portal/webcontent/ReportBuilt/ExportedReports|report


but no luck.

I have attempted different date formats:


Inventory Date='Oct 31, 2011 12:00 AM'
Inventory Date='2011-10-31 12:00:00.000'
Inventory Date='2011-10-31 12:00:00'
Inventory Date=to_date('2011-OCT-31 12:00:00','YYYY-MON-DD HH24:MI:SS')

Inventory Date=to_date('2011-10-31 12:00:00', 'YYYY-MM-DD HH:MI:SS')

but nothing seems to work.

Any clues?