Dong Shin 10.16.2012

  • continue working on Alerts
  • query to alert users that have not been logged on for more than 30 days
    • SELECT
      NULL as porfolio_admins,
      NULL as portfolio_mgrs,
      NULL as service_finance_pocs,
      NULL as service_project_managers,
      ” as program,
      ” as MIPR,
      CONCAT(login, ‘ has not been logged in for more than 30 days ‘) as alert,
      ‘OPEN’ as status
      FROM `users`
      WHERE DATEDIFF(now(), last_login) > 30
    • script – UsersNotLoggedIn30Days.py and UsersNotLoggeIn30DaysSaveToTable.py
  • added TAB support for PrettyTextEditor in VSS4
    • protected function keyFocusChange(evt:FocusEvent) : void {
      evt.preventDefault();
      evt.currentTarget.insertText(”    “);
      }
  • created a script to return status of Alerts with days – AlertsStatus.py