{"id":4367,"date":"2022-11-13T19:08:42","date_gmt":"2022-11-14T03:08:42","guid":{"rendered":"https:\/\/tungle.ca\/?p=4367"},"modified":"2023-03-01T18:39:12","modified_gmt":"2023-03-02T02:39:12","slug":"count-the-number-of-failed-root-logins-by-ip-address-via-powershell","status":"publish","type":"post","link":"https:\/\/tungle.ca\/?p=4367","title":{"rendered":"Count the number of failed root login in Linux server by IP address via PowerShell"},"content":{"rendered":"\n

Using (e)grep, cut, awk, sed to extract specific information in Linux logs is one of the daily tasks of Linux system administrator. <\/p>\n\n\n\n

grep \"Failed\" '\/var\/log\/auth.log' | grep -v root | awk -F 'from ' '{ print $2} ' | awk '{print $1}' | sort | uniq -c | sort -nr | while read COUNT IP<\/code><\/pre>\n\n\n\n
However, in this article, I want to demonstrate how to use PowerShell to extract the number of failed root login in Linux server.<\/p>\n\n\n\n
Download the \/var\/log\/auth.log example file via github (https:\/\/github.com\/elastic\/examples\/blob\/master\/Machine%20Learning\/Security%20Analytics%20Recipes\/suspicious_login_activity\/data\/auth.log)<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Save it under Downloads directory. Querying the content of the file via Get-content command.<\/p>\n\n\n\n
$inputpath = get-content \"\/Users\/tungle\/Downloads\/auth.log\"<\/code><\/pre>\n\n\n\n
Now, I want to explain how to use PowerShell to extract specific information in the log file. If the number of failed attempts is greater than the LIMIT, then it will display count number, IP address, and Geolocation of the IP address.<\/p>\n\n\n\n
Firstly, we need to know a format of the IP address via PowerShell regex.<\/p>\n\n\n\n
$regex = \"\\b\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\b\"<\/code><\/pre>\n\n\n\n
Filtering all lines are matched the regex format of the IP address in auth.log file.<\/p>\n\n\n\n
$output = $inputpath | Select-String -Pattern $regex -AllMatches<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Selecting all lines are matched “failed password for root”.<\/p>\n\n\n\n
$output = $inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" <\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Following the MS link, I use matches method to populate the returned MatchCollection object (https:\/\/learn.microsoft.com\/en-us\/dotnet\/api\/system.text.regularexpressions.regex.matches?view=netframework-4.7.2). % is an alias of foreach-object.<\/p>\n\n\n\n
$output = $inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" | % { $_.Matches }<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, getting IP addresses of the failed login in the log file. <\/p>\n\n\n\n
$output = $inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" | % { $_.Matches } | % { $_.Value }<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Group the IP address property together.<\/p>\n\n\n\n
$output = $inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" | % { $_.Matches } | % { $_.Value } `\n| Group-Object<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Check if the number of failed attempts is greater than the LIMIT (>10 failed login attempts).<\/p>\n\n\n\n
$output = $inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" | % { $_.Matches } | % { $_.Value } `\n                    | Group-Object |  Select-Object Name, Count | Where-Object { $_.Count -gt 10 }<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Using the PS script block below to detect attempted IP address, count, and country. Basically, the script will check all lines in the $output variable above and output the top IP address and county attempts.<\/p>\n\n\n\n
ForEach($line in $output){\n    $IP = $line.Name\n    #$IP\n    # Query Geolocaltion of the IP addresses via free API\n    $result = Invoke-RestMethod -Method Get -Uri http:\/\/ip-api.com\/json\/$IP\n    # Create a PSCustomObject to save Count, IP address and Country attempts \n    $myObject = [PSCustomObject]@{\n                Count = $line.Count\n                \"IP Address\" = $line.Name\n                #IP = $result.query\n                Country = $result.Country\n}\n$myObject\n}<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Below is a PS script block to check the failed root attempts.<\/p>\n\n\n\n
$inputpath = get-content \"\/Users\/tungle\/Downloads\/auth.log\"\n#$regex = \u2018\\b\\d{1,3}.\\d{1,3}.\\d{1,3}.\\d{1,3}\\b\u2019\n$regex = \"\\b\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\b\"\n#$inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\"\n#$inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" | % { $_.Matches }\n$output = $inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" | % { $_.Matches } | % { $_.Value } `\n                    | Group-Object |  Select-Object Name, Count | Where-Object { $_.Count -gt 10 }\nForEach($line in $output){\n    $IP = $line.Name\n    #$IP\n    $result = Invoke-RestMethod -Method Get -Uri http:\/\/ip-api.com\/json\/$IP\n    # Create a PSCustomObject to save Count, IP address and Country attempts \n    $myObject = [PSCustomObject]@{\n                Count = $line.Count\n                \"IP Address\" = $line.Name\n                #IP = $result.query\n                Country = $result.Country\n}\n$myObject\n}<\/code><\/pre>\n\n\n\n
This is a PS script (show-attacker.PS1) to run in a cloud-based Linux virtual machine.<\/p>\n\n\n\n
$inputpath = get-content \"\/var\/log\/auth.log\"\n#$inputpath = get-content \"\/Users\/tungle\/Downloads\/auth.log.txt\"\n$regex = \"\\b\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\b\"\n$output = $inputpath | Select-String -Pattern $regex -AllMatches | Select-String \"failed password for root\" | % { $_.Matches } | % { $_.Value } `\n| Group-Object |  Select-Object Name, Count | Where-Object {$_.Count -gt 20}\nForEach($line in $output){\n        $IP = $line.Name\n        $result = Invoke-RestMethod -Method Get -Uri http:\/\/ip-api.com\/json\/$IP\n        # Sleep a second \n        Start-Sleep 1\n    \t#Write-Output $_count\n        $myObject = [PSCustomObject]@{\n        \tCount = $line.Count\n\t\t\"IPAddress\" = $line.Name\n            \t#IP = $result.query\n            \tCountry = $result.Country\n}\n    $myObject\n}<\/code><\/pre>\n\n\n\n
Run the script in Linux server.<\/p>\n\n\n\n
.\/show-attacker.PS1 | Sort-Object Count -Descending<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Finally, we can extract specific information of authentication logs in Linux server by using PowerShell.<\/p>\n","protected":false},"excerpt":{"rendered":"
Using (e)grep, cut, awk, sed to extract specific information in Linux logs is one of the daily tasks of Linux system administrator. However, in this article, I want to demonstrate how to use PowerShell to extract the number of failed root login in Linux server. Download the \/var\/log\/auth.log example file via github (https:\/\/github.com\/elastic\/examples\/blob\/master\/Machine%20Learning\/Security%20Analytics%20Recipes\/suspicious_login_activity\/data\/auth.log) Save it […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,9,7,11],"tags":[8,10,12,13],"class_list":["post-4367","post","type-post","status-publish","format-standard","hentry","category-linux","category-microsoft","category-powershell","category-security","tag-linux","tag-microsoft","tag-powershell","tag-security"],"_links":{"self":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts\/4367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4367"}],"version-history":[{"count":18,"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts\/4367\/revisions"}],"predecessor-version":[{"id":4411,"href":"https:\/\/tungle.ca\/index.php?rest_route=\/wp\/v2\/posts\/4367\/revisions\/4411"}],"wp:attachment":[{"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tungle.ca\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}