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?