Foreach IPv4 address where name is like 10.53.* get user logged on

Khalifa96 0
Viewed 58

I'm trying to find out who is in the office and who's not by checking the IPv4 Address range. Anyone with an IP address starting with 10.57.xx.xx Is in the office and anyone with IP 10.53.xx.xx is working on a VPN. I would like to export their domain usernames from the list of people in the office.

How can I do this using PowerShell?

This is what I have (unfinished)

$Machines = (Get-ADComputer -Filter * -SearchBase 'OU=Laptops,OU=Win10Modern,OU=LN,OU=Workstations,DC=cooley,DC=com').Name
$result = foreach ($Machine in $Machines) 
{ 
    if (Test-Connection -ComputerName $Machine -Count 1 -Quiet) {
        if($machine.ipaddress -like "10.57*")
        {
            Get-WmiObject –ComputerName $Machine –Class Win32_ComputerSystem | Select-Object Username
        }
    }
}
powershell
1 Answers
#Query machines, better use dnsHostName instead of name. The ldapfilter does only return enabled accounts
$Machines = (Get-ADComputer -ldapfilter "(&(samaccountname=*)(!userAccountControl:1.2.840.113556.1.4.803:=2))" -SearchBase 'OU=Laptops,OU=Win10Modern,OU=LN,OU=Workstations,DC=cooley,DC=com').dnsHostName
$result = @(
    foreach ($Machine in $Machines){
        try {
            #Test connection, remove -quiet otherwise you wont get infos like IP
            $contest = Test-Connection -ComputerName $Machine -Count 1 -ErrorAction:Stop
        }
        Catch {
            write-warning "Machine: $machine is not pingable - process next item"
            continue
        }
        if($contest.IPV4Address.IPAddressToString -match "^(10\.57)"){
            #WMI is a bit outdated you should use CIM instead
            #Get-WmiObject –ComputerName $Machine –Class Win32_ComputerSystem | Select-Object Username
            #Switched to EventLog as Win32_ComputerSystem does not give you the necessary information, will only detect the newest logon event of logon type 2 (logon locally)
            try {
                [xml[]]$xml = Get-WinEvent -ErrorAction:stop -ComputerName $machine -ProviderName "Microsoft-Windows-Security-Auditing" -FilterXPath "*[System[EventID=4624] and EventData[Data[@Name='LogonType'] and (Data='2')]]" -MaxEvents 1 | %{$_.ToXml()}
            }
            Catch {
                write-error "Failed to query EventLog - Exception: $_"
                continue
            }
            $userName = ($xml.event.EventData.data | ?{$_.name -eq 'targetusername'}).'#text'
            $inOffice = $true
        }
        Else {
            $username = $null
            $inOffice = $false
        }
        #Build object 
        $attrsht = [ordered]@{
            user=$userName
            machine=$Machine
            isInOffice=$inOffice
            ipAddress=$contest.IPV4Address.IPAddressToString
        }
        new-object -TypeName psobject -Property $attrsht
    }
)
$result | export-csv C:\inOfficeReport.csv -delimiter ";" -notypeinformation```
userhFtl10
Related