GCC Logo

CAS Dashboard

Run Date: 2024-04-19 10:07 AM

Web Server Check (WAMP)
Server   URL   Status  
WebApp https://webapp.gccaz.edu/cas/server_test.php Up
WebDev https://webdev.gccaz.edu/cas/server_test.php Up
PrivApp https://privapp.gccaz.edu/cas/server_test.php Up
SQL Agent Tasks (MS SQL)
Server Task Date / Time Duration Result
SQL19APPS HCM Copy Data to Local Table 2024-04-19 10:00 AM 00:27 Success
SQL19APPS GAP Nightly Process 2024-04-19 06:30 AM 00:18 Success
HCM Local Process Stats (SQL19Apps, MS SQL)
Step Name   Employees   Date / Time  
HCM Download   66,860   2024-04-19 10:00 AM  
HCM Download   66,859   2024-04-19 09:00 AM  
HCM Download   66,856   2024-04-19 08:00 AM  
HCM Download   66,856   2024-04-19 07:00 AM  
HCM Download   66,856   2024-04-19 06:00 AM  

MatLab User Import (SQL19Apps, MS SQL)
Desc   Users   Date / Time  
Import Student User List from CDS. Semester: 4242   12,922   2024-04-19 06:00 AM  
Import Student User List from CDS. Semester: 4242   12,929   2024-04-18 06:00 AM  
Import Student User List from CDS. Semester: 4242   12,943   2024-04-17 06:00 AM  

RDS Data Load (SQL19Apps, MS SQL)

Last RDS Run Date/Time: 2024-04-18 03:48 AM

Name Previous Load Times
RDS Data Load 2024-04-18 03:48 AM  
RDS Data Load 2024-04-17 03:49 AM  
RDS Data Load 2024-04-16 03:53 AM  

Trac Export (SQL19Apps, MS SQL)          (details)

Process Start Time: 2024-04-19 04:55:00 AM

Process Stop Time: 2024-04-19 05:05:02 AM

Omega Nightly Process Stats (SQL19Apps, MS SQL)          (details)

Process Start Time: 2024-04-19 04:45:00 AM

Process Stop Time: 2024-04-19 04:45:02 AM

Veterans Nightly Process Stats (SQL19Apps, MS SQL)          (details)

Process Start Time: 2024-04-19 06:45:00 AM

Process Stop Time: 2024-04-19 06:45:58 AM

Kiosk Usage Stats (SQL19Apps, MS SQL)          (details)
Kiosk   Users   Date / Time  
Automotive Kiosk   2   2024-04-10  
Automotive Kiosk   2   2024-03-06  
Automotive Kiosk   1   2024-02-01  
 
North Kiosk   5   2024-04-18  
North Kiosk   4   2024-04-17  
North Kiosk   2   2024-04-16  
 
DRS Kiosk   9   2024-04-16  
DRS Kiosk   1   2024-04-15  
DRS Kiosk   11   2024-04-12  
 

Backup Jobs - SQL Agent (MS SQL)
Server Task Date / Time Duration Result
CDS Backup All Databases 2024-04-19 02:00 AM 00:09 Success
SQL14 Backup Most Databases 2024-04-19 01:00 AM 01:28 Success
SQL14 Crestron Fusion Backup 2024-04-19 03:00 AM 05:40 Success
SQL16 Backup All Databases 2024-04-19 01:00 AM 00:29 Success
SQL19UTIL Backup All Databases 2024-04-19 05:00 AM 00:03 Success
SQL19DEV Backup All Databases 2024-04-19 01:00 AM 00:30 Success
SQL19APPS Backup All Databases 2024-04-19 12:30 AM 00:22 Success
SQL19APPS Backup Users 2024-04-14 02:00 AM 00:04 Success
CDS Data Load (CDS, MS SQL)

Last CDS Run Date/Time: 2024-04-18 06:06 AM   -   Success


End Time   Run Type   Status Message  
2024-04-19 10:00 AM CDS Full Load No new CDS overnight data since last full load
2024-04-19 09:50 AM CDS Full Load No new CDS overnight data since last full load
2024-04-19 09:40 AM CDS Full Load No new CDS overnight data since last full load
2024-04-19 09:30 AM CDS Full Load No new CDS overnight data since last full load
2024-04-19 09:20 AM CDS Full Load No new CDS overnight data since last full load
MySQL Backups
Last Backup Date/Time of MySQL Database Servers

Server Description Date / Time
WEBDEV MySQL Backup B 2024-04-18 10:00 PM
FaxCore Backup (FaxCore, Scheduled Task)
FaxCore   Date / Time   Disk  
FaxCore Backup A   2024-04-19 06:00 AM   E:  81.16% Free  

JSON Export Process (GCC Dyno)
JSON File   Qty   Date / Time  
GCC Emp Dyno Load   2,061   2024-04-19 05:36 AM  

Rosetta Stone Nightly Process Stats
(PrivApp, Scheduled Task, PHP, SQL19Apps)          (details)

Process Start Time: 2024-04-19 07:20:02 AM

Step Name   Description   Qty  
1-0   SQL - Process Start   0  
1-1   SQL - Calc & Get Current Semester: 4242   0  
1-2   SQL - Courses Added from CDS   0  
1-3   SQL - Student Enrollments Added from CDS   0  
1-4   SQL - Update Student Enrollment Status from CDS   1  
1-5   SQL - Student Person Rows Added from CDS   0  
1-6   SQL - Instructor Enrollments Added from CDS   0  
1-7   SQL - Instructor Person Data Added from CDS   0  
1-8   SQL - Process Complete   0  
2-0   PHP Start...   0  
2-0   Current Semester: 4242   0  
2-2   RS - Courses Added To Rosetta Stone   0  
2-5   RS - People Added To Rosetta Stone   0  
2-5.1   RS - Fix User Account Errors   0  
2-5.2   RS - Accounts with Errors   0  
2-5.2   RS - Accounts Fixed   0  
2-6   RS - Enrollments Added to Rosetta Stone Groups   0  
2-9   PHP Complete   0  
3-0   Stats   0  
3-1   Total Users with Assigned Licenses   10,248  
3-2   Current Semester Courses with Assigned Licenses   371  
3-2   Current Semester Course/Group Enrollments   5,886  

Process Stop Time: 2024-04-19 07:20:21 AM