Skip to content

Instantly share code, notes, and snippets.

@Laim
Created Mar 14, 2022
Embed
What would you like to do?
Get organisation and autoconnect rules in Snow License Manager
/*
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