I needed to verify the last time a bunch of servers were patched — basically to ensure compliance with the stated quarterly patching interval. This python script pulls the list of installed packages and the date for each package, sorts the info by date DESC, and then reports the latest date on any packages — as well as the number of packages updated on that date. If there’s only one … the system still might bear some investigation. But if a couple of dozen packages were updated in the past quarter … we don’t need to be too worried about turning up on the out-of-compliance report.
import subprocess
import re
import datetime
from collections import OrderedDict
def getFirstElement(odictInput):
'''
This function returns the first element from an ordered collection (an arbitrary element if an unordered collection is passed in)
Input -- odictInput -- ordered collection
Output -- type varies -- first element of ordered collection, arbitrary element of unordered collection
'''
return next(iter(odictInput))
listHosts = ['host01.example.com', 'host02.example.com', 'host03.example.com','host04.example.com','host05.example.com']
for strHost in listHosts:
dictPatchDates = {}
objResults = subprocess.Popen(['ssh', strHost, 'rpm', '-qa', '--last'],stdout=subprocess.PIPE)
for strLine in objResults.stdout:
strPackageInfo = strLine.decode('utf-8').rstrip()
listPackageInfo = re.split(r'\s*([a-zA-Z]{3,}\s[0-9]{2,}\s[a-zA-Z]{3,}\s[0-9]{2,})',strPackageInfo)
strUpdateDate = listPackageInfo[1]
dateUpdateDate = datetime.datetime.strptime(strUpdateDate, "%a %d %b %Y").date()
if dictPatchDates.get(dateUpdateDate) is not None:
dictPatchDates[dateUpdateDate] = dictPatchDates[dateUpdateDate] + 1
else:
dictPatchDates[dateUpdateDate] = 1
dictOrderedPatchDates = OrderedDict(sorted(dictPatchDates.items(), key=lambda t: t[0],reverse=True))
dateLatestPatch = getFirstElement(dictOrderedPatchDates)
print(f"{strHost}\t{dateLatestPatch}\t{dictOrderedPatchDates[dateLatestPatch]}")