Skip to content

Instantly share code, notes, and snippets.

@808codist
Created May 6, 2020 23:07
Show Gist options
  • Save 808codist/c1ed5475b984a6098a6103bcd5848d10 to your computer and use it in GitHub Desktop.
Save 808codist/c1ed5475b984a6098a6103bcd5848d10 to your computer and use it in GitHub Desktop.
get SCORCH runbook's GUID
SELECT distinct LOWER(POLICIES.UniqueID) AS RunbookID
-- , LOWER(CUSTOM_START_PARAMETERS.UniqueID) AS ParameterID
-- , CUSTOM_START_PARAMETERS.value
FROM POLICIES
INNER JOIN OBJECTS
ON POLICIES.UniqueID = OBJECTS.ParentID
LEFT OUTER JOIN CUSTOM_START_PARAMETERS
ON OBJECTS.UniqueID = CUSTOM_START_PARAMETERS.ParentID
WHERE POLICIES.Name = 'RB1'
AND policies.deleted = 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment