#Set Location(66) Admin PasswordID and New Agent Deployment TemplateID
UPDATE locations SET PasswordID=92,TemplateID=36 WHERE LocationID=66;
#Get local subnet information for probe computer (1183)
SELECT A.LocalAddress, B.ProbeID, B.Usernames, B.Subnets FROM computers A LEFT JOIN probeconfig B ON A.ComputerID = B.ProbeID WHERE ComputerID = 1183;
#Setup default probe scanning for local network. Set SNMP strings, etc.
Insert Into ProbeConfig (ProbeID,Usernames,CommunityStrings,IpPorts,ScanFrequency,Subnets,CollectionOn,LabtechPush) Values(1183,'92,','public,private,admin','80,21,23','1440','10.4.2.1,253|','0','0');
#Assigns Computer 1183 to be the probe for locationid 66
Update Locations Set ProbeID=1183 Where LocationID=66;
#Assigns any network devices in location 66 to Probe 1183
Update networkdevices Set ComputerID=1183 Where LocationID=66;```