Versions Compared

Old Version 24

changes.mady.by.user Garry Chen

Saved on

compared with

New Version Current

changes.mady.by.user Gary S. Chaika

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Request a local server admin account
  2. VPN to the server or RDP through hopperrdp.cit.cornell.edu
  3. Using Microsoft SQL Server Management Studio and enter information

Server Inventory (as of November 02, 2018)

Customer/ProspectContactServer LocationServiceDB Name/CountCloud (Y/N)ReleaseOSLevelAuth. ModeNOTES
        
 
CRISJeffrey Silbersf-dfacit-db-02
CRIS
SF-DFACIT-DB-02multiple (41)No
2008 R2
2012W2012ProdWindows 
CALS Mike Barresf-cals-dbstage.serverfarm.cornell.edu
 
SF-CALS-DBSTAGEmultiple (9)EC2 - Dedicated 2017W2016Prod/TestWindows 
CALS Mike Barreadmincomp-proddb1.cals.cornell.eduCALSPRODmultipleNo2008 R2W2008ProdWindows
Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man
Being replaced end of 2019
CALS Mike Barreadmincomp-db1.cals.cornell.eduCALS_RS_TESTmultipleNo2008 R2W2008TestWindows
Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man
Being replaced end of 2019
CALS Mike Barreadmincomp-devdb2.cals.cornell.eduCALS_SANDBOXmultipleNo2008 R2W2008SandboxWindows
Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man
See Comment - Being replaced
Media SiteAndy Pagesf-dublin07
Media Site
.serverfarm.cornell.eduSF-DUBLIN07multipleNo2008 R2W2008ProdWindows
 
Retired Sept 2018
Crestron Room ViewAndy Pagesf-dublin08
.serverfarm.cornell.eduSF-DUBLIN08multiple(2)
Crestron Room View
No2008 R2W2008ProdWindows 
Extron GVEAndy Pagesf-dublin09
Extron GVE
.serverfarm.cornell.eduSF-DUBLIN09multipleNo2008 R2W2008DevWindowsRetired Aug/2017
: DB backed up to E:\MSSQL_RDBMS_BACKUP_KEEP\ on Dublin16
See Comments
TMS DatabaseAndy Pagesf-dublin10.serverfarm.cornell.eduSF-DUBLIN10multipleNo2008 R2W2008ProdWindowsRetired Sept 2018
TMS DatabaseAndy Pagesf-zappa004.serverfarm.cornell.eduSF-ZAPPA004multiple (2)No2016
2008 R2
W2012ProdWindows 
Crestron Room ViewAndy Pagesf-dublin11
.serverfarm.cornell.eduMSSQLSERVERmultiple (4)
Crestron Room View
No2008 R2W2012TestWindows 
ODAA/SandBox
 
N/Asf-dublin12.serverfarm.cornell.eduSF-DUBLIN12
\ODAAMSSQLSERVER
multipleNo2016W2012SandboxWindows 
Video Software TMSAndy Pagesf-york21.serverfarm.cornell.edu
CU View Digital Signage
SF-YORK21multiple (3)No2008 R2W2008ProdWindows 
Security (Remedy Scan)Eric Nobelsf-dublin16.serverfarm.cornell.eduSF-DUBLIN16cornell_prd_arNo 2012W2012ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17
Dublin17
.serverfarm.cornell.eduSF-DUBLIN17c2cbusEC2 - Dedicated 2017W2016ProdWindows 
FitPro
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-
FS-DBS-004  
DUBLIN17cupd_gisdbEC2 - Dedicated 
No
2017W2016ProdWindows
Will Go away once moved to cloud
 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17FitProDataEC2 - Dedicated 2017W2016Prod
Josh Woodard - CALSJosh Woodardsf-lobster01MSSQLSVRAGNo2014Dev/Test
Windows 

 

 

Older inventory ...

...

Joshua Woodard

...

Group:  CornellVPN (cit.staff)

Username:   netid@AG-vpn-admin-it

access through dublin02 using MS management Studio by windows authentication.

CALS BDA: Velvet L. Saunders

...

Group:  CornellVPN (cit.staff)

Username:   netid@AG-vpn-admin-it

access through dublin02 using MS management Studio by windows authentication. OR RDP to the server

CALS BDA: Velvet L. Saunders

...

Group:  CornellVPN (cit.staff)

Username:   netid@AG-vpn-admin-it

access through dublin02 using MS management Studio by windows authentication.

CALS BDA: Velvet L. Saunders

...

Retired: August 2017

A database backup named "GVE_backup_2017_08_02_000054_0577600.bak" taken on 2017/08/02@11:29 was saved at dublin16 E:\MSSQL_RDBMS_BACKUP_KEEP\dublin09_GVE_save for 1 year

...

Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17FS-PROSAFEEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17gisdbEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17MCMG2EC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17public_gisdbEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17tmsfuelmasterEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB (one app)Dan Klingersf-hanover02.serverfarm.cornell.eduHANOVER02mail meteringEC2 - Dedicated2014W2016ProdWindowsApp would only run on SQL 2014
Cindy Sedlacek/TableauCindy Sedlaceksf-hanover03.serverfarm.cornell.eduHANOVER03multipleEC2 - Dedicated2017W2016ProdWindows 
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\PRODmultipleEC2 - Dedicated 2017W2016ProdWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\ACAmultipleEC2 - Dedicated 2017W2016Dev/TestWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\DEVmultipleEC2 - Dedicated 2017W2016ProdWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\DEVGITmultipleEC2 - Dedicated 2017W2016Dev/TestWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\NADGANmultipleEC2 - Dedicated 2017W2016Dev/TestWindowsInstalled as "Named Instances"
Police David Brooksacp-jarvis.acp.cornell.eduACP-JARVISmultipleNo2014W2012ProdWindowsMust be logged in via VPN
Police David Brooksacp-birch.acp.cornell.eduACP-BIRCHmultipleNo2014W2012Dev/TestWindowsMust be logged in via VPN

 

Older inventory ...

 

 

...