Jump to content

DNA3e8

Members
  • Content Count

    31
  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Agent Count
    Less than 100
  1. DNA3e8

    Disk Cleanup Project

    thank you
  2. Is this working for anyone else?
  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. DNA3e8

    GPO for LT agent install

    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. DNA3e8

    GPO for LT agent install

    @Jmw66 We have been using it with 12- the only issue (addressed in this last release) was computers going to location 1
  7. DNA3e8

    GPO for LT agent install

    @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. DNA3e8

    GPO for LT agent install

    I think login scripts run under system not under the user
  9. DNA3e8

    GPO for LT agent install

    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. DNA3e8

    GPO for LT agent install

    if you do i as a login script vs a startup script it may be ok for users
  11. DNA3e8

    GPO for LT agent install

    if the 20 locations have separate Groups or OUs Tim's script with separate parameters will work great for this.
  12. DNA3e8

    LabTechGeek Updates/Annoucements

    I am checking with some of the deeper pockets here- they may have some questions so I am watching for updates about tax liability (mikemoyse)
  13. DNA3e8

    GPO for LT agent install

    Agent presence is checked by looking for the Service (line 332) ' Check to see if the LTService service is running or not (ie: is the agent installed)' If LTSERVICE_PRESENT(vbFalse) = vbFALSE Then output.writeline "Agent is not installed" objShell.LogEvent logERROR, mspName & ": The Labtech management agent is not installed on this device." INSTALL_AGENT Else 'output.writeline "Agent is installed" 'objShell.LogEvent logINFO, mspName & ": The Labtech management agent is already installed on this device." AGENT_IS_INSTALLED FINISH_SCRIPT End IF Does your service have a different name? You may be able to edit the service name check (line 745) ' Checks to see if the LTService service is registered on the device. This is a basic indication that the Labtech agent is installed.' Function LTSERVICE_PRESENT(bolVerbose) Set colSvc = objWMI.ExecQuery("SELECT * FROM Win32_Service WHERE Name = 'LTService'") bolPresent = vbFalse If colSvc.Count = 0 Then bolPresent = vbFalse objShell.LogEvent logERROR, mspName & ": The LTService service was not found on this device." If bolVerbose = vbTrue Then output.writeline "LTService service is not present on this device." End IF Else bolPresent = vbTrue objShell.LogEvent logINFO, mspName & ": The LTService service was found on this device." If bolVerbose = vbTrue Then output.writeline "LTService service was found on this device." End IF End IF LTSERVICE_PRESENT = bolPresent End Function Edit the WMI Query (line 748) Set colSvc = objWMI.ExecQuery("SELECT * FROM Win32_Service WHERE Name = 'LTService'") Other 'should I install checks': Line 169 of the current version check for an existing agent: ' Check to see if we want to prevent the agent from installing onto a device using this script' strDisableAgentGPO = vbNull objReg.GetStringValue HKEY_LOCAL_MACHINE, "SOFTWARE\" & mspName & "\Labtech", "DisableAgentGPO", strDisableAgentGPO If strDisableAgentGPO <> vbNull Then If strDisableAgentGPO = "1" Then output.writeline "The agent has been prevented from installing onto this device." objShell.LogEvent logERROR, "The agent has been specifically denied from being installed on this device. This has been done via the HKLM\Software\" & mspName & "\Labtech\DisableAgentGPO value being set to 1. Change this String to 0 to allow the GPO installer script to install the agent." WScript.Quit logERROR End If End If Note the MSP name variable in the registry path The start of it logs that gpo installed LT: line 91 ' Create the Reg key that we will log into' If bolDebugMode = vbTrue Then output.writeline "Creating Registry key" End If objReg.CreateKey HKEY_LOCAL_MACHINE, "SOFTWARE\" & mspName & "\Labtech"
  14. DNA3e8

    Create Executive Summary Report in New Report Center

    Filters are only available for the first dataset/group. I have looked at creating custom views to get around this 'feature'.
×