...
- 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
Customer/Prospect | Contact | Server Location | Service | Cloud | Release | Level | Auth. Mode | NOTES |
CRIS | Jeffrey Silber | sf-dfacit-db-02 | CRIS | No | 2008 R2 | Prod | Windows | |
CALS | Mike Barre | sf-cals-dbstage.serverfarm.cornell.edu | EC2 - Dedicated | 2017 | Prod/Test | Windows | ||
CALS | Mike Barre | admincomp-proddb1.cals.cornell.edu | CALSPROD | No | 2008 R2 | Prod | Windows | Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man |
CALS | Mike Barre | admincomp-db1.cals.cornell.edu | CALS_RS_TEST | No | 2008 R2 | Test | Windows | Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man |
CALS | Mike Barre | admincomp-devdb2.cals.cornell.edu | CALS_SANDBOX | No | 2008 R2 | Sandbox | Windows | Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man |
Media Site | Andy Page | sf-dublin07 | Media Site | No | 2008 R2 | Prod | Windows | |
Crestron Room View | Andy Page | sf-dublin08 | Crestron Room View | No | 2008 R2 | Prod | Windows | |
Extron GVE | Andy Page | sf-dublin09 | Extron GVE | No | 2008 R2 | Dev | Windows | Retired Aug/2017: DB backed up to E:\MSSQL_RDBMS_BACKUP_KEEP\ on Dublin16 |
TMS Database | Andy Page | sf-dublin10 | TMS Database | No | 2008 R2 | Prod | Windows | |
Crestron Room View | Andy Page | sf-dublin11 | Crestron Room View | No | 2008 R2 | Test | Windows |
ODAA/SandBox |
sf-dublin12 |
SF-DUBLIN12\ODAAMSSQLSERVER | No |
2016 | Sandbox | Windows | ||||||
Video Software TMS | Andy Page | sf-york21.serverfarm.cornell.edu | CU View Digital Signage | No | 2008 R2 | Prod | Windows | |
Facilities DB's (four apps) | Dan Klinger | sf-dublin17 | Dublin17 | EC2 - Dedicated | 2017 | Prod | Windows | |
FitPro | Dan Klinger | SF-FS-DBS-004 | No | 2017 | Prod | Windows | Will Go away once moved to cloud | |
Josh Woodard - CALS | Josh Woodard | sf-lobster01 | MSSQLSVRAG | No | 2014 | Dev/Test | Windows |
Older inventory ...
Server Name | Service | Environment | Release | Manager | Date | Status | Note |
---|---|---|---|---|---|---|---|
sf-lobster01 | SF-LOBSTER01\MSSQLSVRAG | Dev/Test | 2014 | Joshua Woodard | July 2016 | Active | RDP through hopperrdp |
admincomp-proddb1.cals.cornell.edu | CALSPROD | Prod | 2008 R2 | Mike Barre | May 2016 | Active | 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 |
admincomp-devdb2.cals.cornell.edu | CALS_SANDBOX | SandBox | 2014 | Mike Barre | May 2016 | Active | 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 |
admincomp-db1.cals.cornell.edu | CALS_RS_TEST | Test | 2008 R2 | Mike Barre | May 2016 | Active | 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 |
sf-dublin07 | Media site | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
sf-dublin08 | Crestron Room View | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
sf-dublin09 | Extron GVE | Dev | 2008 R2 | Andrew M. Page | Jan 2016 | Active | 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 |
sf-dublin10 | TMS Database | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
sf-dublin11 | Crestron Room View | Test | 2012 R2 | Andrew M. Page | Jan 2016 | Active | |
sf-york21 | CU View Digital Signage | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
sf-dublin12 | SF-DUBLIN12\ODAAMSSQLSERVER | SandBox | 2016 | April 2016 | Active | access through hopperrdp |