labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_RunCommandGroup
Parameters
Name
Type
Mode
GID
int(11)
IN
COM
int(11)
IN
Par
varchar(200)
IN
UID
int(11)
IN
Definition
BEGIN insert ignore into commands (command,Parameters,computerid) select distinct COM,Par,usersec.computerid from Usersec Join subgroupwchildren on usersec.ComputerID=subgroupwchildren.ComputerID Where subgroupwchildren.groupid = GID and usersec.userid = UID and (Permission & 4)=4; END