khantext

/*VULNERABILITIES*/
/*Select all vulnerabilities which affect at least one asset in your environment, returning all of the risk/severity scoring details.*/
SELECT fa.vulnerability_id, fa.affected_assets, fa.affected_sites, fa.vulnerability_instances, fa.first_discovered, fa.most_recently_discovered, dv.description, dv.nexpose_id, dv.title, dv.riskscore, dv.severity_score, dv.severity, dv.cvss_score, dv.cvss_v2_score, dv.cvss_v3_score
FROM fact_vulnerability fa
LEFT JOIN dim_vulnerability dv ON fa.vulnerability_id=dv.vulnerability_id
WHERE fa.affected_assets > 0

/*ASSETS*/
/*Select all non-blank hostnames currently in the dim_asset table, including their IP addresses.*/
SELECT da.ip_address, da.host_name

khantext

from hashlib import md5, sha1
from cryptography.hazmat.primitives.ciphers import Cipher, algorithms, modes
from cryptography.hazmat.backends import default_backend
from base64 import b64encode, b64decode
import sys, time
import requests

DEFAULT_MASTERKEY=b'p1a2l3o4a5l6t7o8'

class PanCrypt():