Skip to content

v2.1.0

Choose a tag to compare

View all tags
@github-actions github-actions released this 29 Jul 11:10
· 1 commit to main since this release
v2.1.0
f15de1b
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Added

  • New combined uniqueness check script checkOnExternalSystemsAdAndSql.ps1 to validate values against both SQL blacklist and Active Directory in one flow, including cross-check support and keep-in-sync behavior.
  • New initial import utility importInitialDataFromCsv.ps1 for loading blacklist data from CSV, enriching entries via AD lookup, and auto-adding UserPrincipalName rows for mail-based input.
  • Added separated folders for CheckOnExternalSystems and SupportingFiles including a separated README.md.

Changed

  • Updated SQL table definition in createTableBlacklist.sql so employeeId allows NULL, aligning with import and lookup scenarios where no employee ID is available.
  • Added a filtered index on employeeId (IX_blacklist_2) to optimize lookups for populated employee IDs while keeping nullable records supported.
Assets 2
Loading