Distributable Tools (aka LCC Programs available for download/install/use, see disclaimer)
INDEX

NAME Link(s) DESCRIPTION

LCC-A
LCCADChangeUsersPasswords link lccADChangeUsersPasswords was created to change User (one to many) Passwords in Active Directory
LCCADConvertTo link Find an attribute on Active Directory (AD) objects, and return one to many attributes.
LCCADCredentialVerification link The lccADCredentialVerification windows application was created to verify a set of Active Directory credentials against one to many LDAP Servers
LCCADFS link The LCCADFS Process Documentation Site was created to detail how to set-up ADFS, create SQL Claim Values, test Claim Values returned.
LCCADGroupMaintain link A Command Line program created to maintain an Active Directory (AD) group.
LCCADPAuth link The LCCADPAuth DLL was created to tie Walla Walla's ADP (Advisory Data Portal) program into Active Directory (AD) and to allow an external/flexible translation between Username and Staff IDentification number (SID).
LCCADPEmailLookup link The LCCADPEmailLookup DLL was created to tie Walla Walla's ADP (Advisory Data Portal) program into flat file or Active Directory (AD) email address lookup.
LCC ADP Pro Mod link This document describes the LCC Modification to ADP Pro for enhancing the Student Search Columns.
LCCADPortal link lccADPortal was created to provide a request/response process for Active Directory (AD) tasks.
LCCADSearch link A Command Line program created to allow searching through Active Directory (AD) across many fields, allowing wildcards.
LCCADSearchGUI link A Windows program created to allow searching through Activie Directory (AD) across many fields, allowing wildcards.
LCCAEWEmailOnFlags link lccAEWEmailOnFlags was created as an add-on to Walla Walla's AEW program. The add-on handles tracking/emailing alerts to students/staff, providing reports, etc.
LCCAsyncCommands link Command Line program created to run one to many commands against one to many targets in a different thread for each, i.e. executing them all at the same time.
LCCAuditFileInfo link Command line program created to audit a file's meta data.
LCCAuditFiles link The lccAuditFiles application was created to parse (audit) file(s) in a folder for set(s) of information and create either TXT (tab delimited), CSV (command delimited) or HTM (web page) format
LCCAuditInfo link A command line program to audit data against Rule Set(s). A common usage is validating addresses/contact information. In fact, the program has a built-in module for verifying City, State, Zip.
LCCAuditMachines link The purpose of the script is to audit hardware/software statistics on a list of machines and present a tab delimited report.
LCCAuditPasswords link lccAuditPasswords (Command Line program) was created to audit passwords against a set of dynamic requirements and Google Rating.
LCCAuditPasswordsGUI link lccAuditPasswordsGUI (Windows program) was created to audit passwords against a set of dynamic requirements and Google Rating.
LCCAuditPasswordsLib link lccAuditPasswordsLib (Library 'dll' program) was created to allows other programn to audit passwords against a set of dynamic requirements and Google Rating.
LCCAuditPasswordsWeb link lccAuditPasswordsWeb (Website program) was created to audit passwords against a set of dynamic requirements and Google Rating.
LCCAwardReporter link lccAwardReporter was developed to help in identifying what awards students qualify for. Awards can be anything from Certificates to Degrees, or other.

LCC-B
LCCBatchRunList link Command line application that takes a list of lines with columns and uses those as parameters against a list of commands.
LCCBDRPDashboard link Windows program to gather information on the status/settings of the Baseline DataLink Replication Package (BDRP).
LCCByRequestTplDis link Create a matching Template (tpl) and Distribution (dis) file for use in byRequest.
LCCByteViewer link Windows program that displays bytes in a file.

LCC-C
LCCCanvasCourseAdvisor link Auto query/enroll students in Canvas courses.
LCCCAPTCHA link Created to create a challenge/response mechanism for use in web pages to verify the submissions are done by humans, not machines/bots.
LCCCertChecker link Retrieve SSL/TLS certificate(s) from URL(s) and produce a report with the information about them.
LCCCharacterFilter link Reads a file, and reports any rows that have columns containing characters not valid.
LCCCheckDateTimeDrift link Command Line program created to check the Date/Time values of multiple records and report how much difference (Drift) exists between them.
LCCClassScheduleAvailabilities link Auto-query the state website for up-to-the-moment class inforamtion on multiple classes
LCCClearingHouseRecords link Import, filter, export Clearing House records
LCCClearingHouseRecordsDegreeVerify link Import, filter, remove duplicates, export Clearing House Degree Verify records
LCCColumnsCruncher link LCCColumnsCruncher was created to load one to many files (Data Sets), and allow multiple types of actions against/between the data, and finally produce one to many output files.
LCCCombineFiles link Topology of the program: take one to many source files, and produce one to many target files. Pull in and write out any delimited type files. Pull from any column in a source file, and place into any column in a target file.
LCCCombineRows link Combines rows/columns from one file into another.
LCCCommander link Uses a text based logic file to perform commands/tasks. It was built to run in a Command window and can be embedded into batch files.
LCCCompareCombine link Compare the records in one file (the master) to another file (compare to) on column matches between the two.
LCCCopyToClipboardGUI link Windows program created to allow creating/copying of data quickly. It also allows for a Secure method, which allows for text to be created/copied without being seen. See the Secure Method section.
LCCCreateIPsFromSubnet link Command line program to generate a list of IPs from Subnet/CIDR format.
LCCCtcLinkAlmaUploader link A Command Line program created to take ctcLink dataLink data (rows) and produce a data file (XML) for Alma, containing both Staff and Students.
LCCCtcLinkParseSecurityMatrix link A command line program to parse through ctcLink Security Matrix results.
LCCCtcLinkQueryPicker link A Windows program created to quickly find Queries in ctcLink PeopleSoft by their Descriptions.
LCCCtcLinkQueryPickerByField link A Windows program created to quickly find Queries in ctcLink PeopleSoft by their Fields.
LCCCtcLinkRolePicker link A Windows program created to quickly find Security Roles for users in ctcLink PeopleSoft by their Descriptions.

LCC-D
LCCDataColumnWidths link Command line application that parses a delimited file and returns the largest width value in each column, along with the value.
LCCDataFileModifier link Modify data files.
LCCDataLinkPackageLogReader link A Windows program created to read/filter a dataLink Package Log.
LCCDateDiff link Show the difference between two Dates/Times.
LCCDelayAction link Scheduling of tasks on a remote/local computer by adding it to the Task Scheduler on a desired machine, with a delay of the desired minutes.
LCCDesktopAlert link Show Desktop Alerts when certain events happen. This program can be called from the processes you want to present an alert.
LCCDFSMessenger link Windows program developed to query/filter Distributed File System (DFS) locations
LCCDFSSearcer link Windows program developed to automate/standardize messages sent about Distributed File System (DFS) locations (though it could be used for any network path).
LCCDiskWatcher link A command line program that can monitor disk activity across one to many machines/disks at the same time.
LCCDownloadFiles link This allows supplying of files (especially large ones) to recipients without the need for a File Transfer (FTP) program. Since the URLs can contain 'https', this also allows 'secure' downloading of the file(s) content.
LCCDriveCleaner link Command line application was created to remove Folders/Files from a computer.
LCCDrivesAudit link Audit drives on machines using PowerShell.

LCC-E
LCCElevatedActions link Allow users to launch applications under alternate security context
LCCElevatedActionsOnline link A command line, web, windows program created to provide a way for IT staff to allow end users to run commands/programs/etc, with an option for elevated rights.
LCCEmailer link Command Line program created to send emails, multiple capabilities, including mail merging, attachments, etc.
LCCEmailVerification link Verify e-mails addresses
LCCEMAS link Embed Multi-Animations inside a single web page
LCCEncryptDecryptFile link Command line program developed to encrypt/decrypt a file.
LCCEncryptDecryptFileGUI link Windows program developed to encrypt/decrypt a file.
LCCEncryptLogicValues link Creates encrypted values for use in Logic Files for many LCC programs.
LCCEndOfLineChanger link Change the End Of Line character(s).
LCCEnumerateGroups link Enumerate through Active Directory groups and report on the members.
LCCEventsManager link lccEventsManager was developed to allow authorized persons to add/edit/maintain events and web visitors to register/unregister for events.
LCCExchangePowerShellAutomation link Automated PowerShell tasks
LCCEZProxy link A Project Plan documentation for installing/configuration EZProxy for use with local, LDAP and Shibboleth authentications.

LCC-F
LCCFERFireworksData link Handle the complexity in generating data for the vendor's site's needs.
LCCFileChecker link Check files and report stats/information on those files.
LCCFileCompare link Compares two files using each of their bytes.
LCCFileCounter link Count files and report stats on those files.
LCCFileExportLines link Command line application that exports Line Sets to another file.
LCCFileJumper link Jumps to a specified byte in a file and retrieves the specified amount of bytes at that position.
LCCFileLineColumnsToFormattedLines link Load delimited lines from source file(s) and produce a report file that has formatted lines using any of the columns from the source lines.
LCCFileLineCounter link Count lines in file(s) and report stats.
LCCFileLinesSplicer link Take the delimited lines from one file and create a new file.
LCCFileMover link Move/Copy/Delete files by age
LCCFilePathModifier link Modify a file's path, including: move/copy, change path/filename by different flags
LCCFiler link Command Line program created to copy/delete, modify rights file(s) from one to many computers each in its own thread
LCCFileRowsTurnOnOff link Allows a user to turn the lines of a file on/off.
LCCFilterList link Filter a list of records by those 'with' and 'without' values.
LCCFindColumnDifferences link Command Line program that checks the rows in a tab delimited file and marks which columns are different after the 2nd row of data.
LCCFindDuplicates link A Windows program to help find duplicate records, using specific columns, but, returning the entire records.
LCCFindPrintSpoolers link Command line application that searches machines/ips for open print spoolers.
LCCFindReplace link A command line program to find and possibly replace content in files. Can find parts of lines or multiple lines, and can replace parts of lines or multiple lines.
LCCFlexAct link Launch commands/actions against list of objects (computers, users, etc..)
LCCFolderExplorer link Windows program developed to allow exploring of folders with both local or alternate credentials. You can explore one to many local/network locations simultaneously.
LCCFolderExplorerCL link Command line program developed to create a report of all files in one to many paths.
LCCFolderFixer link Perform actions on folders.
LCCFormPostFile link Is a Command Line program created to send a single file to a web API (URL).
LCCFTP link Upload/Download files, directory listings
LCCFTPFileEditor link The program was created to Retrieve/Edit/Send FTP Files.

LCC-G
LCCGoogleAPI link lccGoogleAPI is a Command Line program created to performs tasks through Google.
LCCGUIDDecoder link Change an Active Directory export (LDF files produced by LDIFDE) attribute for OBJECTSID to a readable format.

LCC-H
LCCHorizonToAlma link Project Plan for Horizon to Alma library database migration.

LCC-I
LCCInformaCastMachineLocationUpdate link Automatically update the InformaCast Machine Locations in the description field.
LCCInvestigateRecords link lccInvestigateRecords was created to allow dynamic querying (investigation) of records in a flat file through a website.

LCC-J
LCCJSON link lccJSON code was created to allow parsing of JSON data without having to predefine/Data Contract values.
LCCJSONReader link lccJSONReader is a Command Line program created to showcase the lccJSON code (class).

LCC-L
LCCLauncherGUI link Windows program was developed to launch one to many processes through a hidden window.
LCCLoginController link lccLoginController is a Command Line+Windows program created to log and control log-ins to computers.
LCCLogMeOut link Log-off a user.

LCC-M
LCCMachineAccountModifier link Command line program was developed to create/modify one to many user accounts on one to many local/remote machine(s).
LCCManageVirtuals link Script that can Create, Modify and Delete virtuals (URLs) on an IIS 7 server.
LCCMapGPOGuidToName link Map Group Policy GUIds to their name
LCCMouseMover link lccMouseMover is a Command Line program created to move the mouse to the center of the screen across all monitors.
LCCMySQLConsole link Command Line program that performs actions against a MySQL server/database.

LCC-N

LCC-O
LCCObjectChecker link Check objects (folders/files) for existence, modified date
LCCOffsitePortalAuthentication link Authentication for pre-authorized sites
LCCOpenPorts link Report on all open ports on a machine
LCCOriginalNewIdTranslator link Recreate a file by translating one id (column value) into another.
LCCOSTicketManager link Create User accounts in OS Ticket.

LCC-P
LCCParseActiveDirectory link lccPAD was created to Query and Modify Active Directory (AD) objects.
LCCParseColumns link Find duplicates or combine records from a file.
LCCParseEventLogs link Parse through the event log(s) of system(s).
LCCParseExchangeMailboxes link (lccPEM) The lccPEM was developed to parse through Exchange mailboxes, both on-site and O365 editions.
LCCParseOracleRecordDescribe link a Windows program created to take Oracle schema information from a Record (table) and produce SQL (other) commands/lines.
LCCParseTaskScheduler link A Command Line program created to query/report back on the Tasks running on machines.
LCCPasswordGenerator link Help user generate passwords that meet certain requirements.
LCCPCModifier link Modify PC (i.e. registry, files, network cards, etc..)
LCCPersonalizedEnvironmentTasks link Designed to automated the creation/customization of 'workareas' for one to many users.
LCCPinger link A Command Line program created to allow pinging one to many systems.
LCCPoll link Create polls.
LCCPOP link PC pulling process (machines query at set times for actions)
LCCPortalPass link Allow pre-authentication, using Active Directory, of users through a website, then route them to another portal as an authorized user.
LCCPowerShell Color Chart link Colors Chart
LCCPowerShellGUI link Run/share PowerShell scripts through Windows GUI
LCCProcessList link Show what processes are running
LCCProfilesCleaner link Command line application was created to remove Profiles from a Windows (7+) machine.
LCCPullOutSplitColumns link Command Line program created to read a file with records containing columns split by a character. This program will then pull out the desired columns from each record and place in a results file.

LCC-Q
LCCQueryReporter link Command line, web, windows program created to provide a way to allow end users/batch files/etc. to run queries and produce reports.

LCC-R
LCCRandomNumberGenerator link The purpose is to generate a set number of random numbers between a start and end range. With the option to format the output, i.e. add other information around the number.
LCCReadFilter link Read a file for multiple criteria, with skip-criteria, pre-get headers
LCCRecordsVerifier link Windows program that verifies the values supplied in fix width column records
LCCRegistryChanger link Query/modify the registry
LCCRemoveDuplicates link Command Line program to read a file and produce another file with all duplicates removed.
LCCReplaceCharInFile link Command Line program that replaces characters (char) from a file.
LCCRequestMaker link A Windows program created to allow submitting of Requests.
LCCReqeustMakerBackEnd link Process requests submitted by users using the lccRequestMaker.
LCCResourceTracker link Web program created to provide a way to allow tracking (access) to resources. Tracking can email one to many recipients, and/or record to a database.
LCCRestAPICaller link Command Line to push/pull calls to an online API
LCCRetrieveSecuredFile link Supply a secured file to a web user. It can supply the file as a downloadable attachment, or direct/display (i.e. in a browser).
LCCReturnDate link Command Line program created to return a date, able to subtract/add days, in many formats, and to the Console Window, and/or a System Environment variable, and/or a File.
LCCROAR link Created to ask for information (like credentials, or other), verify that information against one to many validation lists, then return records from one to many return lists.
LCCRowcolumnsWrapper link A windows program created to wrap rows (records) with large amounts of columns into a more vertical friendly format.

LCC-S
LCCSaveWebContent link Saving of web content, supporting three types of authentication: Keys, User Ids, and Groups Ids
LCCScanForFilters link A command line program to scan directories/files/compressed files for filter(s). For example, a current "log4j" vulnerability created the need to find where that logging tool was being used.
LCCScanMe link Command Line program to allow manual or 'scanned in' records into a text file.
LCCScheduleMaper link The scheduleMaper is mainly a JavaScript file that produces a day/time matrix within a web page.
LCCScreenSaver link Screen Saver with network capable XML logic
LCCServerCore link lcc Server Core was created to provide tools for use with Windows Server 2012 R2+ Core. Including lccDEMenu
LCCServerSharesReport link PowerShell script to retrieve the shares on servers, including paths, share permissions and NTFS permissions
LCCServerStats link PowerShell script created to retrieve Stats from one to many servers (or workstations) and produce reports
LCCServiceInstaller link List, install and uninstall services.
LCCServiceWrapper link Windows Service program that can launch multiple Command Line/Batch Files/Programs when the computer restarts or the service is stopped/paused/restarted
LCCSFTP link Upload/Download files, directory listings (encrypted)
LCCShibboleth link Describes the information, requirements, installation/configuration steps and parts for installation Shibboleth.
LCCShortcutChanger link Delete and/or replace shortcut(s)
LCCShowMyInfo link Gather client/user information
LCCSIDFraudAudit link Audit a list of Marked Fraudulent SIDs against a list of state SIDS and produce a report of those that match, and those that do not.
LCCSingleId link Code for creating the lccSingleId.dll to be called/used by other programs. Actions: check new Log-In Id, provide Results, Record new Log-In Ids.
LCCSleeper link Force a delay in a process/between commands, etc..
LCCSOAPer link Command line program and was developed to access Web Services using both Get and Post.
LCCSorter link Command line program to sort one to many columns in a file.
LCCSpelled Out link Show spelled out version of text with special characters/numbers.
LCCSQLAsyncTableReplication link A database, set of SQL (TSQL) scripts (Stored Procedure) that enables replicating of tables from Remote or Local sources. The tables replicate asynchronously and do not require SSIS.
LCCSQLBinaryPhotosViewer link Retrieve, view, save photos stored in a SQL binary column (aka blob, aka varbinary(MAX)).
LCCSQLDashboard link Windows program to gather information on SQL queries.
LCCSQLDataExport link Export information from a SQL server, modify data on-the-fly.
LCCSQLSnippets link Provide snippets about SQL projects, usually SQL scripts.
LCCSwitchMACRecords link Parse the 'show mac address-table' output, combine a list of Trunk/Building names and create a formatted tab delimited file.

LCC-T
LCCTailer link Windows program developed to look at the end of files in a continuous update.
LCCTextReformatter link Windows program for reformatting text.
LCCTCPScanner link Scans one to many IPs, and one to many ports, producing closed/open port reports, and allowing IP translations.
LCCTerminal link SSH manual/automatic connections, with manual/automatic commands.
LCCToolBook link lccToolBook is a Windows program created to allow launching of programs and optional parameters.

LCC-U
LCCUpdatedOn link Check when a file was last modified and display date/time
LCCURLVerify link Command line and Web Service versions. Designed to verify URLs

LCC-V
LCCViewFileInfo link A Windows program created to view local/remote file information.
LCCViewFileInfoCL link A command line program created to view local/remote file information.

LCC-W
LCC WA YRQ Encoder/Decoder link Encode/Decode/Auto Build WA YRQ Values
LCCWAYRQTranslator link Tools available for decoding/encoding the WA YRQ codes
LCCWebServerSoftwareReader link A console application that contacts machine names and/or IPs and discovers if they are running a web server and if so, what version/type.
LCCWebToSQL link Single Sign-On to multiple SQL Sources
LCCWirelessSettingsScripts link Query, Remove, Install Wireless Profile

LCC-Z
LCCZipper link Zip a directory, single file, or extract a zip file
Disclaimer
The programs, scripts and documentation are provided AS IS without warranty of any kind. Lower Columbia College further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the programs, scripts and documentation remains with you. In no event shall Lower Columbia College, its authors, or anyone else involved in the creation, production, or delivery of the programs, scripts or documentation be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the programs, scripts or documentation, even if Lower Columbia College has been advised of the possibility of such damages.