MS SQL Server Database Logging

In order to enable MSSQL Server database logging into the MSSQL Log 1). Open an elevated Poershell prompt 2). Run the query 1Invoke-Sqlcmd -Query "EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’AuditLevel’, REG_DWORD, …

Rapid7 Setup

1). Created Policy 12345678910111213141516{     "Version": "2012-10-17",     "Statement": [         {             "Effect": "Allow",           …

Get AD User Information

1PS C:\>get-aduser tor -Properties * Can also list all the servers on the domain 1PS C:\>Get-adcomputer -filter * -properties * | Select-object DNSHostName,whenCreated,Name,Created,Modified,LastLogonDate,Enabled,isDeleted | export-csv c:\servers.csv