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?