Jump to content

Joe Lusk

  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

My Information

  • Location
  • Agent Count
    4000 - 6000 Agents
  1. Joe Lusk

    Script to remove Symantec Cloud

    @EOpronet Sure, might be worth the purchase if it works. Thanks
  2. Joe Lusk

    Script to remove Symantec Cloud

    @HickBoy I would love an export. I managed to get something working using AutoIT, but it is less than perfect and requires a user to be logged on. This looks much better. Thanks in advance. I am actually most curious about the pre-removal operations. Are you doing more than you identified there?
  3. Joe Lusk

    Script to remove Symantec Cloud

    You are correct, that is the version and we have found the same things. Looks like manual is the only way by design.
  4. Joe Lusk

    Script to remove Symantec Cloud

    Has anyone had any luck with this since the updates to Cloud Protection Agent. I had a script that ran SEPPrep.exe with the RemoveSymantec=Y option, but that no longer seems to work. None of the msexec methods or wmi methods seem to work either. Any ideas?
  5. Joe Lusk

    Working with a CSV variable

    I have a unique situation where I an trying to modify a list to enable it to more easily work in a powershell script. The text looks like this: SprocketUsers,Domain Users,Password Sync It can vary in length so I am doing a ForEach type function with it in PS Now to use it in my PS script each CSV needs to have a single quote on it, like this: 'SprocketUsers','Domain Users','Password Sync' I can do a REGEX and split them out, but it appears that I can only work with the first match(?) SET: @Output1@ = MATCH(@sqldefaultgroups@ PATTERN (?<=^|,)(?:'{2}|(?:)|[^,'\r\n]+|'(?:'{2}|[^']+)+')(?=,|$)) Does anyone know any way to do this reformatting? Either via Automate scripting or PS
  6. Joe Lusk

    Problem with SQL get DataSet

    I had done all of that and followed that document, but I just found my error. I didn't realize that the returned variables all had the prefix of sql. So I was expecting @preferredDC@,@preferredDCAID@,@Domain@, etc when it actually returns @sqlpreferredDC@,@sqlpreferredDCAID@,@sqlDomain@, etc. Well thanks for re-assuring what i did was correct. 🙂
  7. Joe Lusk

    Problem with SQL get DataSet

    I have a mySQL database setup and I can run SQL Get Value queries against it successful. However when I try to run this query (SELECT preferredDC,preferredDCAID,Domain,defaultOU,defaultgroups,emailformat,emaildomain,logonformat FROM CustomerPortal.clientVars where AutomateID=12) as a SQL Get DataSet function it only returns "System.Data.DataSet" as the %sqldataset% I formed the query using HiediSQL and it works fine in there. SET: %sqlresult% = [SELECT preferredDC FROM CustomerPortal.clientVars WHERE AutomateID=12] using DSN-xxxxxx; WORKS Set %sqldataset% = SQL Get DataSet: SELECT preferredDC,preferredDCAID,Domain,defaultOU,defaultgroups,emailformat,emaildomain,logonformat FROM CustomerPortal.clientVars where AutomateID=12 using DSN=xxxxxx; DOES NOT WORK Any ideas?
  8. Joe Lusk

    Looking for Active Directory plugin to create users

    Did you ever find anything?
  9. Joe Lusk

    Email the initiating tech script stats and results

    @DarrenWhite99 I agree and prefer re-usable function scripts wherever possible. I am relatively new to Labtech scripting so I may have gone over some already trodden ground. That being said, this is part of a bigger function script that I have made and add to all of my scripts. I just felt the variable set was the most useful part for others, and since I couldn't find it anywhere else I thought someone else might find it useful too. Thanks for all of your contributions here, I have found them invaluable to my crash course in Labtech(Automate) scripting.
  10. Joe Lusk

    Email the initiating tech script stats and results

    I have looked and I can't find it either. Though I am not sure how much easier it can be then 2 lines; 1 to pull the email address, 2 to send the email 🙂
  11. I added this little line and it has helped me tremendously. It allows the script to automatically email whoever kicked it off, not just a static email address. Since we have 30+ techs and close to 6000 agents, this is very useful. Function: Variable Set Set Type: SQL Query Parameter: select email from users where name ='@LTRUNBYUSER@' Variable Name: initiatoremail Then I use the send email function to email the @initiatoremail@ that the script has begun; including @script name@ variable (which I set) %clientname% and %computername%. Then again at various failure points, including other variables that provide a description of where it failed in the script. Lastly it sends an email upon success. This way when I kick the script off for a bunch of computers, I can track the state of each of them easily. I set up rules in my email client to sort them into folders by success/ failure etc. Maybe there was an easier way to do this, but I never found it. 🙂
  12. Joe Lusk

    Sophos Removal Script

    or just run sepprep.exe