...
- Request a local server admin account
- VPN to the server or RDP through hopperrdp.cit.cornell.edu
- Using Microsoft SQL Server Management Studio and enter information
Server Inventory (as of November 02, 2018)
Customer/Prospect | Contact | Server Location | Service | DB Name/Count | Cloud (Y/N) | Release | OS | Level | Auth. Mode | NOTES |
CRIS | Jeffrey Silber | sf-dfacit-db-02 | SF-DFACIT-DB-02 |
multiple (41) | No |
2012 | W2012 | Prod | Windows | |
CALS | Mike Barre | sf-cals-dbstage.serverfarm.cornell.edu |
SF-CALS-DBSTAGE | multiple (9) | EC2 - Dedicated | 2017 | W2016 | Prod/Test | Windows | |||
CALS | Mike Barre | admincomp-proddb1.cals.cornell.edu | CALSPROD | multiple | No | 2008 R2 | W2008 | Prod | Windows |
Being replaced end of 2019 | |||||||||
CALS | Mike Barre | admincomp-db1.cals.cornell.edu | CALS_RS_TEST | multiple | No | 2008 R2 | W2008 | Test | Windows |
Being replaced end of 2019 | |||||||||
Media Site | Andy Page | sf-dublin07 |
.serverfarm.cornell.edu | SF-DUBLIN07 | multiple | No | 2008 R2 | W2008 | Prod | Windows |
Retired Sept 2018 | ||
Crestron Room View | Andy Page | sf-dublin08 |
.serverfarm.cornell.edu | SF-DUBLIN08 | multiple(2) |
No | 2008 R2 | W2008 | Prod | Windows | ||
Extron GVE | Andy Page | sf-dublin09 |
.serverfarm.cornell.edu | SF-DUBLIN09 | multiple | No | 2008 R2 | W2008 | Dev | Windows | Retired Aug/2017 |
See Comments | ||||||||||
TMS Database | Andy Page | sf-dublin10.serverfarm.cornell.edu | SF-DUBLIN10 | multiple | No | 2008 R2 | W2008 | Prod | Windows | Retired Sept 2018 |
TMS Database | Andy Page | sf-zappa004.serverfarm.cornell.edu | SF-ZAPPA004 | multiple (2) | No |
2016 | W2012 | Prod | Windows | |
Crestron Room View | Andy Page | sf-dublin11 |
.serverfarm.cornell.edu | MSSQLSERVER | multiple (4) |
No | 2008 R2 | W2012 | Test | Windows |
ODAA/SandBox | N/A |
sf-dublin12 |
.serverfarm.cornell.edu | SF-DUBLIN12 | multiple |
No |
2016 | W2012 | Sandbox | Windows | |
Video Software TMS | Andy Page | sf-york21.serverfarm.cornell.edu |
SF-YORK21 | multiple (3) | No | 2008 R2 | W2008 | Prod | Windows | ||||
Security (Remedy Scan) | Eric Nobel | sf-dublin16.serverfarm.cornell.edu | SF-DUBLIN16 | cornell_prd_ar | No | 2012 | W2012 | Prod | Windows | |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17 |
.serverfarm.cornell.edu | SF-DUBLIN17 | c2cbus | EC2 - Dedicated | 2017 | W2016 | Prod | Windows |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF- |
DUBLIN17 | cupd_gisdb | EC2 - Dedicated | 2017 | W2016 |
Prod | Windows |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | FitProData | EC2 - Dedicated | 2017 | W2016 | Prod |
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 Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | FS-PROSAFE | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | gisdb | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | MCMG2 | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | public_gisdb | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | tmsfuelmaster | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
Facilities DB (one app) | Dan Klinger | sf-hanover02.serverfarm.cornell.edu | HANOVER02 | mail metering | EC2 - Dedicated | 2014 | W2016 | Prod | Windows | App would only run on SQL 2014 |
Cindy Sedlacek/Tableau | Cindy Sedlacek | sf-hanover03.serverfarm.cornell.edu | HANOVER03 | multiple | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\PROD | multiple | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | Installed as "Named Instances" |
College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\ACA | multiple | EC2 - Dedicated | 2017 | W2016 | Dev/Test | Windows | Installed as "Named Instances" |
College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\DEV | multiple | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | Installed as "Named Instances" |
College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\DEVGIT | multiple | EC2 - Dedicated | 2017 | W2016 | Dev/Test | Windows | Installed as "Named Instances" |
College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\NADGAN | multiple | EC2 - Dedicated | 2017 | W2016 | Dev/Test | Windows | Installed as "Named Instances" |
Police | David Brooks | acp-jarvis.acp.cornell.edu | ACP-JARVIS | multiple | No | 2014 | W2012 | Prod | Windows | Must be logged in via VPN |
Police | David Brooks | acp-birch.acp.cornell.edu | ACP-BIRCH | multiple | No | 2014 | W2012 | Dev/Test | Windows | Must be logged in via VPN |
Older inventory ...
...