topic Script to fetch actual Jumbo Hotfix take details in Scripts

Script to fetch actual Jumbo Hotfix take details

Hugo_vd_Kooij — Thu, 29 Dec 2022 16:07:48 GMT

There was a serious itch had to scratch where I want to get a fast overview of the current General Availability and Ongoing Jumbo Hotfix details.

Due to the restructuring of information I had to redesign my tool and it ended up to be a relative simple bash script.

#!/bin/bash # Fetch Check Point HFA details # Design by Hugo van der Kooij CURL="curl -s" BASE="https://sc1.checkpoint.com/documents/Jumbo_HFA" for VER in R80.20 R80.30 R80.40 R81 R81.10 do if [ $VER = "R81" ]; then VER2="R81.00" else VER2=$VER fi echo " *** Version $VER ***" $CURL "${BASE}/${VER}/${VER2}/List-of-Takes.htm" | \ grep "Take" | \ grep -v "Archive" | \ grep "General" | \ sed "s/.*\">//g" | \ sed "s/<.*//g" | \ head -1 $CURL "${BASE}/${VER}/${VER2}/List-of-Takes.htm" | \ grep "Take" | \ grep "Ongoing" | \ sed "s/.*\">//g" | \ sed "s/<.*//g" | \ head -1 done

Re: Script to fetch actual Jumbo Hotfix take details

Hugo_vd_Kooij — Wed, 18 May 2022 11:57:36 GMT

I had to fix the script a bit and the script above has been changed about 30 minutes after the original post to resolve the issue with R81

It now runs well ....

*** Version R80.20 *** Take 205 - General Availability Take 211 - Ongoing *** Version R80.30 *** Take 246 - General Availability Take 251 - Ongoing *** Version R80.40 *** Take 158 - General Availability Take 153 - Ongoing *** Version R81 *** Take 65 - General Availability Take 68 - Ongoing *** Version R81.10 *** Take 45 - General Availability Take 55 - Ongoing

Re: Script to fetch actual Jumbo Hotfix take details

Hugo_vd_Kooij — Wed, 25 May 2022 10:03:42 GMT

Well. It didn't take Check point that long to break my script. So I am back to hacking my way back in. Stay tuned.

Re: Script to fetch actual Jumbo Hotfix take details

Hugo_vd_Kooij — Wed, 25 May 2022 10:42:35 GMT

New version:

#!/bin/bash # Fetch Check Point HFA details # Design by Hugo van der Kooij CURL="curl -s" BASE="https://sc1.checkpoint.com/documents/Jumbo_HFA" for VER in R80.20 R80.30 R80.40 R81 R81.10 do if [ $VER = "R81" ]; then VER2="R81.00" else VER2=$VER fi echo " *** Version $VER ***" $CURL "${BASE}/${VER}/${VER2}/${VER2}-List-of-all-Resolved-Issues.htm" | \ grep "Take" | \ grep -v "Archive" | \ grep "General" | \ sed "s/.*\">//g" | \ sed "s/<.*//g" | \ head -1 # $CURL "${BASE}/${VER}/${VER2}/List-of-Takes.htm" | \ $CURL "${BASE}/${VER}/${VER2}/${VER2}-List-of-all-Resolved-Issues.htm" | \ grep "Take" | \ grep "Ongoing" | \ sed "s/.*\">//g" | \ sed "s/<.*//g" | \ head -1 done

Re: Script to fetch actual Jumbo Hotfix take details

Duane_Toler — Tue, 28 Mar 2023 21:58:42 GMT

You can replace your collection of sed/grep with some parsing via xmllint. You'll need to save the output from curl to a file and do an ugly force-feeding to xmllint to get pretty-ish output:

$CURL "${BASE}/${VER}/${VER2}/${VER2}-List-of-all-Resolved-Issues.htm" |\ xmllint --html --xpath '//table[@class="TableStyle-TP_Table_Dark_Header_and_Pattern"]/tbody/tr[1]' - 2>/dev/null ;echo

et voilà:

for VER in R80.20 R80.30 R80.40 R81 R81.10 do if [ $VER = "R81" ]; then VER2="R81.00" else VER2=$VER fi echo -n "$VER " curl -s -k "${BASE}/${VER}/${VER2}/${VER2}-List-of-all-Resolved-Issues.htm" |\ xmllint --html --xpath '//table[@class="TableStyle-TP_Table_Dark_Header_and_Pattern"]/tbody/tr[1]/td/p/a/text()' - 2>/dev/null echo done R80.20 Take 230 - General Availability R80.30 Take 255 - General Availability R80.40 Take 196 R81 Take 82 R81.10 Take 93

Until Check Point web devs change the HTML structure for R82 .... 😕

Re: Script to fetch actual Jumbo Hotfix take details

Duane_Toler — Wed, 29 Mar 2023 15:57:14 GMT

To make it closer to your original:

curl -s -k https://sc1.checkpoint.com/documents/Jumbo_HFA/${VER}/${VER2}/${VER2}-List-of-all-Resolved-Issues.htm |\ xmllint --html --xpath 'concat(//table[@class="TableStyle-TP_Table_Dark_Header_and_Pattern"]/tbody/tr[(contains(.//td[3]/p/text(),"-"))][1]/td[1]/p/a/text()," Ongoing ", //table[@class="TableStyle-TP_Table_Dark_Header_and_Pattern"]/tbody/tr[not (contains(.//td[3]/p/text(),"-"))][1]/td[1]/p/a/text(), " Recommended ")' - 2>/dev/null

There's a literal carriage-return in the text after the two strings so that a line break appears (xmllint can't really do "\n" like nature intended... 🙄)

Output:

*** Version R80.20 *** Take 210 - Ongoing Ongoing Take 230 - General Availability Recommended *** Version R80.30 *** Take 245 - Ongoing Ongoing Take 255 - General Availability Recommended *** Version R80.40 *** Take 196 Ongoing Take 192 Recommended *** Version R81 *** Take 82 Ongoing Take 81 Recommended *** Version R81.10 *** Take 94 Ongoing Take 87 Recommended

So now someone can incorporate this into an Ansible playbook, or whatever else you want.