# Presentation: 148684

## Information Management

- Project Status Report
- October 3, 2006

## Introduction

- Workflow
- CST Applications
- TAP
- Remedy
- Leave/Travel
- Certificates
- DocDB
- Conference/Meeting Management
- Matrix Replacement
- Development Issues

## Workflow Tool

- AlphaFlow in production
- Piloting Leave/Travel requests
- Replacement for Matrix

## CST Applications

- FCIRT Ticket Tracking – ready for production
- Risk Analysis
- Maintenance screens in production
- Questionnaire ready
- waiting on Oracle to Postgres DB link
- baseline questions not in database

## Task, Activities & Projects

- Oracle Workbench – a tool to convert non-Oracle databases to Oracle
- Eliminate MS Access after the FY2007 budget input process
- Data moved, application accessing Oracle, fixing a few “complex” access views.
- Redesign if sufficient resources are available

## Remedy

- Rebuilding the HD form and CGI
- Reorganizing the PTIs for better metrics
- Automatic assignment based on PTI
- Automated email processing to ease workload on helpdesk personnel
- CGI to run on the central web server and it will not rely on any DB
- Evaluating Footprints as a replacement for Remedy
- Interface with MISJOB

## Leave / Travel

- First application to use AlphaFlow (workflow)
- Phase I (simple leave requests) and Phase II (domestic travel) in pilot testing (CSI & Program Support)
- People submitting leave requests can authenticate in three ways:
- KCA certificate
- DOEGrid certificate
- MISER/Matrix password
- People approving leave requests can authenticate in two ways:
- KCA certificate
- DOEGrid certificate

## Certificates

- All database applications developed to use Oracle’s Apache/Mod_plsql interface now accepts the DOE Grid certificate to authenticate, in addition to
- Capturing data when the helpdesk authorizes the DOEGrid certificate
- Register your DOEGrid Certificate
- Take the PKI Training Class

## DocDB

- V8 in production, rolling out V8.1 Wednesday.  New features:
- CanView option to disable user access.
- Topics can now have sub-topics, sub-sub-topics, etc. Users can also select top level topics for a particular document.
- Users can control the Author order

## Conference/Meeting Management

- SPMS
- Registration module requires an upgrade for credit card processing (no PII in the database)
- Continually comparing features with InDiCo
- InDiCo
- CD is running an instance for Fermilab & ILC
- Collaborating with CERN by contributing to development
- IDS & CSI will contact the PPD conference office in an effort to interest them in adopting SPMS and/or InDiCo

## Matrix Replacement

- Matrix behind in updates
- Development box hacked
- Interdependencies of BEA, Matrix, OS and Oracle causing upgrade delays
- AlphaFlow in production – designed with purchase reqs in mind
- Less time to convert to AlphaFlow than upgrade Matrix

## Development Issues

- Major applications – requires additional security controls best implemented on separate hardware
- High availability instances – preferably on a separate machine
- G1 can no longer handle production and integration instances
- New applications add users and consumes resources

## Miscellaneous

- Capture and track Grid certificates for authentication in addition to Fermilab KCA certificates - Complete
- EquipDB updates for CDF - Complete
- Automation of User Accounts
- creation and termination of accounts
- CST SysAdminDB
- subscribe/unsubscribe to/from group level mailing lists based on Org Chart