Does anyone know why this will work as a custom report but when I strip it out and try to use it as a query (curl and web) it just gives me “Requested resource does not exist.”
<?relevance
concatenations of (html "<tr><td>" & item 0 of it & html "</td><td>" & item 1 of it & html "</td></tr>") of (
name of it,
concatenation ", " of unique values of (
last 4 of (year of it as string) & "/" & (month of it as two digits)
) of (
source release date of it | date "01 Jan 1970"
) of relevant fixlets whose (
name of site of it contains "Patches for RHEL 9" and
category of it does not contain "Support" and
fixlet flag of it
) of it
) of bes computers whose (operating system of it as lowercase starts with "red hat enterprise linux 9")
?>
I tried encoding as well
curl -k -u "OBFUSCATED:OBFUSCATED" "https://bigfix-.local:52311/api/query?relevance=concatenations%20of%20(item%200%20of%20it%20%26%20item%201%20of%20it)%20of%20(name%20of%20it,%20concatenation%20%22,%20%22%20of%20unique%20values%20of%20(last%204%20of%20(year%20of%20it%20as%20string)%20%26%20%22/%22%20%26%20(month%20of%20it%20as%20two%20digits))%20of%20(source%20release%20date%20of%20it%20%7C%20date%20%2201%20Jan%201970%22)%20of%20relevant%20fixlets%20whose%20(name%20of%20site%20of%20it%20contains%20%22Patches%20for%20RHEL%208%22%20and%20category%20of%20it%20does%20not%20contain%20%22Support%22%20and%20fixlet%20flag%20of%20it)%20of%20it)%20of%20bes%20computers%20whose%20(operating%20system%20of%20it%20as%20lowercase%20starts%20with%20%22red%20hat%20enterprise%20linux%208%22)"
Requested resource does not exist.
concatenations of (item 0 of it & " | " & item 1 of it) of (name of it, concatenation ", " of unique values of (last 4 of (year of it as string) & "/" & (month of it as two digits)) of (source release date of it | date "01 Jan 1970") of relevant fixlets whose (name of site of it contains "Patches for RHEL 9" and category of it does not contain "Support" and fixlet flag of it) of it) of bes computers