-- MySQL dump 10.13 Distrib 8.0.42, for Linux (x86_64) -- -- Host: localhost Database: trackaccess -- ------------------------------------------------------ -- Server version 8.0.42-0ubuntu0.24.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `AccessLevels` -- DROP TABLE IF EXISTS `AccessLevels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `AccessLevels` ( `access_level` varchar(50) NOT NULL, PRIMARY KEY (`access_level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `AccessLevels` -- LOCK TABLES `AccessLevels` WRITE; /*!40000 ALTER TABLE `AccessLevels` DISABLE KEYS */; INSERT INTO `AccessLevels` VALUES ('basic'),('limited admin'),('power user'),('super admin'); /*!40000 ALTER TABLE `AccessLevels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `AccessRecords` -- DROP TABLE IF EXISTS `AccessRecords`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `AccessRecords` ( `RecordId` int NOT NULL AUTO_INCREMENT, `system_name` varchar(150) NOT NULL, `access_level` varchar(50) NOT NULL, `local_account` varchar(100) DEFAULT NULL, `additional_access` enum('No','Yes') DEFAULT 'No', `UserRoleId` int NOT NULL, PRIMARY KEY (`RecordId`), KEY `UserRoleId` (`UserRoleId`), CONSTRAINT `AccessRecords_ibfk_userrole` FOREIGN KEY (`UserRoleId`) REFERENCES `UserRoles` (`UserRoleId`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=442 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `AccessRecords` -- LOCK TABLES `AccessRecords` WRITE; /*!40000 ALTER TABLE `AccessRecords` DISABLE KEYS */; INSERT INTO `AccessRecords` VALUES (3,'Workday','limited admin','','Yes',40),(6,'Google Vault','limited admin','gts.evans','Yes',40),(8,'Splunk','power user','','No',40),(9,'Sophos','power user','','No',40),(10,'ren-isac.net website','basic',NULL,'No',40),(11,'Qualys','super admin',NULL,'No',40),(13,'Palo Alto Firewall','power user','','No',40),(14,'Microsoft Purview Portal','super admin',NULL,'No',40),(15,'ManageEngine ADManage Plus','power user','','No',40),(16,'Knowbe4 Training Platform','super admin',NULL,'No',40),(17,'JAMF','limited admin','','No',40),(18,'Google Workspace','limited admin',NULL,'No',40),(20,'Kisok Machines Laptop Anywhere','limited admin',NULL,'No',4),(21,'Kaltura','basic',NULL,'No',4),(22,'JAMF','limited admin',NULL,'No',4),(23,'InfoBlox','power user',NULL,'No',4),(24,'Enterprise Appl.','limited admin',NULL,'No',4),(25,'Blackboard Staging','limited admin',NULL,'No',4),(26,'Blackboard','limited admin',NULL,'No',4),(27,'Apple School Manager','limited admin',NULL,'No',4),(28,'25 Live Test','limited admin',NULL,'No',4),(29,'25 Live','limited admin',NULL,'No',4),(30,'workday','basic',NULL,'No',5),(31,'servicenow','basic',NULL,'No',5),(32,'peoplesoft','basic',NULL,'No',5),(33,'jamf','power user',NULL,'No',5),(34,'google admin','power user',NULL,'No',5),(35,'gam','limited admin',NULL,'No',5),(36,'drive s:','basic',NULL,'No',5),(37,'bisonterps usked','basic',NULL,'No',5),(38,'Windows admin','limited admin',NULL,'No',6),(39,'BeyondTrust Remote Support- bomgar - css.van.bavel','power user',NULL,'No',6),(40,'25Live','limited admin',NULL,'No',6),(41,'Zabbix','super admin',NULL,'No',7),(42,'Zabbix','limited admin',NULL,'No',7),(43,'UPS at EMG Data Center','limited admin',NULL,'No',7),(44,'UPS at Benson Data Center','limited admin',NULL,'No',7),(45,'Superna Eyelgass','super admin',NULL,'No',7),(46,'SolarWinds','basic',NULL,'No',7),(47,'Sharepoint','power user',NULL,'No',7),(48,'ResearchNAS','limited admin',NULL,'No',7),(49,'RedHat ','basic',NULL,'No',7),(50,'Park Place (Tech Support)','basic',NULL,'No',7),(51,'Okta','basic',NULL,'No',7),(52,'ManageEngine ADManage Plus','limited admin',NULL,'No',7),(53,'InfoBlox','power user',NULL,'No',7),(54,'InCommon Certificate Manager','limited admin',NULL,'No',7),(55,'GUNAS (NAS5)','limited admin',NULL,'No',7),(56,'Finalsite (Blackboard Connect)','limited admin',NULL,'No',7),(57,'EVO server in Clerc Center','limited admin',NULL,'No',7),(58,'ESXi-VC - Dell R420 Server: VMware VCSA','limited admin',NULL,'No',7),(59,'DRUVA (Apex) Backup','limited admin',NULL,'No',7),(60,'Dell Avamar & DataDomain & Vault Access','limited admin',NULL,'No',7),(61,'DC05 DC15','limited admin',NULL,'No',7),(62,'ClercCenter2 Web','limited admin',NULL,'No',7),(63,'Clerc Buffalo NAS Storage','limited admin',NULL,'No',7),(64,'CAPSW16','limited admin',NULL,'No',7),(65,'BisonVC VMs','limited admin',NULL,'No',7),(66,'BisonVC','limited admin',NULL,'No',7),(67,'Alertus Server - Alertus.gallaudet.edu','super admin',NULL,'No',7),(68,'AlertAware','super admin',NULL,'No',7),(69,'Adoble - T1/T2 Form & GTS.OFFICE','power user',NULL,'No',7),(70,'Zabbix','super admin',NULL,'No',8),(71,'Zabbix','limited admin',NULL,'No',8),(72,'UPS at EMG Data Center','limited admin',NULL,'No',8),(73,'UPS at Benson Data Center','limited admin',NULL,'No',8),(74,'Superna Eyelgass','super admin',NULL,'No',8),(75,'SolarWinds','basic',NULL,'No',8),(76,'Sharepoint','power user',NULL,'No',8),(77,'ResearchNAS','limited admin',NULL,'No',8),(78,'RedHat ','basic',NULL,'No',8),(79,'Park Place (Tech Support)','basic',NULL,'No',8),(80,'Okta','basic',NULL,'No',8),(81,'ManageEngine ADManage Plus','limited admin',NULL,'No',8),(82,'InfoBlox','power user',NULL,'No',8),(83,'InCommon Certificate Manager','limited admin',NULL,'No',8),(84,'GUNAS (NAS5)','limited admin',NULL,'No',8),(85,'Finalsite (Blackboard Connect)','limited admin',NULL,'No',8),(86,'EVO server in Clerc Center','limited admin',NULL,'No',8),(87,'ESXi-VC - Dell R420 Server: VMware VCSA','limited admin',NULL,'No',8),(88,'DRUVA (Apex) Backup','limited admin',NULL,'No',8),(89,'Dell Avamar & DataDomain & Vault Access','limited admin',NULL,'No',8),(90,'DC05 DC15','super admin',NULL,'No',8),(91,'ClercCenter2 Web','limited admin',NULL,'No',8),(92,'Clerc Buffalo NAS Storage','limited admin',NULL,'No',8),(93,'CAPSW16','limited admin',NULL,'No',8),(94,'BisonVC VMs','limited admin',NULL,'No',8),(95,'BisonVC VMs','super admin',NULL,'No',8),(96,'BisonVC','limited admin',NULL,'No',8),(97,'Alertus Server - Alertus.gallaudet.edu','super admin',NULL,'No',8),(98,'AlertAware','super admin',NULL,'No',8),(99,'Adoble - T1/T2 Form & GTS.OFFICE','power user',NULL,'No',8),(100,'peoplesoft','limited admin',NULL,'No',9),(101,'lastpass','limited admin',NULL,'No',9),(102,'workday','limited admin',NULL,'No',9),(103,'oracle','super admin',NULL,'No',9),(104,'imiscloud','limited admin',NULL,'No',9),(105,'atlassian','limited admin',NULL,'No',9),(106,'WORKDAYW22','limited admin',NULL,'No',10),(107,'Workday','power user',NULL,'No',10),(108,'Workday','limited admin',NULL,'No',10),(109,'Teamworks','power user',NULL,'No',10),(110,'Slate','power user',NULL,'No',10),(111,'Perceptive Content client workstations','limited admin',NULL,'No',10),(112,'Perceptive Content','limited admin',NULL,'No',10),(113,'PeopleSoft OCI servers','power user',NULL,'No',10),(114,'Peoplesoft','limited admin',NULL,'No',10),(115,'Okta','limited admin',NULL,'No',10),(116,'LastPass','power user',NULL,'No',10),(117,'Hyland Community Perceptive Contents','power user',NULL,'No',10),(118,'GTSDEVW22','limited admin',NULL,'No',10),(119,'GTSCKPTW16','limited admin',NULL,'No',10),(120,'Google Sites','power user',NULL,'No',10),(121,'GAM','limited admin',NULL,'No',10),(122,'EISW22','limited admin',NULL,'No',10),(123,'EAB Box','power user',NULL,'No',10),(124,'TSP Converge Plan','power user',NULL,'No',10),(125,'Connect FinalSite','limited admin',NULL,'No',10),(126,'CDSW16','limited admin',NULL,'No',10),(127,'Blackboard Learn ','limited admin',NULL,'No',10),(128,'BBLEARNW16','limited admin',NULL,'No',10),(129,'AUTOTASKSW22','limited admin',NULL,'No',10),(130,'Adobe Sign','limited admin',NULL,'No',10),(131,'NAS as5hrpt','limited admin',NULL,'No',10),(132,'zoom','limited admin',NULL,'No',11),(133,'workday','basic',NULL,'No',11),(134,'qualtrics','power user',NULL,'No',11),(135,'power user','limited admin',NULL,'No',11),(136,'mygu - pathify','power user',NULL,'No',11),(137,'kaltura','limited admin',NULL,'No',11),(138,'jamf','limited admin',NULL,'No',11),(139,'impact','limited admin',NULL,'No',11),(140,'gts.office@','limited admin',NULL,'No',11),(141,'gam','limited admin',NULL,'No',11),(142,'echo360','limited admin',NULL,'No',11),(143,'ecampus - fast','limited admin',NULL,'No',11),(144,'blackboard testing','limited admin',NULL,'No',11),(145,'blackboard staging','limited admin',NULL,'No',11),(146,'blackboard prod','limited admin',NULL,'No',11),(147,'apple school manager','limited admin',NULL,'No',11),(148,'25live','limited admin',NULL,'No',11),(149,'25 live test','limited admin',NULL,'No',11),(150,'Zoom','super admin',NULL,'No',12),(151,'Watermark CES','limited admin',NULL,'No',12),(152,'Transact TSE - TSMain','limited admin',NULL,'No',12),(153,'Transact Reporting System','power user',NULL,'No',12),(154,'Transact Management Portal','limited admin',NULL,'No',12),(155,'Transact Cloud POS','limited admin',NULL,'No',12),(156,'Transact CashNet','limited admin',NULL,'No',12),(157,'Snowflake for Blackboard','power user',NULL,'No',12),(158,'SNMIDPRODW16','power user',NULL,'No',12),(159,'SNMIDDEVW16','power user',NULL,'No',12),(160,'ServiceNow','super admin',NULL,'No',12),(161,'Respondus Admin','limited admin',NULL,'No',12),(162,'PRINTERSW16','power user',NULL,'No',12),(163,'PaperCut','power user',NULL,'No',12),(164,'PaperCut','super admin',NULL,'No',12),(165,'Okta Dev','super admin',NULL,'No',12),(166,'Okta','super admin',NULL,'No',12),(167,'MyGU - Pathify','super admin',NULL,'No',12),(168,'MS 365 Admin','limited admin',NULL,'No',12),(169,'LaptopsAnytime','limited admin',NULL,'No',12),(170,'Kaltura','super admin',NULL,'No',12),(171,'Impact','super admin',NULL,'No',12),(172,'IADEVW22','power user',NULL,'No',12),(173,'GTSDEVW22','power user',NULL,'No',12),(174,'GTSCKPTW16','power user',NULL,'No',12),(175,'Google Workspace','super admin',NULL,'No',12),(176,'GAM','limited admin',NULL,'No',12),(177,'Echo360','super admin',NULL,'No',12),(178,'Blackboard Testing','super admin',NULL,'No',12),(179,'Blackboard Staging','super admin',NULL,'No',12),(180,'Blackboard Prod','super admin',NULL,'No',12),(181,'Blackboard Developer Portal','limited admin',NULL,'No',12),(182,'Azure','super admin',NULL,'No',12),(183,'Adobe Sign','super admin',NULL,'No',12),(184,'25Live','limited admin',NULL,'No',12),(200,'Palo Alto Firewall','super admin',NULL,'No',14),(201,'InfoBlox','super admin',NULL,'No',14),(202,'EduRoam configuration','limited admin',NULL,'No',14),(203,'Aruba ClearPass','super admin',NULL,'No',14),(204,'Zoom','limited admin',NULL,'No',15),(205,'textline','limited admin',NULL,'No',15),(206,'Splunk','super admin',NULL,'No',15),(207,'Sophos','limited admin',NULL,'No',15),(208,'Sectigo (InCommon)','super admin',NULL,'No',15),(209,'Palo Alto Firewall','super admin',NULL,'No',15),(210,'JAMF','super admin',NULL,'No',15),(211,'InfoBlox','super admin',NULL,'No',15),(212,'educause domain','super admin',NULL,'No',15),(213,'DRUVA (Apex) Backup','limited admin',NULL,'No',15),(214,'DC05 DC15','super admin',NULL,'No',15),(215,'BisonVC VMs','limited admin',NULL,'No',15),(216,'Aruba ClearPass','super admin',NULL,'No',15),(217,'Terra Dotta','limited admin',NULL,'No',16),(218,'Sophos','super admin',NULL,'No',16),(219,'Smartsheet','limited admin',NULL,'No',16),(220,'Respondus','basic',NULL,'No',16),(221,'Qualtrics','limited admin',NULL,'No',16),(222,'OpenAthens','limited admin',NULL,'No',16),(223,'Okta Dev','super admin',NULL,'No',16),(224,'Okta','super admin',NULL,'No',16),(225,'MyGU - Pathify','super admin',NULL,'No',16),(226,'Microsoft 365 TEST','super admin',NULL,'No',16),(227,'Matlab','limited admin',NULL,'No',16),(228,'ManageEngine ADManage Plus','power user',NULL,'No',16),(229,'Lucidchart','limited admin',NULL,'No',16),(230,'LinkedIn Learning','limited admin',NULL,'No',16),(231,'Kaltura','super admin',NULL,'No',16),(232,'KACE','super admin',NULL,'No',16),(233,'JAMF','super admin',NULL,'No',16),(234,'Interfolio','limited admin',NULL,'No',16),(235,'IBM SPSS Passport','basic',NULL,'No',16),(236,'Grammarly','limited admin',NULL,'No',16),(237,'Google Workspace TEST','super admin',NULL,'No',16),(238,'Google Workspace','super admin',NULL,'No',16),(239,'Google Play Developer','super admin',NULL,'No',16),(240,'GAM','limited admin',NULL,'No',16),(241,'Finalsite (Blackboard Connect)','super admin',NULL,'No',16),(242,'Echo360','limited admin',NULL,'No',16),(243,'Cayuse','limited admin',NULL,'No',16),(244,'Blackbaud','limited admin',NULL,'No',16),(245,'Azure','super admin',NULL,'No',16),(246,'Asana','limited admin',NULL,'No',16),(247,'Apporto','limited admin',NULL,'No',16),(248,'Apple School Manager','super admin',NULL,'No',16),(249,'Apple Developer / Enterprise Developer','super admin',NULL,'No',16),(250,'Adobe Admin Console','super admin',NULL,'No',16),(251,'Sophos','limited admin',NULL,'No',17),(252,'SmartBoard Enterprise License Portal','limited admin',NULL,'No',17),(253,'KillDisk License ','power user',NULL,'No',17),(254,'JAWS Admin','limited admin',NULL,'No',17),(255,'JAMF','limited admin',NULL,'No',17),(256,'InfoBlox','power user',NULL,'No',17),(257,'Genetec Security Desk','super admin',NULL,'No',17),(258,'FuelServe','super admin',NULL,'No',17),(259,'Apple School Manager','limited admin',NULL,'No',17),(260,'Apple Enterprise','power user',NULL,'No',17),(261,'Adobe Admin Console','limited admin',NULL,'No',17),(262,'AD','limited admin',NULL,'No',17),(263,'Workday','power user',NULL,'No',18),(264,'Transact Payments','limited admin',NULL,'No',18),(265,'Transact Back Office System','limited admin',NULL,'No',18),(266,'StarRez','limited admin',NULL,'No',18),(267,'Peoplesoft','limited admin',NULL,'No',18),(268,'Okta','basic',NULL,'No',18),(269,'GTSCKPTW16','limited admin',NULL,'No',18),(270,'EISW22','limited admin',NULL,'No',18),(271,'eCampus - Fast','limited admin',NULL,'No',18),(272,'JAMF','limited admin',NULL,'No',19),(273,'Bomgar','power user',NULL,'No',19),(274,'Apple School Manager','limited admin',NULL,'No',19),(275,'Apple Enterprise','power user',NULL,'No',19),(276,'25Live','power user',NULL,'No',19),(277,'Workday','super admin',NULL,'No',20),(278,'SmartFindExpress','super admin',NULL,'No',20),(279,'SEAS SFTP for Powerschool','power user',NULL,'No',20),(280,'psadmin on server pschdbw1212prod','power user',NULL,'No',20),(281,'Powerschool Dev','super admin',NULL,'No',20),(282,'Powerschool','super admin',NULL,'No',20),(283,'PickUp Patrol','super admin',NULL,'No',20),(284,'Peoplesoft','super admin',NULL,'No',20),(285,'Okta','basic',NULL,'No',20),(286,'gts.office@gallaudet.edu email account','power user',NULL,'No',20),(287,'GAM','power user',NULL,'No',20),(288,'Enrollment','super admin',NULL,'No',20),(289,'Blackboard Learn ','super admin',NULL,'No',20),(290,'Workday','power user',NULL,'No',21),(291,'Workday','limited admin',NULL,'No',21),(292,'StarRez','limited admin',NULL,'No',21),(293,'Slate','basic',NULL,'No',21),(294,'Powerschool','limited admin',NULL,'No',21),(295,'Peoplesoft','limited admin',NULL,'No',21),(296,'Okta','basic',NULL,'No',21),(297,'ServiceNow','limited admin',NULL,'No',22),(298,'Okta','basic',NULL,'No',22),(299,'VidCruiter','limited admin',NULL,'No',23),(300,'StarRez','limited admin',NULL,'No',23),(301,'Smartsheet','limited admin',NULL,'No',23),(302,'MyGU - Pathify','limited admin',NULL,'No',23),(303,'25Live','limited admin',NULL,'No',23),(304,'25 Live Test','limited admin',NULL,'No',23),(305,'NAS nas5','limited admin',NULL,'No',24),(306,'NAS css','limited admin',NULL,'No',24),(307,'Zoom','super admin',NULL,'No',25),(308,'Watermark CES','limited admin',NULL,'No',25),(309,'Kaltura','limited admin',NULL,'No',25),(310,'Impact','super admin',NULL,'No',25),(311,'Echo360','super admin',NULL,'No',25),(312,'eCampus - Fast','limited admin',NULL,'No',25),(313,'Blackboard Testing','super admin',NULL,'No',25),(314,'Blackboard Staging','limited admin',NULL,'No',25),(315,'Blackboard Prod','super admin',NULL,'No',25),(316,'25Live','super admin',NULL,'No',25),(317,'25 Live Test','limited admin',NULL,'No',25),(318,'Sharp Printer Dashboard','basic',NULL,'No',26),(319,'ServiceNow','power user',NULL,'No',26),(320,'Okta','power user',NULL,'No',26),(321,'Google Admin','power user',NULL,'No',26),(322,'GAM','basic',NULL,'No',26),(323,'cms.test & helpdesk.front','power user',NULL,'No',26),(324,'Azure','power user',NULL,'No',26),(325,'Zoom','limited admin',NULL,'No',27),(326,'Palo Alto Firewall','super admin',NULL,'No',27),(327,'Palo Alto CIE','super admin',NULL,'No',27),(328,'Aruba MM/MC/ClearPass/Airwave','super admin',NULL,'No',27),(329,'tambellini peerintelligent','basic',NULL,'No',28),(330,'smartsheet','limited admin',NULL,'No',28),(331,'ServiceNow','limited admin',NULL,'No',29),(332,'Okta','limited admin',NULL,'No',29),(333,'Google Admin','power user',NULL,'No',29),(334,'GAM','basic',NULL,'No',29),(335,'Transact TSE - TSMain','limited admin',NULL,'No',30),(336,'Transact Payments','limited admin',NULL,'No',30),(337,'Transact Back Office System','limited admin',NULL,'No',30),(338,'Sophos','power user',NULL,'No',30),(339,'PaperCut','limited admin',NULL,'No',30),(340,'KACE','super admin',NULL,'No',30),(341,'JAMF','limited admin',NULL,'No',30),(342,'InTune','limited admin',NULL,'No',30),(343,'Bomgar','super admin',NULL,'No',30),(344,'Bluefin manager','limited admin',NULL,'No',30),(345,'Apple School Manager','limited admin',NULL,'No',30),(346,'NAS CSS','limited admin',NULL,'No',30),(347,'NAS CSS ','limited admin',NULL,'No',30),(348,'Zoom','power user',NULL,'No',31),(349,'Zoom','super admin',NULL,'No',31),(350,'ServiceNow','power user',NULL,'No',31),(351,'Qualtrics','super admin',NULL,'No',31),(352,'Kaltura','super admin',NULL,'No',31),(353,'Blackboard Testing','super admin',NULL,'No',31),(354,'Blackboard Staging','super admin',NULL,'No',31),(355,'Blackboard Prod','super admin',NULL,'No',31),(356,'Adobe Sign','super admin',NULL,'No',31),(357,'25Live','super admin',NULL,'No',31),(358,'25 Live Test','super admin',NULL,'No',31),(359,'Workday','basic',NULL,'No',32),(360,'ServiceNow','basic',NULL,'No',32),(361,'NAS','basic',NULL,'No',32),(362,'Bisonterps Usked','basic',NULL,'No',32),(363,'ServiceNow','limited admin',NULL,'No',33),(364,'Mural','super admin',NULL,'No',33),(365,'FinalSite Connect','power user',NULL,'No',33),(366,'Alertus','limited admin',NULL,'No',33),(367,'Workday','power user',NULL,'No',34),(368,'Transact eAccount SFTP','limited admin',NULL,'No',34),(369,'StarRez','limited admin',NULL,'No',34),(370,'ServiceNow','power user',NULL,'No',34),(371,'Server: WORKDAYW22','limited admin',NULL,'No',34),(372,'Server: SNMIDW16 (ServiceNow)','limited admin',NULL,'No',34),(373,'Server: SNMIDDEVW16 (ServiceNow)','limited admin',NULL,'No',34),(374,'Server: SNMID2W16 (ServiceNow)','limited admin',NULL,'No',34),(375,'Server: PSCHDBW12PROD (PowerSchool)','limited admin',NULL,'No',34),(376,'Server: NEXUSW22','limited admin',NULL,'No',34),(377,'Server: IADEVW22','power user',NULL,'No',34),(378,'Server: GTSDEVW22','limited admin',NULL,'No',34),(379,'Server: GTSCKPTW16','limited admin',NULL,'No',34),(380,'Server: EISW22','limited admin',NULL,'No',34),(381,'Server: CDSW16','limited admin',NULL,'No',34),(382,'Server: BASTION','power user',NULL,'No',34),(383,'Server: AUTOTASKSW22','limited admin',NULL,'No',34),(384,'Powerschool','limited admin',NULL,'No',34),(385,'Peoplesoft','power user',NULL,'No',34),(386,'Okta','basic',NULL,'No',34),(387,'LastPass','power user',NULL,'No',34),(388,'GAM','power user',NULL,'No',34),(389,'Sophos','limited admin',NULL,'No',35),(390,'SmartBoard Enterprise License Portal','limited admin',NULL,'No',35),(391,'PRINTERSW16','limited admin',NULL,'No',35),(392,'PaperCut','limited admin',NULL,'No',35),(393,'Okta','power user',NULL,'No',35),(394,'ManageEngine ADManage Plus','power user',NULL,'No',35),(395,'LaptopsAnytime','limited admin',NULL,'No',35),(396,'KACE','limited admin',NULL,'No',35),(397,'JAMF','limited admin',NULL,'No',35),(398,'InfoBlox','power user',NULL,'No',35),(399,'IADEVW22','basic',NULL,'No',35),(400,'gts.office@','basic',NULL,'No',35),(401,'GAM','power user',NULL,'No',35),(402,'Azure','super admin',NULL,'No',35),(403,'Apple School Manager','limited admin',NULL,'No',35),(404,'Zabbix','limited admin',NULL,'No',36),(405,'Splunk','limited admin',NULL,'No',36),(406,'Palo Alto Firewall','limited admin',NULL,'No',36),(407,'Juniper Switches','limited admin',NULL,'No',36),(408,'InfoBlox','limited admin',NULL,'No',36),(409,'Aruba MOBILITY MASTER','limited admin',NULL,'No',36),(410,'Aruba ClearPass','limited admin',NULL,'No',36),(411,'Aruba Airwave','limited admin',NULL,'No',36),(412,'Sophos','basic',NULL,'No',37),(413,'PaperCut','limited admin',NULL,'No',37),(414,'KACE','limited admin',NULL,'No',37),(415,'JAMF','limited admin',NULL,'No',37),(416,'InfoBlox','basic',NULL,'No',37),(417,'Apple School Manager','limited admin',NULL,'No',37),(418,'Apple Enterprise','power user',NULL,'No',37),(419,'AD','limited admin',NULL,'No',37),(420,'NAS NAS5 CSS_Software','power user',NULL,'No',37),(421,'JAMF','limited admin',NULL,'No',38),(422,'Blackboard','limited admin',NULL,'No',38),(423,'Apple School Manager','limited admin',NULL,'No',38),(424,'Zabbix','power user',NULL,'No',39),(425,'Workday','power user',NULL,'No',39),(426,'ServiceNow','super admin',NULL,'No',39),(427,'Okta','power user',NULL,'No',39),(428,'MS 365','super admin',NULL,'No',39),(429,'ManageEngine ADManager Plus','power user',NULL,'No',39),(430,'JAMF','limited admin',NULL,'No',39),(431,'Extron GVE Server and GVE','super admin',NULL,'No',39),(432,'gts.office@','power user',NULL,'No',39),(433,'Google Workspace','super admin',NULL,'No',39),(434,'Blackboard Learn ','super admin',NULL,'No',39),(435,'25Live','super admin',NULL,'No',39),(439,'TrackAccess Web Server','super admin','jevans','Yes',45); /*!40000 ALTER TABLE `AccessRecords` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DepartmentRoles` -- DROP TABLE IF EXISTS `DepartmentRoles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `DepartmentRoles` ( `DepartmentRoleId` int NOT NULL AUTO_INCREMENT, `department` varchar(100) NOT NULL, `role` varchar(100) NOT NULL, PRIMARY KEY (`DepartmentRoleId`), UNIQUE KEY `department` (`department`,`role`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DepartmentRoles` -- LOCK TABLES `DepartmentRoles` WRITE; /*!40000 ALTER TABLE `DepartmentRoles` DISABLE KEYS */; INSERT INTO `DepartmentRoles` VALUES (4,'GTS','Administrative Assistant'),(5,'GTS','Applications Administrator'),(6,'GTS','Applications Manager'),(7,'GTS','Associate Data Administrator'),(8,'GTS','Associate eLearning Coordinator'),(9,'GTS','Associate Network Administrator'),(10,'GTS','Business Title Senior Project Manager'),(11,'GTS','Client Support Technician'),(12,'GTS','Data Engineer'),(13,'GTS','Director, Academic and End-User Technologies'),(14,'GTS','Director, Enterprise Information Systems'),(15,'GTS','Director, Information Technology Operations'),(16,'GTS','Director, Information Technology Projects'),(17,'GTS','eLearning Coordinator'),(18,'GTS','End-User Services Coordinator'),(1,'GTS','Information Security Officer'),(19,'GTS','Information Technology Manager'),(20,'GTS','Integration Manager'),(21,'GTS','Integrations Administrator'),(22,'GTS','IT Business Relationship Manage'),(23,'GTS','Multimedia Technician'),(24,'GTS','Network Administrator'),(25,'GTS','Network Architect'),(26,'GTS','Project Manager'),(27,'GTS','Senior Client Support Technician'),(28,'GTS','Senior eLearning Coordinator'),(29,'GTS','Senior Project Manager'),(30,'GTS','Senior Service Desk Specialist'),(31,'GTS','Senior Workday Manager'),(32,'GTS','Service Desk Specialist'),(2,'GTS','Web Developer'),(33,'GTS','Workday Finance Manager'),(34,'GTS','Workday Student Manager'),(3,'HR','Workday HR Admin'); /*!40000 ALTER TABLE `DepartmentRoles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `UserRoles` -- DROP TABLE IF EXISTS `UserRoles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `UserRoles` ( `UserRoleId` int NOT NULL AUTO_INCREMENT, `UserId` int NOT NULL, `DepartmentRoleId` int NOT NULL, PRIMARY KEY (`UserRoleId`), KEY `DepartmentRoleId` (`DepartmentRoleId`), KEY `UserRoles_ibfk_1` (`UserId`), CONSTRAINT `UserRoles_ibfk_1` FOREIGN KEY (`UserId`) REFERENCES `Users` (`UserId`) ON DELETE CASCADE, CONSTRAINT `UserRoles_ibfk_2` FOREIGN KEY (`DepartmentRoleId`) REFERENCES `DepartmentRoles` (`DepartmentRoleId`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `UserRoles` -- LOCK TABLES `UserRoles` WRITE; /*!40000 ALTER TABLE `UserRoles` DISABLE KEYS */; INSERT INTO `UserRoles` VALUES (4,3,28),(5,4,15),(6,6,23),(7,7,12),(8,8,7),(9,9,14),(10,10,31),(11,11,13),(12,12,5),(14,14,25),(15,15,19),(16,16,6),(17,17,11),(18,18,33),(19,19,18),(20,20,34),(21,21,34),(22,22,22),(23,23,26),(24,24,27),(25,25,17),(26,26,32),(27,27,24),(28,28,16),(29,29,30),(30,30,21),(31,31,29),(32,32,4),(33,33,10),(34,34,20),(35,35,5),(36,36,9),(37,37,11),(38,38,8),(39,39,5),(40,1,1),(45,1,2); /*!40000 ALTER TABLE `UserRoles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Users` -- DROP TABLE IF EXISTS `Users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `Users` ( `UserId` int NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, PRIMARY KEY (`UserId`) ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Users` -- LOCK TABLES `Users` WRITE; /*!40000 ALTER TABLE `Users` DISABLE KEYS */; INSERT INTO `Users` VALUES (1,'Jared Evans'),(3,'Adrian Rivera'),(4,'Bernadine Bertrand'),(6,'Brian Van Bavel'),(7,'Cheol Kim'),(8,'Corey Rosko'),(9,'Daryl Frelich'),(10,'Dennis Cregan'),(11,'Jacquelyn Lally'),(12,'James Bushor'),(14,'Jason Duerstock'),(15,'Jay Scotton'),(16,'Jeffrey Whitaker'),(17,'Jonas Scotton'),(18,'Joseph DeSiervi'),(19,'Joshua Scotton'),(20,'Julie Longson'),(21,'Kristinn Bjarnason'),(22,'Lori Koch (Functional Account)'),(23,'Maria Petrova-Margason'),(24,'Mathew Mills'),(25,'Matthew Terry'),(26,'Min Cho'),(27,'Pengwen Shao'),(28,'Rick Baker'),(29,'Rick Jones'),(30,'Seung Kim'),(31,'Shannon Augustine'),(32,'Shirley Hack-McCafferty'),(33,'Suzy McKenzie'),(34,'Thad Ferguson'),(35,'Wally Barretto'),(36,'Wayland Joyner'),(37,'Xian Huang'),(38,'Yasmeen Holguin'),(39,'Yoel Krigsman'); /*!40000 ALTER TABLE `Users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-06-22 1:21:20