'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 |
|---|
