3 Replies Latest reply on May 13, 2010 12:58 PM by Bill Robinson

    PopReports for only Patch Analysis?

      We've recently discovered that we could modify the PopReports.nsh file where, when we run it, it pushes our OS_CONFIG\Server Inventory info to our reporting database. This is great since it only takes 1.5hrs to complete, as opposed to the regular 6.5hr job our unmodified PopReports script takes.

       

      Here is a copy of the modified script:

      #!/bin/nsh

      ###########
      #
      # Reports Data Population
      # BladeLogic, Inc.
      #
      ####
      #
      # This script loads the data warehouse used for reporting.
      #
      ############


      REPORTS_SERVER=gdcsrvnwh063
      REPORTS_DIR=/usr/local/bl-reports
      REPORTS_DIR_OS_SPECIFIC=/usr/local/bl-reports
      POPULATE_SVRINV_SCHEMA=./populate_svrinv_schema.sh
      POPULATE_SVRINV_SCHEMA_PATH=${REPORTS_DIR}/bin/${POPULATE_SVRINV_SCHEMA}
      LOAD_WAREHOUSE=./load_warehouse.sh
      LOAD_WAREHOUSE_PATH=${REPORTS_DIR}/bin/${LOAD_WAREHOUSE}
      CREATE_ADHOC_INDEXES=./create_adhoc_indexes.sh
      CREATE_ADHOC_INDEXES_PATH=${REPORTS_DIR}/bin/${CREATE_ADHOC_INDEXES}

      BASE_LOCATION=//${REPORTS_SERVER}${REPORTS_DIR}
      REPORTS_DIR_BIN=${BASE_LOCATION}/bin

      ############
      # Run the DataMover to load the warehouse
      ############
      echo "Attempting to load the warehouse"
      #nexec $REPORTS_SERVER "$LOAD_WAREHOUSE_PATH"
      retval=$?
      if [ $retval -ne 0 ]
      then
          echo "Loading of the warehouse failed"
      else
          ############
          # Populate the generated server inventory warehouse tables
          ############
          echo "Attempting to load all other server inventory data"
          nexec $REPORTS_SERVER "$POPULATE_SVRINV_SCHEMA_PATH"
          retval=$?
          if [ $retval -ne 0 ]
          then
              echo "Loading of server inventory data failed"
          else
              echo "Creating AdHoc Indexes"
              nexec $REPORTS_SERVER "$CREATE_ADHOC_INDEXES_PATH"
              retval=$?
              if [ $retval -ne 0 ]
              then
                  echo "Create AdHoc Indexes failed"
              fi
          fi
      fi

      exit $retval

      The modified line is in red and underlined.

       

       

      Now, is there a modification we can make that can upload just patch analysis info into the reporting dbase?

      Right now, the only option is to run (unmodified) PopReports but like I had siad, it takes 6.5hrs and we can't afford to run that twice in one day.