GCC Logo

CAS Dashboard

Run Date: 2024-04-26 05:56 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-25 10:00 PM 00:28 Success
SQL19APPS GAP Nightly Process 2024-04-25 06:30 AM 00:20 Success
HCM Local Process Stats (SQL19Apps, MS SQL)
Step Name   Employees   Date / Time  
HCM Download   66,912   2024-04-25 10:00 PM  
HCM Download   66,912   2024-04-25 09:00 PM  
HCM Download   66,912   2024-04-25 08:00 PM  
HCM Download   66,912   2024-04-25 07:00 PM  
HCM Download   66,912   2024-04-25 06:00 PM  

MatLab User Import (SQL19Apps, MS SQL)
Desc   Users   Date / Time  
Import Student User List from CDS. Semester: 4242   12,887   2024-04-25 06:00 AM  
Import Student User List from CDS. Semester: 4242   12,901   2024-04-24 06:00 AM  
Import Student User List from CDS. Semester: 4242   12,921   2024-04-23 06:00 AM  

RDS Data Load (SQL19Apps, MS SQL)

Last RDS Run Date/Time: 2024-04-26 03:42 AM

Name Previous Load Times
RDS Data Load 2024-04-25 03:43 AM  
RDS Data Load 2024-04-24 03:39 AM  
RDS Data Load 2024-04-23 03:45 AM  

Trac Export (SQL19Apps, MS SQL)

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

Step Name   Description   Qty  
Start   Process Start   0  
Tutor Trac   Tutor Trac - Class (Enrollments):   56,464  
Tutor Trac   Tutor Trac - Students:   15,964  
Fitness Trac   Cloud Fitness Trac - Class (Enrollments)   1,415  
Fitness Trac   Cloud Fitness Trac - OneMonth Class (Enrollments)   28  
Fitness Trac   Cloud Fitness Trac - Students   920  
Tutor Trac   Cloud Tutor Trac - Class (Enrollments)   75,259  
Tutor Trac   Cloud Tutor Trac - Students   18,099  
Fitness Trac   Cloud Fitness Trac - New Students Pictures To Export   1  
Tutor Trac   Cloud Tutor Trac - New Students Pictures To Export   63  
End   Process End   0  
Fitness Cloud Pic   Export - Started   0  
Fitness Cloud Pic   Pictures Exported   1  
Fitness Cloud Pic   Pictures Export Errors   0  
Fitness Cloud Pic   Export - Complete   0  
Tutor Cloud Pic   Export - Started   0  
Tutor Cloud Pic   Pictures Exported   5  
Tutor Cloud Pic   Pictures Export Errors (this run)   58  
Tutor Cloud Pic   Export - Complete   0  

Process Stop Time: 2024-04-26 05:05:06 AM

Omega Nightly Process Stats (SQL19Apps, MS SQL)

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

Step Name   Description   Qty  
Student   Process Starting...   0  
Student   1) Active Student Flags Reset   12,907  
Student   2) Students Updated & Flagged as Active   12,900  
Student   3) New Active Students Inserted   13  
Student   4) Other Students (PACC & NAU) Updated & Flagged as Active   5  
Student   5) New Other Students (PACC & NAU) Inserted   0  
Student   Process Complete   0  
Faculty   Process Starting...   0  
Faculty   1) Active Faculty Flags Reset   763  
Faculty   2) Faculty Updated & Flagged as Active   757  
Faculty   3) New Active Faculty Inserted   0  
Faculty   Process Complete   0  
Employee   Process Starting...   0  
Employee   1) Active Employees & Other Employee Flags Reset   2,052  
Employee   2) Employees Updated & Flagged as Active   1,741  
Employee   3) New Active Employees Inserted   0  
Employee   4) Other Employees (POI & CWR) Updated & Flagged as Active   310  
Employee   5) New Other Employees (POI & CWR) Inserted   1  
Employee   Process Complete   0  

Process Stop Time: 2024-04-26 04:45:03 AM

Veterans Nightly Process Stats (SQL19Apps, MS SQL)

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

Step Name   Description   Qty  
1   Process Starting...   0  
2   Calculate Current Semester: 4242   1  
3   Add New Students to Student Table   0  
3.1   Add New Students, Without Service Indicator, to Student Table   0  
4   Update Student Information from CDS   957  
5   Insert New Student Semester Rows from CDS   0  
5.1   Insert New Student, Without Service Indicators, Semester Rows from CDS   0  
6   Update Matching Student Semester Rows from CDS   494  
7   Insert New Student Enrollments from CDS   9  
8   Update Matching Student Enrollments from CDS   2,440  
9   Update Class Notes Table from CDS   20,605  
10   Update Student Program Information from RDS   969  
11   Process Complete.   0  

Process Stop Time: 2024-04-25 06:45:43 AM

Kiosk Usage Stats (SQL19Apps, MS SQL)
Kiosk   Users   Date / Time  
Automotive Kiosk   3   2024-04-24  
Automotive Kiosk   2   2024-04-10  
Automotive Kiosk   2   2024-03-06  
Automotive Kiosk   1   2024-02-01  
 
North Kiosk   4   2024-04-25  
North Kiosk   4   2024-04-24  
North Kiosk   1   2024-04-23  
North Kiosk   4   2024-04-22  
North Kiosk   5   2024-04-18  
North Kiosk   4   2024-04-17  
North Kiosk   2   2024-04-16  
North Kiosk   2   2024-04-12  
North Kiosk   2   2024-04-11  
North Kiosk   7   2024-04-10  
North Kiosk   3   2024-04-09  
North Kiosk   5   2024-04-08  
North Kiosk   7   2024-04-04  
North Kiosk   14   2024-04-03  
North Kiosk   4   2024-04-02  
North Kiosk   14   2024-04-01  
North Kiosk   4   2024-03-29  
North Kiosk   2   2024-03-28  
North Kiosk   21   2024-03-27  
North Kiosk   1   2024-03-26  
North Kiosk   1   2024-03-25  
North Kiosk   1   2024-03-22  
North Kiosk   2   2024-03-21  
North Kiosk   5   2024-03-19  
North Kiosk   18   2024-03-18  
North Kiosk   5   2024-03-08  
North Kiosk   12   2024-03-06  
North Kiosk   2   2024-03-05  
North Kiosk   1   2024-03-04  
North Kiosk   4   2024-03-01  
 
DRS Kiosk   1   2024-04-24  
DRS Kiosk   13   2024-04-22  
DRS Kiosk   9   2024-04-16  
DRS Kiosk   1   2024-04-15  
DRS Kiosk   11   2024-04-12  
DRS Kiosk   3   2024-04-11  
 

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

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


End Time   Run Type   Status Message  
2024-04-25 09:02 PM CDS RT5 Update Reached ExitTime, normal nightly shutdown
2024-04-25 09:00 PM CDS RT5 Update
2024-04-25 08:57 PM CDS RT5 Update
2024-04-25 08:55 PM CDS RT5 Update
2024-04-25 08:53 PM CDS RT5 Update
MySQL Backups
Last Backup Date/Time of MySQL Database Servers

Server Description Date / Time
WEBDEV MySQL Backup A 2024-04-25 11:00 PM
FaxCore Backup (FaxCore, Scheduled Task)
FaxCore   Date / Time   Disk  
FaxCore Backup A   2024-04-25 06:00 AM   E:  81.14% Free  

JSON Export Process (GCC Dyno)
JSON File   Qty   Date / Time  
GCC Emp Dyno Load   2,067   2024-04-26 05:35 AM  

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

Process Start Time: 2024-04-25 07:20:01 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,242  
3-2   Current Semester Courses with Assigned Licenses   371  
3-2   Current Semester Course/Group Enrollments   5,886  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   1  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   2  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   2  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   5  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   5  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   5  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   5  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   10  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   2 - Users Successfully Removed:   3  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Remove Inactive Users   0 - Start.    0  
Remove Inactive Users   1 - Removing Users...    0  
Remove Inactive Users   2 - Users Successfully Removed:   3  
Remove Inactive Users   3 - Users Remove Errors:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Removed:   0  
Remove Inactive Users   3 - Errors - Users Not Removed:   1  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Removed:   0  
Remove Inactive Users   3 - Errors - Users Not Removed:   1  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   1  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   1  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   0  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   0  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   0  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   0  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   0  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   0  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   0  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   1  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   1  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   1  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   5  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Updating User Licenses...    0  
Remove Inactive Users   2 - Users Successfully Updated:   7  
Remove Inactive Users   3 - Errors - Users Not Updated:   0  
Remove Inactive Users   4 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - From License: SalesPackageConfig.e842ab4a-0dc6-4e41-8ffa-4033e6dfee41   0  
Update User Licenses   1 - To License: SalesPackageConfig.4e99e355-da68-446a-913c-a1fd364fe448   0  
Update User Licenses   2 - Updating User Licenses...    0  
Remove Inactive Users   3 - Users Successfully Updated:   3  
Remove Inactive Users   4 - Errors - Users Not Updated:   0  
Remove Inactive Users   5 - Complete.   0  
Update User Licenses   0 - Start.    0  
Update User Licenses   1 - Update Max = 3   0  
Update User Licenses   1 - From License: SalesPackageConfig.e842ab4a-0dc6-4e41-8ffa-4033e6dfee41   0  
Update User Licenses   1 - To License: SalesPackageConfig.4e99e355-da68-446a-913c-a1fd364fe448   0  
Update User Licenses   2 - Updating User Licenses...    0  
Remove Inactive Users   3 - Users Successfully Updated:   3  
Remove Inactive Users   4 - Errors - Users Not Updated:   0  
Remove Inactive Users   5 - Complete.   0  

Process Stop Time: 2024-04-25 06:23:17 PM

Pages:  Main   |   Page 1   |   Page 2   |   Help