Skip to content
/ EtQScripts-SQL Public

Various scripts that have been helpful in supporting the ETQ Reliance Quality Management System.

2 stars 1 fork Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

8to5/EtQScripts-SQL

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

33 Commits
All Logins (Dev, Test, Prod).sql
All Logins (Dev, Test, Prod).sql
 
 
Auto-void orphaned Action Items (GET_ORPHANED_ACTION_ITEMS).SQL
Auto-void orphaned Action Items (GET_ORPHANED_ACTION_ITEMS).SQL
 
 
Auto-void orphaned Action Items.py
Auto-void orphaned Action Items.py
 
 
Bulk Archive.py
Bulk Archive.py
 
 
Create Action Item and Reassign.py
Create Action Item and Reassign.py
 
 
Create Doc only if selected Location matches User Profile.py
Create Doc only if selected Location matches User Profile.py
 
 
Days Difference in Business Days.py
Days Difference in Business Days.py
 
 
Disable User Profiles for S2S.sql
Disable User Profiles for S2S.sql
 
 
Document Attachment Paths.sql
Document Attachment Paths.sql
 
 
Duplicate Users and Groups.sql
Duplicate Users and Groups.sql
 
 
Fields with Lookup SQL.sql
Fields with Lookup SQL.sql
 
 
Fields with OI Synch Enabled.sql
Fields with OI Synch Enabled.sql
 
 
Groups with No Members.sql
Groups with No Members.sql
 
 
Import User Profile (SQL generator).sql
Import User Profile (SQL generator).sql
 
 
Inactive Members in Groups.sql
Inactive Members in Groups.sql
 
 
Keyword Reference Search.sql
Keyword Reference Search.sql
 
 
MKLs by Application Form Fields.sql
MKLs by Application Form Fields.sql
 
 
MNL Members.sql
MNL Members.sql
 
 
MNL member search by User.sql
MNL member search by User.sql
 
 
Move Subform Record Up or Down.py
Move Subform Record Up or Down.py
 
 
README.md
README.md
 
 
Release Documents Locked by System.py
Release Documents Locked by System.py
 
 
Section Editable for specific Location in Draft phase.py
Section Editable for specific Location in Draft phase.py
 
 
Table Row Counts.sql
Table Row Counts.sql
 
 
Untitled Sections.sql
Untitled Sections.sql
 
 
User Profile Lookup.sql
User Profile Lookup.sql
 
 
User Profile Time Zone and Locale.sql
User Profile Time Zone and Locale.sql
 
 
Workflow Phase Edit and Read Sections.sql
Workflow Phase Edit and Read Sections.sql
 
 
Workflow Phases.sql
Workflow Phases.sql
 
 
thisPhase.route().py
thisPhase.route().py
 
 

Repository files navigation

Various scripts that have been helpful in supporting the ETQ Reliance Quality Management System.

SQL scripts were written for Microsoft SQL Server, but can be easily adapted to other database platforms.

About

Various scripts that have been helpful in supporting the ETQ Reliance Quality Management System.

Topics

python automation sql script scripting mssql sqlserver py tsql qms mssql-database reliance etq etq-reliance quality-management-system etqscript

Resources

Readme
Activity

Stars

2 stars

Watchers

1 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published

Languages