SQL query equivalents of these API calls

hi! I am looking for the SQL-query equivalents of these simple Rapid7-API calls.

Could you please assist with this? As they are not as obvious as they seem:) thanks!




Query 1)

asset.groups

IN

[‘class - windows - wintel team’]

vulnerability.categories

IN

[‘microsoft’]

vulnerability.categories

NOT IN

[‘microsoft sql server’, ‘microsoft .net framework’, ‘microsoft asp’, ‘microsoft exchange’, ‘microsoft sharepoint’, ‘microsoft asp.net’, ‘microsoft iis’, ‘microsoft msxml’, ‘microsoft xml’]




Query 2)

asset.groups

IN

[‘class - aix - linux - unix team’]

vulnerability.categories

IN

[‘red hat enterprise linux’, ‘centos’, ‘suse’, ‘red hat’, ‘ibm aix’, ‘snmp’, ‘ssh’, ‘samba’]