labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_AutoJoin
Parameters
Name
Type
Mode
Definition
BEGIN -- put all computers into groups using searches INSERT IGNORE INTO SubGroups (GroupID,ComputerID) (SELECT MasterGroups.GroupID,Searches.ComputerID FROM MasterGroups JOIN Searches ON Searches.SearchID=MasterGroups.AutoJoinScript WHERE autojoinscript>0); -- remove computers from groups where limit-to-search is flagged for that group DELETE SubGroups FROM SubGroups JOIN Mastergroups USING (groupid) WHERE MasterGroups.LimitToParent=1 AND ComputerID NOT IN (SELECT ComputerID FROM Searches WHERE SearchID=MAstergroups.AutoJoinScript); -- remove computers from non-master groups if they belong to master groups CALL sp_AutoRemoveComputersMasterTrump(); END