#@&cls&powershell "type %~s0|out-string|iex"&pause&exit
$a=@{}
gc b.txt|%{$a[$_ -replace '.*name=(.*)&.*-\s(\S+).*','$1 $2']=$_}
$b=(gc .\c.txt) -match (((gc a.txt) -replace '.*infoid=(\S+).*','$1') -join '|')
$c=@{}
$a.keys|%{$t=$_ -split '\s+'; $c[$t[1]]=$t[0]}
$d=@{}
$b|%{$t=$_ -replace '.*infoid=([\S]+).*-\s([\d\.]+).*','$1 $2';$d[$t]+=1}
$e=$d.keys|%{$t=$_ -split '\s+';"{0} {1}`t{2} {3}" -f $t[1],$c[$t[1]],$t[0],$d[$_]}
$f=@{}
$e|%{$t=$_ -split '\s+';$f[$t[1]]+=[int]$t[3]}
$g=($f.keys|?{$f[$_] -gt 2}) -join '|'
$h=@{}
$e -match $g|%{$t=$_ -split '\s+';$h[$t[1]]+=@($_)}
$h.keys|%{sc "$_.txt" $h[$_]}
复制代码

@echo off
setlocal enabledelayedexpansion
for /f "tokens=8,12 delims=-&= " %%i in (b.txt) do set #%%j=%%i
(for /f "tokens=1* delims==" %%x in (a.txt) do echo,%%y)>1.log
findstr /g:1.log c.txt>Newfile.txt
(for /f "tokens=8,9,11 delims=-= " %%a in (Newfile.txt) do (
    set /a "_%%a%%b+=1"
    if "!_%%a%%b!" == "2" echo,%%a-%%b
))>1.log
findstr /g:1.log Newfile.txt>2.log
(for /f "tokens=8,9,11 delims=-= " %%a in (2.log) do (
    if not defined @%%a%%b%%c echo,%%c	!#%%c!	%%a-%%b	!_%%a%%b!
    set @%%a%%b%%c=true
))>1.log
sort 1.log>Newfile.txt
del *.log
pause
复制代码

#@&cls&powershell "type %~s0|out-string|iex"&pause&exit
$a=@{}
gc b.txt|%{$a[$_ -replace '.*name=(.*)&.*-\s(\S+).*','$1 $2']=$_}
$b=(gc .\c.txt) -match (((gc a.txt) -replace '.*infoid=(\S+).*','$1') -join '|')
$c=@{}
$a.keys|%{$t=$_ -split '\s+'; $c[$t[1]]=$t[0]}
$d=@{}
$b|%{$t=$_ -replace '.*infoid=([\S]+).*-\s([\d\.]+).*','$1 $2';$d[$t]+=1}
$e=$d.keys|%{$t=$_ -split '\s+';"{0} {1}`t{2} {3}" -f $t[1],$c[$t[1]],$t[0],$d[$_]}
$f=@{}
$e|%{$t=$_ -split '\s+';$f[$t[1]]+=[int]$t[3]}
$g=($f.keys) -join '|'
$h=@{}
$e -match $g|%{$t=$_ -split '\s+';$h[$t[1]]+=@($_)}
$h.values|sc abc.txt
复制代码

@echo off
setlocal enabledelayedexpansion
for /f "tokens=8,12 delims=-&= " %%i in (b.txt) do set #%%j=%%i
(for /f "tokens=1* delims==" %%x in (a.txt) do echo,%%y)>1.log
findstr /g:1.log c.txt>Newfile.txt
(for /f "tokens=8,9,11 delims=-= " %%a in (Newfile.txt) do (
    set /a "_%%a%%b+=1"
    set /a "_%%a%%b%%c+=1"
    if "!_%%a%%b!" == "2" echo,%%a-%%b
))>1.log
findstr /g:1.log Newfile.txt>2.log
(for /f "tokens=8,9,11 delims=-= " %%a in (2.log) do (
    if not defined @%%a%%b%%c (
        echo,%%c	!#%%c!	%%a-%%b	!_%%a%%b%%c!
        set /a Sum+=!_%%a%%b%%c!
    )
    set @%%a%%b%%c=true
))>1.log
sort 1.log>Newfile.txt
echo,Sum	!Sum!>>Newfile.txt
del *.log
pause
复制代码

@echo off
setlocal enabledelayedexpansion
for /f "tokens=7,12 delims=&= " %%i in (b.txt) do set #%%j=%%i
(for /f "tokens=1* delims==" %%i in (a.txt) do echo,%%j)>Newfile.txt
findstr /g:Newfile.txt c.txt>1.log
(for /f "tokens=1* delims==" %%i in (1.log) do echo,%%j)>Newfile.txt
for /f "tokens=1-5,7 delims=- " %%a in (Newfile.txt) do set /a "_%%a%%b%%c%%d%%e%%f+=1"
(for /f "tokens=1-5,7 delims=- " %%a in (Newfile.txt) do (
    if not defined @%%a%%b%%c%%d%%e%%f (
        echo,%%f	!#%%f!	%%a-%%b-%%c-%%d-%%e	!_%%a%%b%%c%%d%%e%%f!
        set /a Sum+=!_%%a%%b%%c%%d%%e%%f!
    )
    set @%%a%%b%%c%%d%%e%%f=true
))>1.log
sort 1.log>Newfile.txt
echo,Sum	!Sum!>>Newfile.txt
del 1.log
pause
复制代码

$a='.\a.txt';
$b='.\b.txt';
$c='.\c.txt';

$hash=[Collections.Generic.HashSet[string]]::new();
$infoID = @();
(gc $a -ReadCount 0).foreach{
	$id = $_ -replace '^.*?=|\s+\d+$';
	if($hash.Add($id)){ $infoID+=$id }
}

$hash.Clear();

$user = @();
(gc $b -ReadCount 0).Foreach{
	$s = $_ -replace '^.*?=(.*?)&.*?-\s+((\d+\.){3}\d+).*$','$2,$1' -split ',';
	if($hash.Add($s[0]+$s[1])){
		$user += @{ $s[0].ToString() = $s[1]}
	}
}
$hash.Clear();

$ipCount=@();
(gc $c -ReadCount 0).Foreach{
	$s = $_ -replace '^.*?=(.*?)\s.*?-\s+((\d+\.){3}\d+).*$','$1,$2' -split ',';
	if($infoID.contains($s[0])){
		$ipCount+=[PsCustomObject]@{id=$s[0]; ip=$s[1]; name=$user."$($s[1])"; }
	}
}

($ipcount|group name).Foreach{
	$ip =$_.Group[0].ip;
	$name = $_.Name;
	$_.group|group id|%{$ip + "`t" + $name + "`t`t" + $_.Name + "`t" + $_.Count}
}


&cmd /c set/p=全部完成 退出<nul`&pause>nul;exit
复制代码

192.168.30.20   技术部_龙一a            7717F5D7-A409-4D48-9E87-1A92367C3593  1
192.168.30.20   技术部_龙一a            C8FC9543-453E-44AB-9188-FC72963689D1  1
192.168.30.20   技术部_龙一a            AAA31733-09CE-4015-A327-7C4BAC2B25EE  2
192.168.30.20   技术部_龙一a            A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.30.1    技术部_郭肥来a          7717F5D7-A409-4D48-9E87-1A92367C3593  2
192.168.30.1    技术部_郭肥来a          99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.30.1    技术部_郭肥来a          A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.102.11  服务部_李四博a          7717F5D7-A409-4D48-9E87-1A92367C3593  1
192.168.102.11  服务部_李四博a          99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.102.11  服务部_李四博a          C8FC9543-453E-44AB-9188-FC72963689D1  1
192.168.102.11  服务部_李四博a          AAA31733-09CE-4015-A327-7C4BAC2B25EE  1
192.168.29.10   人事部_肖逄文a          99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.29.10   人事部_肖逄文a          A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.37.153  工程部_张三a            99D32186-121E-4FF7-AB54-0F816687A0A5  1
192.168.37.153  工程部_张三a            C8FC9543-453E-44AB-9188-FC72963689D1  2
192.168.37.153  工程部_张三a            A0C8BDE0-6A46-4128-B566-5F40D0B83299  1
192.168.81.18   投诉部_王欣零a          AAA31733-09CE-4015-A327-7C4BAC2B25EE  1
复制代码