Hi All, Need some help with SPL query to compare the data from same host on 2 different dates and give me a status as "found" or "not found" . Status = Found if it finds the notepad is still installed on same Path on the same machine else not found.   so far I have created a kvstore lookup to store the data but cannot come up with logic to compare the data I have added sample data below. All help is appreciated.   HostNameExeVersion Path ProductName RunDate sourcetype xxxxx null C:\Windows\WinSxS\amd64_microsoft-windows-notepad_31bf3856ad364e35_10.0.19041.3996_none_e397b63725671b86\f\notepad.exe null 2024-06-13 07:41:37 feed xxxxx null C:\Windows\WinSxS\amd64_microsoft-windows-notepad_31bf3856ad364e35_10.0.19041.3996_none_e397b63725671b86\r\notepad.exe null 2024-06-14 07:41:37 feed ... View more

trying to get a script working  import urllib.request, json try: with urllib.request.urlopen("XXXXXXXXX.json") as url: data = json.loads(url.read().decode()) print("data received") for item in data: print(item) except urllib.error.URLError as e: print(f"Request failed with error: (e)") this works fine and fetches the data but  I need this to pass through proxy server when I try that it does not work.. any help is apprecaited.   ... View more