• No results found

Server Name(s) Database Name Application

N/A
N/A
Protected

Academic year: 2021

Share "Server Name(s) Database Name Application"

Copied!
18
0
0

Loading.... (view fulltext now)

Full text

(1)

Server Name(s) Database Name Application

bpl‐oracle1;bpl‐oracle2 MAXPROD Maximo

bpl‐oracle1;bpl‐oracle2 LAWPROD Lawson

bpl‐oracle1;bpl‐oracle2 IMGNOW Image Now

bpl‐oracle1;bpl‐oracle2 LIVELNK Livelink

bpl‐oracle1;bpl‐oracle2 CMCR Contract Management

bpl‐oracle1;bpl‐oracle2 P6ORA P6

bpl‐oracle1;bpl‐oracle2 P6SB01 P6

bpl‐oracle1;bpl‐oracle2 GIS ArcGis

bpl‐oracle1;bpl‐oracle2 TEAMTRK Team Track Change Management

bpl‐oracle1;bpl‐oracle2 RMAN Recovery Manager

bpl‐oracle1;bpl‐oracle2 SLETM Secure Logix

bpl‐oracle1;bpl‐oracle2 BWTPMD Process Control Historian

bpl‐oracle1;bpl‐oracle2 IABPROD Impervious Billing

bpl‐oracle1;bpl‐oracle2 WAREHS9 Warehouse

bpl‐oracle1;bpl‐oracle2 SCALES Scales

bpl‐oracle1;bpl‐oracle2 FLEET FleetWave

sun‐rdc LAWPROD Lawson Standby

(2)

sun‐rdc GIS ArcGIS

cmf‐oradev PCT Procurement Contract Tool

cmf‐oradev PIMS Vertex / Oracle

bpl‐sqlreports2 VHR_DCW Ceridian bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent,  probation_union CDL Certification bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent,  probation_union ALL HCM Applications bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent,  probation_union Driver's License  bpl‐sqlreports2 cdlemailsent, DC Water Heads, emailsent,  probation_union eRecruiter Application tracking system

bpl‐sqlreports2 probation_union HCM probationary

bpl‐sqlreports2 SimpleK; SimpleK‐arch SimpleK

FST‐AMRDB; RDC‐AMRDB StarDatabase Star 

FST‐AMRDB; RDC‐AMRDB CustomerBillingDB Billing Programs

(3)

RDC‐AMRHST StarHistorical Historical customer data

Bpl‐sqlreports2 SimpleK; SimpleK‐arch SimpleK

fst‐sql ivrstats ivr

fst‐sql NCCS_Web AMR Graph/HUNA

fst‐sql huna_test huna

bpl‐sqlcluster ivrstats ivr

bpl‐sqlcluster huna_test Website/HUNA

fst‐sql NCCS_Web* HUNA Dev/Test

bpl‐sqlreports2 KofaxCapture Kofax (Production)

(4)

bpl‐synapp sys_elogger eLogger

bpl‐sqlreports2 cAsset cSupport

bpl‐sqlreports2 cSupport cSupport

bpl‐sqlreports2 cSupport_Bomgar cSupport

bpl‐sqlreports2 cSupport_Workflow cSupport

bpl‐sqlreports2 cSupportReporting cSupport

bpl‐sqlreports2 cSurvey cSupport

bpl‐sqlreports2 WeekStats cSupport

bplsqlcluster license_agreement Software Management

bplsqlcluster license_manager Software Management

Monet aotask AO Task System

Monet avr AV Request System

Monet critlist Critical Equipment List

Monet cts Customer Tracking

Monet hr_fitness HR Fitness System

Monet lead_db

Lead Management System  (leaddata/leadreports)

Monet port13 PORTS

Monet Correspondence Procurement Tracking

Monet scts Security Case Manager 

Monet Correspondence Correspondence Tracking

Monet AMRGRAPH NCCS_Web

copland AMRGRAPH Internal NCCS_Web

bpl‐spsqlclus WSS_Content_HomePagePortal Intranet Home Page (MOSS 2007) bpl‐spsqlclus WSS_Content_Facilities Intranet Facilities Site(MOSS 2007) bpl‐spsqlclus WSS_Content_ab422be214ec4d5e81e6f18e53522125 Mysites (MOSS 2007)

(5)

bpl‐spsqlclus WSS_Content SharedServiceProvider(MOSS 2007) bpl‐spsqlclus

WSS_Content_55cac66abcd84b78956e76142bfc8891_

1 Intranet Sharepoint Site (MOSS 2007)

bpl‐spsqlclus SharePoint_AdminContent_e5d87842‐6b26‐4f59‐a281‐ SharePoint Central Administration V3 (MOSS 

bpl‐spsqlclus WSS_Content_SSP2Mysite SSP2Mysite(MOSS 2007)

BPL‐SPSQLNODE PipelineBlue_Content_IT Pipelineblue2010 IT Site (SharePoint Server  2010) BPL‐SPSQLNODE Pipelineblue_Content_GIS Pipelineblue2010 Office of General Counsel  Site (SharePoint Server 2010) BPL‐SPSQLNODE SharePoint_AdminContent SharePoint Server 2010 Central Administration  Site  OSTSPSQL SharePoint_AdminContent_2b66ec27‐eac5‐4439‐81f9‐ fa7bdc9a9eb3 SharePoint Server 2010 Central Administration  Site (Current Development Environment) Cmfspsql WSS_Content_PipelineIntra Intranet Homepage: SharePoint 2010 Server  (Future Production Environment) Cmfspsql WSS_Content_DETS Department of Engineerng Site :SharePoint  2010 Server (Future Production Environment) Cmfspsql WSS_Content_EA External Affairs Site: SharePoint 2010 Server  (Production Environment) Cmfspsql WSS_Content_HCM Human Capital Management Site: SharePoint  2010 Server (Future Production Environment) Cmfspsql WSS_Content_IT Information Technology Site: SharePoint 2010  Server (Future Production Environment) Cmfspsql WSS_Content_OtherDeps SharePoint 2010 Server (Future Production  Environment) Cmfspsql SharePoint_AdminContent_6606ebfe‐d5d9‐4503‐a51a‐ 91119ea47c11 SharePoint Server 2010  Central Administration  Site (Production Environment) Cmfspsql WSS_Content_MySites MySite: SharePoint Server 2010 (Future  Production Environment)

(6)
(7)

Description Age Public Access Asset Management Production Database, includes assets such as 

Hydrants, Pipes, and the Work Orders associated with maintenance 

and repair 7+ years None

Commercial Financial and Procurement Production Database, 

includes vendor information, purchase orders, commercial contracts, 

payments, etc.   7+ years None

Image Now Production Database for scanned invoices, etc. The 

metadata for scanned images, is stored in database 4+ years None Document management Production Database, storing metadata for 

externally stored documents  4+ years None

Contract Management Production Database. Includes projects, daily 

reports, correspondence, images associated with projects, etc.  2 years None Project Management Production for CIP Projects. Project, vendor, 

progress information is stored.  2 years None

Project Management Production for non‐CIP Projects. Project, 

vendor, progress information is stored.  2 years None GIS Mapping Production Database. Coordinates of externally located 

assets are stored.  4 years None

Change Management Production Database. IT change management 

requst workflow information.  3 years None

Oracle Recovery Manager Production Database 7+ years None Telephony Call Management Production Database 7+ years None WasteWater Production Reporting Database 7+ years None

Impervious Billing Production Database 4 years None

Lawson Production Reporting Database 7+ years None

Truck Scales Management / reporting Production Database. Trucks, 

deliveries, weights in and out, images of license plates, etc.  1 year None Fleet Management Production Database. Motor assets, driver 

information.  1 year None

Redundant Database for Lawson Disaster Recovery 5 years None Redundant Database for Maximo Disaster Recovery 5 years None

(8)

Redundant Database for GIS Disaster Recovery 4 years None Contract reporting for Procurement. Pulls information from Lawson, 

but only stores some contract information.  4 years None Vertex Reporting Tool. Payment and customer information pulled 

from Vertex external database maintained by third party.  1 year None This database is used for HCM to do their SQL Reprting  None This database is used for HCM to automatically notify employees that  it is time to get their CDL Certificate renewed None this database is used to extract the employee's department head to  send him a copy of the letter that the employee is receiving None this database tracks to see if the employee received their notice that  their driver's license it going to expire Y72 or Y30 None Reporting database HCM uses monthly to run custom applicant  reports. This is an auto feed from Ceridian None this database keeps track of employees who's has been working for  DC Water for 9 months and sends a reminder to the Director 3  months before the employee's probationary time is up so the  Director can deside if they would d       None This DB is used by Facilities; currently the access is setup through  SimpleK application and limited to the added users. For backend the  access is based on DB Profiles None This DB is used for storing Automated Meter Readings. This data  provides daily export to AMR Graph/HUNA database instances.  Access to this db is through web interface (internal website) and  through DB users and profiles None This DB is used for managing Daily Meter Downloads/Uploads  from/to Vertex. Users have limited access based on their DB roles  None This DB is used for providing daily extract to AMR GIS Dashboard.  Users have limited access based on their DB Roles None

(9)

Stores Star historical data; access is via a Web Interface and DB user  list based on managed roles None This DB is used by Facilities; currently the access is setup through  SimpleK application and limited to the added users. For backend the  access is based on DB Profiles None production ivrstats database ‐ stores IVR‐related stats & data like Call  Volume, Employment Opportunity Listings, etc. None Used to calculate usage (which is then queried for high usage, and  notifications sent out). Also used by AMR Graph The database itself is not public, there is a web  AMR Graph interface that is public & displays the  data in NCCS_Web to customers Backup ivrstats database (Production is on FST‐SQL) None production HUNA database keeps track of our customer high usuage  water events, notifications, and preferences The database itself is not public, but data in the  database is displayed to customers in the form of a  HUNA email, phone call, or text message.  HUNA  preferences that are stored in this database are  displayed to customers via a web interface  (Through AMR Graph) production HUNA database keeps track of our customer high usuage  water events, notifications, and preferences The database itself is not public, but data in the  database is displayed to customers in the form of a  HUNA email, phone call, or text message.  HUNA  preferences that are stored in this database are  displayed to customers via a web interface  (Through AMR Graph) "NCCS_Web" is production. Any database that starts with NCCS_Web  (like NCCS_Web_Star5) is a temporarty Dev/Test database. The  Dev/Test instance is used to dev/test a chance to AMR Graph or  HUNA None Database for the Production Kofax system.  Kofax is part of the  Enterprise Document Management System, used to process and  release documents to Livelink.   None Electronic logbook software replaces paper log books and  disconnected systems collecting, storing and distributing real‐time  data about your 24 x 7 operations None

(10)

The system in place was deployed in 2009 and remains current with  rolling application upgrades from the vendor None None IT‐Ticket Application None IT ‐ Ticket Application? None IT‐Ticket application workflow None Reporting module None Stores customer survey information None Report Manger None Keeps track of software purchaced / Software inventory None administartion setup database None Commercial system for mapping organizational goals to departmental  tasks. None System for tracking room set‐up requests for A/V. None Tracks maintenance and impact of sewer/water system components None None Used during the 1010 walk company fitness program to track and  compare teams. This is a seasonal database None System for tracking lead test kit results None IT Purchase Order Request Tracking System None Correspondence tracking system for Procurement's use None Tracks security incidents and responses None Correspondence tracking system for DC Water users None Allows our customers to view their water usage daily, weekly or  yearly Yes Allows our Customer Service folks to view our customers water usage  daily, weekly or yearly and assist them with any problems None Current Intranet Homepage in Production Environment None Current Facilities Departmental Site and Boardroom Calendar None Content from Mysites are used in Phonebook application of current  intranet site None

(11)

Diffferent Services Used by MOSS 2007 None MOSS 2007 SharePoint sites with different departments contents  (Current in Production) None MOSS 2007 Central Administration  None MOSS 2007 Mysite None Pipelineblue2010 IT Site (old environmemnt‐not in production) None Office of the General Counsel Calendar Feature is in use  None Centeal Adminstration Site (old production environment) None Managing Development Environment None Hosting Intranet HomePage None Hosting Engineering Site if Needed in Future None Hosting External Affairs Site if Needed in Future None Hosting HCM Site if Needed in Future None Hosting IT Site if Needed in Future None Hosting Other Departmental Site if Needed in Future None Managing All Intranet Web Applications None Hosting MySite if needed in future None

(12)

Populating Required Employee Information From Human Capital 

(13)

Version Upgrades/Miscellous/Notes Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter

(14)

Oracle 10.2.0.3 Upgrade to 11.2.0.3 next quarter Oracle 11.2.0.3 None Oracle 11.2.0.3 None SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A

(15)

SQL2000 N/A SQL2005 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2000 N/A SQL2005 N/A SQL2005 N/A

(16)

SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A SQL2005 N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A mysql N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A

(17)

SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2005 ‐ 9.00.5069.00 (X64) N/A SQL2008 R3 N/A SQL2008 R4 N/A SQL2008 R5 N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A SQL2012 (SP1) ‐ 11.0.3000.0 (X64) N/A

(18)

References

Related documents

Ratios of gene expression for 47 AP2/ERF genes of Hevea brasiliensis in response to latex harvesting stress in mature trees and various types of abiotic stress in juvenile

In the case where original ballast mounting holes are not used to mount the LED driver, leave the ballast mounting screws in their original holes in the enclosure9. Open the

• Insurers need to ensure consumers are aware of the full cost of GI products, are clear about what is and isn’t covered (particularly when it may be reasonably expected), and

Where a client has a privately purchased wheelchair Dorset Wheelchair Service still has a responsibility to provide a seating system to meet the clinical need of the user

In fact, the only readily available data was from the World Health Organization Cholera Report, namely the number of cholera cases in each region per year, the number of

 Complete migrate from MS SharePoint 2007 to SharePoint 2010  Deploy Microsoft Office 2010 Suite to Township Employees  Replace end of life SQL server with Virtualized server

Furthermore, the spectral efficiency of the STFSK- aided SFHMA, the Gaussian minimum shift keying (GMSK)-aided SFHMA, and the conventional GMSK-aided TD/FDMA systems will be

System Center 2012 Suite Windows 8 Windows 7 Office 365 Collaborative Tools Lync Server 2010 Exchange Server 2013 Exchange Server 2010 SharePoint Server 2010 SharePoint Server