Scripts & Agent Procedures - Recent Threads

KSD script executeShellCommand not returning OutputVariable

Greg Johncock — Fri, 17 May 2013 00:02:37 GMT

In a KSD 6.3, I have the following commands in a Stage Entry procedure:

executeShellCommand(“get-current-time”, “Continue On Fail”)

addNote(“-- Select --“, “currenttime variable = ~[=currenttime=]~”, false, “Continue on Fail”)

get-current-time.xml contains this:

<?xml version="1.0" encoding="utf-8" ?>

</shellCommandList>

Output variable should be something like: 17-05-2013 9:55:07 (this is the contents of the log file).

The correct time output is written to the log file (c:\temp\fromcmd.log) so I presume the command is working, however the note only contains:

currenttime variable = ~~

The ~ placeholders are only there to show nothing is returned, it returns the nothing in the variable if the ~ is absent from the note text.

Any help would be greatly appreciated.

Regards

Greg Johncock

Delete registry key step command doesn't work

andrewf — Wed, 15 May 2013 16:01:56 GMT

I have a procedure that checks for the existence of a key then deletes it. I ran the procedure and it claims to have completed with no problems. Now when I run it again, it says the key is not found, which I would assume to be correct. However, when I logged into the server and checked the registry manually, I found the key still there and had to delete it manually. What's the deal?

Notification when a script fails

Austin — Tue, 14 May 2013 20:02:37 GMT

I have an FTP script running on a server to facilitate the transfer of files to another server. I built a procedure in IRP that starts the batch script on the server. But what I would like to do is setup another step in the procedure to check the folder after the batch script completes to look for any remaining files, and then send me an email that the file transfer failed.

I currently have that in the procedure but it's not working. I believe it's because of the wildcard in the "testFile" step:

impersonateUser

executeFile (executes the batch script on the server)

pauseProcedure

If testFile (%systemdrive%\folder containing files\*.HL7) exists

sendEmail (sends an email saying the transfer was incomplete because there is still data in the folder)

Else

sendEmail (sends an email saying the transfer completed successfully)

Any help with this would be greatly appreciated.

[ASK] How do I configure for alerts by sms

Avanty — Tue, 14 May 2013 09:57:28 GMT

This time I wanna ask u how to make alert if user was uninstall kaseya agent in the computer and Administration got the notification by email and sms. How to configure it. Thanks

Issues with PowerShell in agent procedure

andrewf — Mon, 13 May 2013 21:33:55 GMT

I'm creating a procedure to check for the existence of a registry key then email me the directory contents. I'm having an issue with Powershell hanging with the below log:

5:20:09 pm 13-May-13	Execute Powershell Command-1-1-3-Then.7	Not sending output to variable.	afila
5:20:09 pm 13-May-13	Execute Powershell Command-1-1-2-Then.7	Commands are: dir HKLM:\Software\Appassure\ReplayEPS > c:\kworking\ReplayAgents.txt	afila
5:20:09 pm 13-May-13	Execute Powershell Command-1-1-2-Then.7	No arguments specified or arguments not formatted properly.	afila
5:20:08 pm 13-May-13	Execute Powershell Command-1-1	Poweshell is present.

?xml

Web Services API Authentication Request Syntax

Carlos — Sun, 12 May 2013 05:30:08 GMT

Below is a sample request to authenticate with my kaseya server with SOAP. Can someone please respond back with the exact syntax that I should put in where the word string is? Obviously you don't know my actual values but if you could make up an email address for the username, a strong password for the password, and a IP. Also I will use SHA-256.

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /vsaWS/kaseyaws.asmx HTTP/1.1
Host: my.kaseyaserver.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <Authenticate xmlns="KaseyaWS">
      <req>
        <UserName>string</UserName>
        <CoveredPassword>string</CoveredPassword>
        <RandomNumber>string</RandomNumber>
        <BrowserIP>string</BrowserIP>
        <HashingAlgorithm>string</HashingAlgorithm>
      </req>
    </Authenticate>
  </soap12:Body>
</soap12:Envelope>

Sharing My Terminal Server Logoff Script

PHOPJPC — Thu, 09 May 2013 13:04:49 GMT

I made a script to log off terminal server users. You just need to put the Session ID in there. Which you can find in the Task Manger Users column and it will log off that user

Script Help/Request

Chris.Soska — Thu, 09 May 2013 12:29:08 GMT

I'm trying to come up with a script to assist with a very specific backup procedure. As part of the backup, I need to make a copy of a program directory, compress it and title it with the date of the backup.

I know I can Zip a directory using the Zip Directory function. But is there a way I can use a Get Variable to get the current date for the Zip name?

I wouldn't even be opposed to using a generic file name for the backup, for example (current.zip) and a DOS REN to change the name of the .zip when complete.

Running Lua scripts on Agents

Matthew Murphy — Wed, 08 May 2013 22:33:17 GMT

I am interested in being able to run Lua scripts on my agents and was wondering the best way to approach this. Right now, none of our agents have KAM (and we use KES instead of KAV). We will be adding it to all our workstations relatively soon, but we will not be installing it on servers.

I was planning to install Lua for Windows with an agent procedure but I'm not sure if this is the best option. When I installed Lua for Windows on my home computer (with all defaults) it caused a conflict with a video game I was playing at the time. My coworker mentioned that we may be able to take the Lua installation code out of the KAM installation, which sounds tedious.

Any thoughts on how I should get Lua installed on these machines?

Useful script for process restarts and monitoring

Shane Goldsby — Tue, 07 May 2013 20:44:46 GMT

I wrote this today to use in a specific scenario. I had 9 processes to monitor and report on. Decided it would be customizable to scale infinitely with any number of processes. When i was at Kaseya connect i had a few people ask if i had considered sharing some of my solutions. It never occurred to me until now. Anyway, heres the one i built today.

MAC Maintenance Scripts

Elliot Tabush — Tue, 07 May 2013 20:34:19 GMT

Kaseya posted some MAC maintenance scripts in the System folder. I dont know that much about mac scripting. Are these harmless to run on a regular basis? Will it affect the end user while running?

What the script does is:

Remove user cached files
Remove system Caches
Rebuilds Dyld cache (helps spinning wheel issues)
Verifies Disk
Repairs Disk
Repairs Disk Permissions on OS Volume

SQL query not working

F.A.N. van den Berg — Tue, 07 May 2013 06:25:39 GMT

Hi all,

I’m struggling with an sql statement that will not return a value.

I would like to make life a bit more easy by creating a script to set the SubmitterName & SubmitterEmail values in manually created tickets with the value from the selected organization.

I asked this in a ticket to Kaseya support, but they state that this is not supported

What I have done so far:

Add some new code to the “Stage Entry or Exit”:

getVariable(“Mail_Submitter”, “Constant Value”, “”, “Continue on Fail”)

executeSQLQuery(“Copy_Mail_Submitter”, “Mail_Submitter”, “Continue on Fail”)

addNote(“—Select--”, “Mailadres: [=Mail_Submitter=]”, false, “Continue on Fail”)

The SQL Query called upon contains:

I can do the same query on the database itself, but in the procedure I get no result.

Am I goofing up some ware?

Help with Baseline/Latest Audits - They Keep Failing

Gaven — Tue, 07 May 2013 05:13:17 GMT

recently Kaseya moved my server to another host since they are no longer providing hosting. They patched me from 6.2 to 6.3.

Ever since then none of the audits work. I get this:

Latest Audit	11:53:13 pm 6-May-13	Failed THEN in step 1	SYSTEM
Baseline Audit	11:51:32 pm 6-May-13	Failed THEN in step 3	SYSTEM
Retry - Baseline Audit...	11:42:10 pm 6-May-13	Failed THEN in step 1	SYSTEM
Retry - Baseline Audit...	11:41:49 pm 6-May-13	Failed THEN in step 1	SYSTEM
Retry - Latest Audit 7...	11:03:32 pm 6-May-13	Failed THEN in step 1	SYSTEM
Retry - Latest Audit 7...	11:03:13 pm 6-May-13	Failed THEN in step 1	SYSTEM

I don't know how to fix this. Does anyone know how? Kaseya said my server is fully patched...

Help with Checkdisk Script

noclav — Mon, 06 May 2013 18:19:30 GMT

I found this script somewhere (Thanks to whomever created it) online trying to get this to work with ITCenter and keep getting errors.

Failed THEN in step 7 (Line 9)

Failed THEN in step 1 (Line 10)

Failed ELSE in step 5 (Line 36)

Failed THEN in step 3 (Line 41)

I dont know the kaseya scripting really well so any help will be appreciated.

</Statement>

<Parameter xsi:type="StringParameter" name="Command" value="date /T >> #vAgentConfiguration.agentTempDir#\date.txt"/>

</Statement>

</Statement>

<Parameter xsi:type="StringParameter" name="Command" value="chkdsk C: >> c:\temp\chkdsk_report.txt"/>

</Statement>

</Statement>

</Statement>

</Condition>

<Then>

</Condition>

<Then>

</Statement>

</Statement>

</Statement>

</Statement>

</Condition>

<Then>

</Statement>

</Statement>

</Statement>

</Then>

<Else>

</Statement>

</Statement>

</Statement>

</Statement>

</Statement>

</Else>

</If>

</Statement>

</Then>

<Else>

</Statement>

</Statement>

</Statement>

</Statement>

</Condition>

<Then>

</Statement>

</Statement>

</Statement>

</Then>

<Else>

</Statement>

</Statement>

</Statement>

</Statement>

</Statement>

</Statement>

</Else>

</If>

</Else>

</If>

</Then>

<Else>

</Statement>

</Statement>

</Statement>

</Statement>

</Else>

</If>

</Body>

</Procedure>

</ScriptExport>

How to get USB Serial Number

Avanty — Thu, 02 May 2013 04:14:34 GMT

I want to ask how to get USB serial number I already make it but it is stiil failed I don't know how to fix it

</Statement>

</Condition>

<Then>

</Statement>

</Then>

<Else>

</Statement>

</Else>

</If>

</Body>

</Procedure>

</ScriptExport>

Using Ninite Pro to install updates only across many small LANs and/or on-the-road notebooks

stream_gpk — Tue, 30 Apr 2013 19:44:21 GMT

Hi,

We manage quite a few small LANs, not all of which have a dedicated server. Also, we have some users who's notebooks almost never touch their LAN, they are always on the road. So to create a Ninite LAN cache isn't the most practical. What I'd like to accomplish is an Agent Procedure which downloads the NiniteOne.exe from our system server to the local PC, then runs a silent /updatesonly locally.

While that seems simple when I write it out, my brain just cannot get into how to script that in Kaseya. If you have a script that does this or something similar, or if you have solved this same challenge another way, could you share your approach?

- Greg

rkill

rdk@waslet.be — Fri, 26 Apr 2013 11:17:55 GMT

Hi,

Is anybody having a script to silently run rkill.com ?

rgds

Get date/time of next automatic update

ghanssen — Thu, 25 Apr 2013 18:15:38 GMT

What I am trying to do is when an a server agent sends a notification of "new patches available" then a script would run and grab the currently scheduled date of the next Automatic Update (patch management) and send an email to the client POC letting them know that server maintenance will be taking place at that time.

Since this date is in Kaseya it must be in SQL somewhere, but I don't know how to get it.

Is anyone able to help me here?

Install KES or KAM from agent procedure?

The Karl — Wed, 24 Apr 2013 16:12:03 GMT

i was dissappointed that i wasn't able to push out KES or KAM using the new kaseya policies, so i'm wondering if there's a way anyone has figured out to do it through agent procedures. check for file, if does not exist, then install... that sorta thing

we asked kaseya support,but they always say 'no' to any question i ask them. if i push back, they'll almost always come back with a way of doing what i'm looking for. Kaseya support is certainly the weak link in the chain. anyway, anyone figured out a way to push out KAM or KES through agent procedures in Kaseya 6.3?

Procedure to get installed patches per date.

Erik Dekker — Wed, 24 Apr 2013 08:25:58 GMT

Im not familiar with sql and working my way through it.

As a simple thinking person i want to run a procedure that looks with a sql data view in the vPatchStatus/InstallDate to retrieve hte installed sec patches on the machines the procedure runs on.

But i get the famous error FAILED in processing THEN step 1, Get Variable, with error SQL query failed to return data in GetVariable task, SELECT InstallDate FROM vPatchStatus

What do i miss, because when i look in the rows on the sql server, i see a lot of entries.

Probably i`m thinking to simple to it, but it would be nice to send a collection of the installed update with a email.

Erik

Script to test RAID health?

Elliot Tabush — Tue, 23 Apr 2013 19:54:25 GMT

Does anyone have script that will report back RAID health of a server? (Script to work for Dell and HP)

We have active monitoring but always good to have this monthly check in case anything was missed.

SQL Script: Top Event Log Reporters, Source, Number of Events

Kerry D — Tue, 23 Apr 2013 17:16:21 GMT

I've found this little SQL script to be particularly useful in identifying which agents are sending in excessive amounts of Windows Event Logs. You'll want to adjust the date and run the query against your ksubscribers database in SQL Server Management Studio.

I couldn't find it posted anywhere in the forums so thought I would share.

SELECT m.displayName,a.source,count(a.agentGuid) from
ntEventLog20130423 a LEFT OUTER JOIN machNameTab m ON
a.agentGuid = m.agentGuid WHERE a.eventTime > DATEADD(hour, -1, CURRENT_TIMESTAMP)
GROUP BY a.agentGuid, m.displayName,a.source
HAVING COUNT(a.agentGuid) > 100
ORDER BY count(a.agentGuid) desc

On that note, anyone have other SQL gems they find valuable?

get Variable Universal Create

Erik Dekker — Mon, 22 Apr 2013 11:26:24 GMT

Hi,

I cannot figure out how to use the universal create and read variable.

This is my situation:

I have a custom field called vSystemInfoManual/BranchDBserial.

With a getvar sql view data i retrieve the numer that is in this field and i use it further on to copy and create zip files and then tranfer them to another agent.

On this agent i run with another scheduled procedure a simple batch file to unzip the files and then copy them to the designated directory.

This works so far so good, but sometimes when the transfer or unzip or copy action doesn`t work i want to do the following.

I want to use the getvar i get earlyer in a scheduled procedure at the end and use the get Variable Universal Create and get Variable Universal Read.

So bottom line is, how to get the universal create and read variable to work properly

Continue on fail for Execute Procedure not working (VSA 6.2)

HardKnoX — Fri, 19 Apr 2013 03:01:26 GMT

Has anybody else noticed that the "Continue on fail" for Execute Procedure lines are not working?

I expect the main procedure to continue with the next line if the sub procedure is configured for "Continue on fail" but have found at least 2 procedures now where this is no longer working for any sub procedures. I will try and schedule the sub procedures instead and see if that makes any difference.

(Question:Have I logged a ticket for this? Answer: hellz no!!!)

Script to check Windows Activation status

Elliot Tabush — Wed, 17 Apr 2013 21:39:04 GMT

Trying to write a script (eventually turn into a report) that shows me if any computers are not activated. I found a command that will display activation info --> slmgr /dli

but the command wont let me export this to text file. If i could export to text file i can just parse it for "License Status: Licensed"

Any tips?

procedure for desktop backup, then deploy image, then restore?

JamesB — Wed, 17 Apr 2013 17:24:02 GMT

Hello,

We are working on re imaging all of our xp machines to windows 7(200+ systems) I am looking for a script to schedule a kaseya desktop migration backup, then when finished deploy an image, then when finished run a desktop migration restore. Has anyone been in this situation before? How would you go about completing this task?

Thank you for your help.

[Solved] Using Agent Procedure to Update Custom Field?

matts — Mon, 15 Apr 2013 19:34:37 GMT

Is it possible to update a custom field through an agent procedure?

Here is the overall problem. Right now I have 16 scheduled procedures which check for the existence of individual files (not .exe files). If a file exists, the procedure succeeds, otherwise it fails. Then I have 16 views which show machines where the procedure succeeded. One solution to combine all 16 procedures into a single one would be write a .exe file, which the views could then use to check the existence of. However, I have read on here that views that utilize the existence of executables are processor intensive, so I'd prefer not to do that. What I would like to do is combine all 16 procedures into a single one where there are 16 cases, each one updating a custom field - which I could then reference in the Views.

Why does execute shell command not work?

andrewf — Mon, 15 Apr 2013 18:47:23 GMT

I'm trying to create an extremely simple procedure to run a .bat file which works when I run it locally but not through a procedure. The bat file even executes if I use command prompt though Live Connect.

error in script

noclav — Sat, 13 Apr 2013 13:27:51 GMT

I am trying to run Bens Adobe Reader 10 Script on ITCENTER and get it to work so i can modify it for adobe reader 11. When i run this script it errors out with this message

FAILED in processing IF step, Check Variable, with error Script variable is undefined. It must be defined by a GetVariable step earlier in this script or a parent script. (Line 72)

The variable its complaining about is #vpatchconfiguration.FileSourceMachineId# i thought this is a global variable. Anyone know how to get this to work with ITCenter.

IE10 downgrade script

Elliot Tabush — Thu, 11 Apr 2013 18:59:19 GMT

Does anyone have a working script to downgrade from IE10 to IE9.

We had that patch approved and then noticed all the problems people have with IE10. By the time i blocked it most computers were upgraded.

How to get serial number

Avanty — Tue, 09 Apr 2013 07:39:17 GMT

How to make agent procedure check the serial number ? from audit?

Use other Machine.GroupID in a procedure.

Erik Dekker — Mon, 08 Apr 2013 11:34:20 GMT

I have the following situation.

I created a procedure that copies a file, than zips it.

This is happening on 20 machines, no i want to copy this zip file to a another machine out of the goup where the files are copied..

How can i create the variable to copy the created zip to the designated machine.

Script after Upgrade

Matt_Tate — Fri, 05 Apr 2013 07:20:40 GMT

Hi all,

we are yet to upgrade to V6 still on V5.1.0.0

just wondering what affects if any the upgrade will have on scripts? we have a number but we have one very important one that we cant afford to have to rewrite. does V6 affect scripts in anyway or would my old ones work fine?

Elevated Command Prompt Script?

PHOPJPC — Thu, 04 Apr 2013 14:44:54 GMT

Hey everyone,
I been searching the web for a script to run an elevated command prompt as an administrator. Does anyone know how to do this. The reason I'm asking is I have a script to uninstall IE10 but it needs to be ran as an administrator. Not like a domain administrator or local administrator . Any answers or thoughts will be well apperciated.

Thanks,
Pat

Error running batch file - No mapping between user accounts...

scottay — Thu, 04 Apr 2013 04:33:11 GMT

I tried posting this in the Agent forum and haven't gotten a reply - perhaps this is a better section for my problem? Sorry for the duplicate post, I really need help on this...

This is an issue that cropped up for me with the new 6.3 update. I'm trying to run a batch file that creates the Scheduled Task to allow CCleaner to run without UAC:

schtasks /CREATE /TN CCleanerSkipUAC /TR "c:\rcs\cc\CCleaner.exe $(Arg0)" /SC ONCE /ST 12:00 /RL HIGHEST /F

I can run the batch file just fine manually, but when I run as system (and redirect errors to a text file) with an agent procedure I get this error:

ERROR: No mapping between account names and security IDs was done.
(16,8):UserId: