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


LCCActiveDirectorySearcher link The lccActiveDirectorySearcher program was created to allow searching of objects in Active Directory. Currently, its main style is displaying members in group(s).
LCCADChangeUsersPasswords link lccADChangeUsersPasswords was created to change User (one to many) Passwords in Active Directory
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.
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.
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.
LCCAuditData link The lccAuditData program was created to Audit Data and provide reports on its findings.
LCCAuditDataStructure link The LccAuditDataStructure program was created to audit the structure of data. The purpose for the original creation was to have an audit process to help in replication issues between two data sources (SQL, other) when the structure of the data in the source location may conflict with the data formats in the destination location.
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
LCCAuditFolders link The lccAuditFolders (aka lccService1) is a Command Line program that traverses folders (aka directories) and produces a report on the folders/files found.
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.

LCCBrowserRouter link Program renamed to lccToolBook.
LCCByRequestTplDis link The lccByRequestTplDis application was created to create a matching Template (tpl) and Distribution (dis) file for use in byRequest.
LCCByteViewer link The lccByteViewer is a Windows program that displays bytes in a file.

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.
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
LCCColumnsAuditor link LCCColumnsAuditor is a Command Line program created to audit columns of data against two or more files.
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.
LCCCommander link The lccCommander application 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 The lccCompareCombine was developed to Compare the records in one file (the master) to another file (compare to) on column matches between the two.
LCCCreateLocalUser link The lccCreateLocalUser program was created to allow scripting of creating local account(s) and adding them to local group(s).
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.

LCCDataFileModifier link Modify data files.
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 The lccDesktopAlert was created to 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).
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 The lccDriveCleaner console application was created to remove Folders/Files from a computer.
LCCDrivesAudit link Audit drives on machines using PowerShell.

LCCElevatedActions link Allow users to launch applications under alternate security context
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
LCCEncryptLogicValues link Creates encrypted values for use in Logic Files for many LCC programs.
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.

LCCFileCompare link The lccFileCompare application compares two files using each of their bytes.
LCCFileJumper link The lccFileJumper application jumps to a specified byte in a file and retrieves the specified amount of bytes at that position.
LCCFileMover link Move/Copy/Delete files by age
LCCFilterList link Filter a list of records by those 'with' and 'without' values.
LCCFindDuplicates link A Windows program to help find duplicate records, using specific columns, but, returning the entire records.
LCCFindReplace link Command Line program created to find and possibly replace content in files.
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.
LCCFolderFixer link The lccFolderFixer was developed to 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.

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.

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

LCCIISReporter link The lccIISReporter web (.NET) application was created to allow authorized users to add, edit and delete virtual URLs from an IIS (Internet Information Services) server.
LCCIISReporterBackEnd link Manual querying of IIS virtuals and Respond to Requests from the paired lccIISReporter program.
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.

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).

LCCLetsTalk link Discussion forum
LCCLoginController link lccLoginController is a Command Line+Windows program created to log and control log-ins to computers.
LCCLogMeOut link Log-off a user.

LCCManageVirtuals link The lccManageVirtuals.ps1 script was created to 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 The lccMySQLConsole is a Command Line program that performs actions against a MySQL server/database.

LCCNotifier link Notifications to users/cell phones/etc..

LCCObjectChecker link Check objects (folders/files) for existence, modified date
LCCOffsitePortalAuthentication link Authentication for pre-authorized sites
LCCOnlineBrowser link Control web surfing/interface
LCCOSTicketManager link Create User accounts in OS Ticket.

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.
LCCPasswordChanger link Change the password on a machine(s).
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 The lccPortalPass program was created to 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 The lccProfilesCleaner console 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.

LCCReadFilter link Read a file for multiple criteria, with skip-criteria, pre-get headers
LCCRecordsVerifier link The lccRecordsVerifier is a 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 The lccReplaceCharInFile is a Command Line program that replaces characters (char) from a file.
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 The lccReturnDate is a 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.

LCCSaveWebContent link Saving of web content, supporting three types of authentication: Keys, User Ids, and Groups Ids
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
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 The lccShibboleth was developed to 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 The lccSingleId code is 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 The lccSleeper program was created to force a delay in a process/between commands, etc..
LCCSOAPer link The lccSOAPer is a command line program and was developed to access Web Services using both Get and Post.
LCC Spelled 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)).
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.

LCCTCPScanner link Scan IPs for open ports
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.

LCCUpdatedOn link Check when a file was last modified and display date/time
LCCURLVerify link Console and Web Service versions. Designed to verify URLs

LCCViewFileInfo link A Windows program created to view local/remote file information.

LCC WA YRQ Encoder/Decoder link Encode/Decode/Auto Build WA YRQ Values
LCCWAYRQTranslator link Tools available for decoding/encoding the WA YRQ codes
LCCWebToSQL link Single Sign-On to multiple SQL Sources
LCCWirelessSettingsScripts link Query, Remove, Install Wireless Profile
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.