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?