Content Count

Joined

Last visited

Community Reputation

My Information

@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?

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?

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

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

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?

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

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