From 2ee3e7af7b9133da946dff2643505a3d7013b3c0 Mon Sep 17 00:00:00 2001
From: Christian Cleberg <hello@cleberg.net>
Date: Sat, 28 Dec 2024 11:30:03 -0600
Subject: restructure directories

---
 db_passwords/sql/get_data.sql | 30 ------------------------------
 1 file changed, 30 deletions(-)
 delete mode 100644 db_passwords/sql/get_data.sql

(limited to 'db_passwords/sql/get_data.sql')

diff --git a/db_passwords/sql/get_data.sql b/db_passwords/sql/get_data.sql
deleted file mode 100644
index b5bef36..0000000
--- a/db_passwords/sql/get_data.sql
+++ /dev/null
@@ -1,30 +0,0 @@
-/*
-References:
-1. https://learn.microsoft.com/en-us/sql/relational-databases/security/password-policy
-2. https://learn.microsoft.com/en-us/sql/t-sql/functions/loginproperty-transact-sql
-*/
-
-SELECT
-    name,
-    principal_id,
-    sid,
-    type,
-    type_desc,
-    is_disabled,
-    create_date,
-    modify_date,
-    default_database_name,
-    default_language_name,
-    credential_id,
-    is_policy_checked,
-    is_expiration_checked,
-    password_hash,
-    LOGINPROPERTY(name, 'IsMustChange') AS IsMustChange,
-    LOGINPROPERTY(name, 'IsLocked') AS IsLocked,
-    LOGINPROPERTY(name, 'LockoutTime') AS LockoutTime,
-    LOGINPROPERTY(name, 'PasswordLastSetTime') AS PasswordLastSetTime,
-    LOGINPROPERTY(name, 'IsExpired') AS IsExpired,
-    LOGINPROPERTY(name, 'BadPasswordCount') AS BadPasswordCount,
-    LOGINPROPERTY(name, 'BadPasswordTime') AS BadPasswordTime,
-    LOGINPROPERTY(name, 'HistoryLength') AS HistoryLength
-FROM sys.sql_logins;
-- 
cgit v1.2.3-70-g09d2

