Unlinked auto-connect rule definitions

June 1, 2018 at 7:00 AM

Dear Community, Recently I was tidying up our auto-connect rules in our SMACC and I found that we have a few dozens of Rule Definitions that are not linked to any Rule. I think they might be remains of Rules that we deleted in the past as we created and updated our Organization structure in the SMACC. The rules are in the table tblOrgAutoConnectRule and their definitions are in tblOrgAutoConnectRuleDefinitions. The 2 tables are linked through the RuleID field. So if I run this query: SELECT * FROM tblOrgAutoConnectRuleDefinitions r LEFT OUTER JOIN tblOrgAutoConnectRule rd ON r.RuleID = rd.RuleID WHERE rd.RuleID IS I should find nothing because each rule definition should have a rule associated to it. But the query brings up over 30 rules. Is there a reason why they are left behind? Can I delete those rules? Thanks for your advice.

Community Manager (Flexera Software)
8 years ago
Hi Samuel, thank you for raising this! I would not recommend to make any changes on a database level, unless you fully know all dependencies. This is something, that can be covered by either our Snow Support or by Professional Services in your region. I would suggest you to open a ticket via the Support Portal and to contact your account manager, if you would like this to be investigated properly. Please let me know, if you need any assistance. /marcel
Expand Post
- SamuelBaughan
  8 years ago
  Hi Mark, Thank you very much for this reminder. As far as I know, no rule has been added nor deleted in the database. I only ran a few queries to understand how the rules work. As you suggest, I'll raise a ticket with the Snow Support for this question.
  Expand Post