'looking for output by each server with how many backup types

I have text file which is 400 MB. lines are as shown below. First value is server name and 6th value is backup type(incr /full).

rspedw02.corpads.local 4829860108 JC_UNIX_FS01_INCR_DD2 JC_FS_DD2 UNIX_FS01_INCR_DD2 incr 02/23/2022 03/29/2022 03/29/2022  disk 1645592421 Clone_DR 4716 MB MNBDD5304P.CORPADS.LOCAL
rspedw02.corpads.local 4829860108 JC_UNIX_FS01_INCR_DD2 JC_FS_DD2 UNIX_FS01_INCR_DD2 incr 02/23/2022 03/29/2022 03/29/2022  disk 1645592421 backup 4716 MB JCBDD2301P.CORPADS.LOCAL
rspedw03.corpads.local 3085876532 JC_UNIX_FS01_INCR_DD2 JC_FS_DD2 UNIX_FS01_INCR_DD2 incr 02/23/2022 03/29/2022 03/29/2022  disk 1645592426 Clone_DR 3013 MB MNBDD5304P.CORPADS.LOCAL
rspedw03.corpads.local 3085876532 JC_UNIX_FS01_INCR_DD2 JC_FS_DD2 UNIX_FS01_INCR_DD2 incr 02/23/2022 03/29/2022 03/29/2022  disk 1645592426 backup 3013 MB JCBDD2301P.CORPADS.LOCAL
rsuedw01.corpads.local 1020344 JC_DB_DB2 JC_DB Clone_DR    full 02/23/2022 04/04/2022 04/04/2022         disk 1645592431 Clone_DR    997 KB MNBDD3302P.corpads.local
rsuedw01.corpads.local 1020344 JC_DB_DB2                   full 02/23/2022 04/04/2022 03/30/2022         disk 1645592431             997 KB JCBDD1300P.corpads.local
rsuedw03.corpads.local 12608 MN_UNIX_NP_7_Days MN_DB Clone_DR full 02/23/2022 04/21/2022 04/21/2022      disk 1645592432 Clone_DR     13 KB JCBDD1300P.corpads.local
rsuedw03.corpads.local 12608 MN_UNIX_NP_7_Days             full 02/23/2022 04/21/2022 03/30/2022         disk 1645592432              13 KB MNBDD3302P.corpads.local
rsuedw01.corpads.local 12608 JC_UNIX_NP_7_Days JC_DB Clone_DR full 02/23/2022 04/04/2022 04/04/2022      disk 1645592442 Clone_DR     13 KB MNBDD3302P.corpads.local
rsuedw01.corpads.local 12608 JC_UNIX_NP_7_Days  

I am looking for output like

rspedw03.corpads.local incr 7 , full 5
rspedw02.corpads.local incr 10, full 2

so far i came up like

Get-Content C:\anil\scripts\test.txt|%{$arr=$_.Split(" ");if($arr[0] -eq "rspedw03.corpads.local" -and $arr[5] -eq "incr") {"{0} {1}" -f $arr[0], $arr[5]}}

But not want i want. any help appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source