Jump to content

DNA3e8

Members
  • Content Count

    34
  • Joined

  • Last visited

Community Reputation

1 Neutral

My Information

  • Agent Count
    Less than 100

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. How have the tests been going? How can I test the plugin for an 1hr or a day? If there is major issue how to I roll back or remove the plugin?
  2. Do you have a different source for the recording? it is in plying and the link is broken: https://www.twitch.tv//v/376361931?t=
  3. After editing the last block SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING(PowerProfiles,1+LOCATE(',',PowerProfiles,LOCATE(CurrentPwrProfile,PowerProfiles))),'|',1) AS CurrentProfileName, computers.CurrentPwrProfile AS Identity, computers.ComputerID, computers.Name AS `ComputerName`, CONVERT(CONCAT(clients.name,' ',locations.name) USING utf8) AS Location, acd.NoAlerts, acd.UpTimeStart, acd.UpTimeEnd FROM computers JOIN commands ON commands.computerid=computers.computerid JOIN locations ON locations.locationid=computers.locationid JOIN clients ON clients.clientid=computers.clientid JOIN AgentComputerData AS acd ON Computers.ComputerID=acd.ComputerID JOIN (SELECT computers.computerid AS computerid, SUBSTRING_INDEX(LEFT(PowerProfiles,LOCATE(@TargetProfile,PowerProfiles)-2),'|',-1) AS TargetPowerGuid FROM computers WHERE LOCATE(@TargetProfile,PowerProfiles)>0) AS result ON result.computerid=computers.computerid WHERE (computers.CurrentPwrProfile NOT LIKE result.TargetPowerGuid) #AND computers.ComputerID IN (@TestAgent) AND ComputerID IN (SELECT computerID FROM TCOMP) AND Computers.ComputerID NOT IN (SELECT ComputerID FROM AgentIgnore WHERE AgentID=@InternalMonitorIDNumber); DROP TEMPORARY TABLE IF EXISTS Tcomp; I get an error: Query: SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING(PowerProfiles,1+LOCATE(',',PowerProfiles,LOCATE(CurrentPwrProfile,PowerProfiles))),'|'... Error Code: 1052 Column 'ComputerID' in IN/ALL/ANY subquery is ambiguous Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0 sec
  4. https://product.connectwise.com/communities/5-automate-enhancements/categories/16-network-devices-and-mapping/topics says: Sorry, this forum is private. We cannot show this page, because you don't have permission. Reason: You are not authorized. Sign in
  5. Our Firewall / port forwarding does not allow port 80... so in version Version 1.8 line 94- included https CONST serverFQDN = "https://*************" ' FQDN or IP of Automate central server with protocol line 260 changed: from ' strDirectURL = "http://" & serverFQDN & "/Labtech/Deployment.aspx?Probe=1&installType=msi&MSILocation=" & strLocation to: strDirectURL = serverFQDN & "/Labtech/Deployment.aspx?Probe=1&installType=msi&MSILocation=" & strLocation The registry check that the script does is reinstalling were it had set the server to httP;//
  6. @Jmw66 We have been using it with 12- the only issue (addressed in this last release) was computers going to location 1
  7. @timwiser We have been using the GPO script you made - is has worked well thank you. We are noticing that the MSI it download ties to location 1 not the one specified. Secondly I the newest version of the script I am seeing in this thread is 1.6. Are you seeing that agents get installed to location 1?
  8. I think login scripts run under system not under the user
  9. You can mimic naming policy by making a search for computer that match router address then us the search to run a script to move computer to a new location
  10. if you do i as a login script vs a startup script it may be ok for users
  11. if the 20 locations have separate Groups or OUs Tim's script with separate parameters will work great for this.
×
×
  • Create New...