Organization AutoConnect Rules

Portal User asked a question.

March 27, 2019 at 7:00 AM

Organization AutoConnect Rules - REDUX

Another question about auto connect rules. As I posted previously it is tough finding the right combination to fit all situations. Especially when you acquire another company and their PC naming is all over the place.

I was reviewing my autoconnect rules and removing ones that show nothing in the preview tab. Obviously that rule is useless and not picking up anything. I'd like to use Hostname primarily, but use IP as a secondary rule in case host naming is non-standard.

So here's my question, given that above, if I see items in the preview for IP that have names that would fulfil the hostname rule, I can remove the IP rule, right? And why would it not pickup in the hostname rule first? Are they looked at in the order they sit in the properties window? Can that order be changed?

OK, that was more than 1 question. Sorry.

Any insight into this is appreciated.

Software & License Management

Portal User
7 years ago
Additional questions regarding autoconnect rules. Has anyone ever created a report that gets conflicts in the autoconnect rules? I have been going back through one by one and it is very time consuming. Is there a way to get logging or errors from autoconnect rules?
Expand Post
- Oliver Berger (Flexera Software)
  7 years ago
  Hi ‌, yes, I have done it, years ago, but I'm not sure, if it is still working / running... Maybe knows. Is the 'SLM - Autoconnect Rule Conflicts - Report' still working/used?
  Expand Post
  - Portal User
    7 years ago
    Hi , your report is still perfect, thanks for the report declare @cid int = {0} declare @orgchecksum int declare @ruleid uniqueidentifier declare @type int declare @query nvarchar(max) declare @t1 table (Name nvarchar(50),Conflict int) declare @t2 table (name nvarchar(50),Conflict int,Ruleid uniqueidentifier, Orgid int) --update tblcomputerinfo --set orgchecksum = select defaultorgchecksum from tblCIDDataSource and cid = @cid) --where DisableAutoEditing = 0 declare lic cursor for select ruleid,o.orgchecksum,Type,SQLDefinition from tblOrgAutoConnectRule oa inner join tblorganization o on oa.orgchecksum = o.orgchecksum where type = 0 order by Level, SQLDefinition open lic fetch next from lic into @ruleid,@orgchecksum,@type,@query while (@@fetch_status=0) BEGIN insert into @t1 exec OrgAutoConnectRuleApply @cid,@orgchecksum,@ruleid,@type,@query,1 insert into @t2 select name,conflict,@ruleid,@orgchecksum from @t1 delete @t1 where name = name exec OrgAutoConnectRuleApply @cid,@orgchecksum,@ruleid,@type,@query,0 fetch next from lic into @ruleid,@orgchecksum,@type,@query end close lic deallocate lic select t.name as [HostName],o.Hierarchy as Hierarchy,orgac.RuleName as Rulename, case conflict when 0 then 'okay' when 1 then 'internal' when 2 then 'external' end as conflicttype from @t2 t inner join tblorganization o on t.Orgid = o.OrgChecksum inner join tblOrgAutoConnectRule orgac on t.ruleid = orgac.RuleID where conflict > 0 order by t.name Best Regards Julian
    Expand Post
    Portal User
    7 years ago
    Excuse my ignorance in this matter, but is this a SQL script or how do I use it? Thanks,
    Expand Post
    Portal User
    7 years ago
    Hi Mark, this is a SQL-Script you can use on the SQL Database 'SnowLicenseManager'. You can use this for creating a custome Report in SLM.
    Expand Post
    Portal User
    7 years ago
    Hi Mark, this is a SQL-Script you can use on the SQL Database 'SnowLicenseManager'. You can use this for creating a custome Report in SLM.
    Expand Post

Related Product Forums