Skip to content

Instantly share code, notes, and snippets.

@Laim

Laim/org_rules.sql

Created March 14, 2022 15:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Laim/dee0e030cc6b452d1eafb4b7e48ca9c5 to your computer and use it in GitHub Desktop.
Save Laim/dee0e030cc6b452d1eafb4b7e48ca9c5 to your computer and use it in GitHub Desktop.
Download ZIP
Get organisation and autoconnect rules in Snow License Manager
Raw
org_rules.sql
/*
Author: Laim McKenzie
URL: https://gist.github.com/Laim/dee0e030cc6b452d1eafb4b7e48ca9c5
Date: 14-03-2022
*/
SELECT
o.Hierarchy,
oacr.RuleName,
oacrd.IdentifierField,
oacrd.IdentifierValue
FROM SnowLicenseManager.dbo.tblOrganization o
INNER JOIN SnowLicenseManager.dbo.tblOrgAutoConnectRule oacr ON o.OrgChecksum = oacr.OrgChecksum
INNER JOIN SnowLicenseManager.dbo.tblOrgAutoConnectRuleDefinitions oacrd ON oacr.RuleID = oacrd.RuleID
--WHERE o.CID = 0
ORDER BY o.Hierarchy
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment