Commit Graph

  • fba8559049 fix: change back variable names for nthash and lmhash Marshall Hallenbeck 2023-03-09 23:04:59 -05:00
  • 04ce05892d fix(zerologon): catch error and alert user if epm.hept_map fails due to host not being DC Marshall Hallenbeck 2023-03-09 23:04:28 -05:00
  • 137a7c7283 fix(cmedb): add func.lower() calls back into certain columns that need it Marshall Hallenbeck 2023-03-09 22:53:22 -05:00
  • a955a7d7ab fix(cmedb): fix LIKE queries to properly work Marshall Hallenbeck 2023-03-09 22:48:33 -05:00
  • 160efc6980 update formatting, some variable names, and other Pythonic things for winrm Marshall Hallenbeck 2023-03-09 19:58:36 -05:00
  • e9b353d645 feat(dbs): add help string and confirmation for all database clear_database functions Marshall Hallenbeck 2023-03-09 19:25:18 -05:00
  • e6022139aa fix: try/except updating the database on spoolers and zerologon modules Marshall Hallenbeck 2023-03-09 18:38:42 -05:00
  • cbd312eb21 feat(petitpotam): update petitpotam module to update database if host is vulnerable. Also removed redundant function and cleaned up formatting Marshall Hallenbeck 2023-03-09 18:37:11 -05:00
  • 673afbafb5 feat(zerologon): update zerologon module to update database if host is vulnerable Marshall Hallenbeck 2023-03-09 18:33:58 -05:00
  • f6bd41f94f feat(spooler): update spooler module to update database if spooler service is enabled Marshall Hallenbeck 2023-03-09 18:31:32 -05:00
  • 47d68dce7b feat(cmedb): update table when printing specific host to include additional info Marshall Hallenbeck 2023-03-09 18:28:35 -05:00
  • ec58fb7f7e fix(db): fix update columns reference for Upsert queries to properly update columns Marshall Hallenbeck 2023-03-09 18:27:43 -05:00
  • b368b2ca85 fix(mssqldb): properly apply filters for sqlalchemy queries Marshall Hallenbeck 2023-03-09 17:39:51 -05:00
  • cffec370a4 feat(smbdb): add feature to allow search on r/w/rw shares Marshall Hallenbeck 2023-03-09 17:39:07 -05:00
  • e4c21e242d fix(smbdb): properly apply filters for sqlalchemy queries Marshall Hallenbeck 2023-03-09 17:38:37 -05:00
  • 7a43382c7b chore: remove unnecessary commented code Marshall Hallenbeck 2023-03-09 17:00:51 -05:00
  • 3996d21175 feat(ssh|winrmdb): update ssh and winrm database files to use proper sqlalchemy methods Marshall Hallenbeck 2023-03-09 16:55:53 -05:00
  • 3491499845 feat(ftpdb): update ftp database file to use new sqlalchemy connection and query methods Marshall Hallenbeck 2023-03-09 16:54:31 -05:00
  • c55e2563a3 fix(rdp|ldapdb): fix table name reflection Marshall Hallenbeck 2023-03-09 16:50:32 -05:00
  • fa073b4449 fix(rdp|ldapdb): fix table name reflection Marshall Hallenbeck 2023-03-09 16:50:32 -05:00
  • 222c6442ec feat(rdpdb): update rdp databse file to use new sqlalchemy connection and query methods Marshall Hallenbeck 2023-03-09 16:49:13 -05:00
  • 9c48638733 chore(mssqldb): remove unnecessary import and add SAWarning ignore Marshall Hallenbeck 2023-03-08 13:12:01 -05:00
  • 99d041684a feat(mssqldb): update clear_database to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:11:01 -05:00
  • 16f0fe5b35 feat(mssqldb): update get_computers to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:10:32 -05:00
  • e170f839f7 feat(mssqldb): update is_computer_valid to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:09:59 -05:00
  • c38117a8dd feat(mssqldb): update get_credentials to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:09:35 -05:00
  • 608304d5d5 feat(mssqldb): update is_credential_valid to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:09:03 -05:00
  • 75fcf0e666 feat(mssqldb): update remove_admin_relations to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:08:42 -05:00
  • 051a7c0e4b feat(mssqldb): update get_admin_relations to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:08:16 -05:00
  • 3b86e8c1fa feat(mssqldb): update add_admin_user to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:07:50 -05:00
  • 38854a59e4 feat(mssqldb): update remove_credentials to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:06:55 -05:00
  • f9ff7cef7a feat(mssqldb): update add_credential to be the same as smbdb Marshall Hallenbeck 2023-03-08 13:06:28 -05:00
  • 0eb20ff3a2 feat(mssqldb): update add_computer to proper sqlalchemny syntax Marshall Hallenbeck 2023-03-08 13:04:29 -05:00
  • 515209a4e0 feat(smbdb): only update hosts if they have changed to improve SQL write time Marshall Hallenbeck 2023-03-08 13:03:48 -05:00
  • 3143b56060 logging(smbdb): update log string to better specify which add_computer() is being called Marshall Hallenbeck 2023-03-08 12:57:55 -05:00
  • beaab6034e format(smbdb): change order of functions to match other database classes Marshall Hallenbeck 2023-03-08 12:55:22 -05:00
  • c211f53cbd feat(smbdb): add help_creds Marshall Hallenbeck 2023-03-08 01:43:55 -05:00
  • d588b523e1 chore: remove old commented code Marshall Hallenbeck 2023-03-08 01:26:02 -05:00
  • 121b25d243 feat(smbdb): update remaining functions to proper sqlalchemy syntax Marshall Hallenbeck 2023-03-08 01:24:44 -05:00
  • 1d33c58059 refactor(smbdb): change all add_user references to add_credential and refactor some if statements Marshall Hallenbeck 2023-03-08 00:27:14 -05:00
  • b25b74d473 chore: set asyncio logging level to CRITICAL to prevent unnecessary logging messages in debug mode Marshall Hallenbeck 2023-03-08 00:25:58 -05:00
  • 97eb27bdfa fix(smbdb): update Upsert technique Marshall Hallenbeck 2023-03-07 23:01:36 -05:00
  • 1bb0a476e0 feat(smbdb): work on fixing group sqlalchemy queries Marshall Hallenbeck 2023-03-07 21:27:24 -05:00
  • 92c8d5bf20 update variable name Marshall Hallenbeck 2023-03-06 19:19:13 -05:00
  • 1e5fec0b75 fix(smbdb): fix clear_database query Marshall Hallenbeck 2023-03-06 19:02:03 -05:00
  • 17eda1767d fix(smbdb): reference inserted row id properly Marshall Hallenbeck 2023-03-06 18:51:01 -05:00
  • fa6c20f76a feat(cmedb): add help string to hosts command Marshall Hallenbeck 2023-03-06 18:45:44 -05:00
  • 6056602a3d feat(cmedb): add help string to groups command Marshall Hallenbeck 2023-03-06 18:42:34 -05:00
  • 0d8824eaf4 feat(cmedb): add help string to shares command Marshall Hallenbeck 2023-03-06 18:41:33 -05:00
  • 0a58d95218 feat(cmedb): add print_help function to assist in printing help commands Marshall Hallenbeck 2023-03-06 18:41:05 -05:00
  • 526ec5373e fix comment Marshall Hallenbeck 2023-03-06 18:29:08 -05:00
  • fde187e26e fix(cmedb): update get_computers to always return a list Marshall Hallenbeck 2023-03-06 18:26:58 -05:00
  • 3dd1daf87b feat(cmedb): update get_users to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 18:07:07 -05:00
  • c8c8bbd531 feat(cmedb): update get_user to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 18:05:18 -05:00
  • dc1a038474 feat(cmedb): update get_computers to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 18:04:26 -05:00
  • ffb277fe55 feat(cmedb): update is_computer_valid to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:58:05 -05:00
  • dfd18456a0 feat(cmedb): update get_groups to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:57:20 -05:00
  • 6c27da82ef feat(cmedb): update is_group_valid to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:55:21 -05:00
  • 5ca05031a9 feat(cmedb): update get_users_with_share_access to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:53:19 -05:00
  • 042f67ee73 feat(cmedb): update add_share to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:49:21 -05:00
  • dc417119b6 fix(cmedb): fix db column reference Marshall Hallenbeck 2023-03-06 17:45:59 -05:00
  • f1c8c0704b feat(cmedb): update get_group_relations to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:42:45 -05:00
  • 7bfd048078 feat(cmedb): update get_admin_relations to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:41:35 -05:00
  • 2f4b4c0a23 feat(cmedb): update get_credentials to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:40:21 -05:00
  • d4fe0c18d8 feat(cmedb): update is_user_valid to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:38:42 -05:00
  • 22606143da fix(smbdb): update result query syntax Marshall Hallenbeck 2023-03-06 17:37:13 -05:00
  • 2348fc7e13 fix(SAwarnings): add warning ignore for SAWarnings Marshall Hallenbeck 2023-03-06 17:32:16 -05:00
  • 29e673c885 feat(cmedb): update is_credentials_valid to use proper sqlalchemy syntax Marshall Hallenbeck 2023-03-06 17:29:50 -05:00
  • 6d24d0906a chore(cmedb): update formatting Marshall Hallenbeck 2023-03-06 17:26:18 -05:00
  • d0e83c4b97 feat(cmedb): update cmedb.py to use proper sqlalchemy connection Marshall Hallenbeck 2023-03-06 17:22:33 -05:00
  • 9b2b1656b7 feat(smbdb): completely revamp get_shares_by_access function (needs testing) Marshall Hallenbeck 2023-03-06 11:58:43 -05:00
  • 75619809ad feat(cmedb): update get_shares sqlalchemy syntax Marshall Hallenbeck 2023-03-06 11:44:02 -05:00
  • 780ca00e32 feat(cmedb): update is_share_valid sqlalchemy syntax Marshall Hallenbeck 2023-03-06 11:35:55 -05:00
  • 8463829b5b feat(database): working on making database operations more async, reducing write concurrency issues, and fixing sqlalchemy query formats Marshall Hallenbeck 2023-03-05 21:12:13 -05:00
  • 06a82744cd WIP: improve computer add and update logic to reduce writes Marshall Hallenbeck 2023-03-05 19:14:37 -05:00
  • bdc887ccae feat(mssqldb): update get_computers to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:19:49 -05:00
  • 4b5dfbb025 feat(mssqldb): update is_computer_valid to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:19:23 -05:00
  • da1e788f23 feat(mssqldb): update get_credentials to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:18:54 -05:00
  • b70cdc58e1 feat(mssqldb): update is_credential_valid to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:18:26 -05:00
  • 9e1b8fbe88 feat(mssqldb): update remove_admin_relations to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:18:01 -05:00
  • 70346c9c8a feat(mssqldb): update get_admin_relations to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:17:35 -05:00
  • 28b16538ed feat(mssqldb): update add_admin_user to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:17:08 -05:00
  • 54035df8b1 feat(mssqldb): update remove_credentials to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:13:11 -05:00
  • 876dd9d331 feat(mssqldb): update add_credential to use sqlalchemy Marshall Hallenbeck 2023-03-04 22:12:10 -05:00
  • a8f23e9ed9 chore(mssqldb): fix formatting Marshall Hallenbeck 2023-03-04 22:08:16 -05:00
  • f33d254c83 feat(mssqldb): update add_computer to use sqlalchemny Marshall Hallenbeck 2023-03-04 22:08:04 -05:00
  • b44b05a0fa small formatting fix in db_navigator Marshall Hallenbeck 2023-03-04 21:48:19 -05:00
  • b4c189a2a7 small formatting fix Marshall Hallenbeck 2023-03-04 21:45:11 -05:00
  • 108629bc02 feat(smbdb): update additional user functions to use sqlalchemy Marshall Hallenbeck 2023-03-04 21:41:43 -05:00
  • 484ab65aad feat(smbdb): update is_user_valid to use sqlalchemy Marshall Hallenbeck 2023-03-04 21:24:51 -05:00
  • a66b3a0a72 feat(smbdb): update is_credential_local to use sqlalchemy Marshall Hallenbeck 2023-03-04 21:21:15 -05:00
  • 7401f48f82 feat(cmedb): update creds remove command to use sqlalchemy Marshall Hallenbeck 2023-03-04 21:17:45 -05:00
  • a634530128 feat(cmedb): add database column for count of members of groups from AD, and the last queried time of it. Additionally transition to sqlalchemy Marshall Hallenbeck 2023-03-04 21:08:48 -05:00
  • 9094e2e80f fix(smbdb): fix extraneous commit call that was causing errors due to timing Marshall Hallenbeck 2023-03-04 19:35:35 -05:00
  • 5debcb793e chore(smbdb): fix formatting Marshall Hallenbeck 2023-03-04 19:10:18 -05:00
  • 1aec4ea798 refactor(cmedb): pass dbengine object instead of session object Marshall Hallenbeck 2023-03-04 19:00:20 -05:00
  • 165142b543 fix(smb-database): remove redundant commit calls Marshall Hallenbeck 2023-03-04 17:50:59 -05:00
  • 13a554ea20 chore: remove debug print statements Marshall Hallenbeck 2023-03-04 17:05:32 -05:00
  • 5c6fb5799c chore: remove commented code Marshall Hallenbeck 2023-03-04 17:04:28 -05:00
  • 0212f7bd28 feat(cmedb): update sql queries for groups command Marshall Hallenbeck 2023-03-04 17:03:00 -05:00