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