Hi..
I have the logs which contain DATE, NUMBERS AND PACKAGES ACTIVATED ON THEM...
HOW CAN I GET THE COUNT OF ACTIVE PACKAGES AND NUMBERS ON ANY PARTICULAR DATE FROM THIS.
EG.
Date Command VC Pack Name
01-01-2020 Activate 1234567890 Pack 2
02-01-2020 Activate 1234567890 Pack 1
20-01-2020 Deactivate 1122334455 Star Sports 1
20-01-2020 Deactivate 1122334455 Pack 1
20-01-2020 Deactivate 1122334455 Pack 3
20-01-2020 Deactivate 1122334455 Pack 2
27-01-2020 Activate 1122334455 Pack 2
27-01-2020 Activate 1122334455 Pack 3
27-01-2020 Activate 1122334455 Star Sports 1
27-01-2020 Activate 1122334455 Pack 1
28-01-2020 Deactivate 1122334455 Star Sports 1
30-01-2020 Deactivate 1234567890 Pack 2
30-01-2020 Deactivate 1234567890 Pack 1
01-02-2020 Activate 1234567890 Pack 2
01-02-2020 Activate 1234567890 Pack 1
Thanks
Solved! Go to Solution.
Thank you Dani for the solution.