Forums

Forum Post: Re: Make alarm monitoring respect hours of ServiceDesk

Paul Haaker — Fri, 24 May 2013 22:49:00 GMT

OK .. So here's a start

For each Organization in System/ORS/Manage you can set an Org Type

There are already some default ones setup I.e. SLA_Gold , SLA_Silver etc and you can create and add extra ones if needed

ALSO in SD you can define Policies and again there are some defaults already there , also SLA_Gold , SLA_Silver

I can't see if there is any automated link between creating an ORG based Type and an SD Policy .. but the trick here is to create them in both and make sure the names are identical

So once done you have got a SD Policy that defines the hrs , and an Org Type that allows you to assign the Type to Organizations and therefore machines

Now the following SQL query will return the details of SD Coverage for every machine in your system as long as the Policy and Type names have been assigned and match

*****************************************

SELECT     kasadmin.SDPolicy.ref, kasadmin.SDHours.ref AS SLACoverage, kasadmin.SDHours.rowDesc, kasadmin.vbo_Organizations_General.ref AS Organization, 
                      dbo.vMachine.agentGuid, dbo.vMachine.machName
FROM         kasadmin.SDPolicy INNER JOIN
                      kasadmin.SDHours ON kasadmin.SDPolicy.sdHoursFK = kasadmin.SDHours.id INNER JOIN
                      kasadmin.vbo_Organizations_General ON kasadmin.SDPolicy.ref = kasadmin.vbo_Organizations_General.org_type INNER JOIN
                      kasadmin.organization ON kasadmin.vbo_Organizations_General.id = kasadmin.organization.id INNER JOIN
                      dbo.machGroup ON kasadmin.organization.orgFK = dbo.machGroup.orgFK INNER JOIN
                      dbo.vMachine ON dbo.machGroup.reverseName = dbo.vMachine.groupName

**************************************

So with this you can change the query to use within a Agent Procedure , have the query return just the SLACoverage value and then within your Script you could pass the result to some VB or other code to determine if the current date/time is within the SLA Covered period

I'll leave the rest up to you .. but drop me a note if you get stuck

You'll still need to work into this Public holidays etc which is also defined within SD in the table [ksubscribers].[kasadmin].[vbo_SDHoursCovered_Holiday]

So this would probably be a second query in the same script

Cheers

Paul

Forum Post: Mail Server QOS - Best Practices

Kerry D — Fri, 24 May 2013 22:03:00 GMT

Hey Everyone,

Been running into some Mail QOS issues and looking for some feedback on how others are using it - and to discuss any best practices, if they exist.

I had Mail Server QOS monitors set up and working OK in VSA-integrated KNM 4.1. We set up unique accounts at Gmail and on our client's local servers to test mail flow in either direction - in other words, with Google as SMTP to our local POP, and with local SMTP to Google POP. This way, mail flow was tested in both directions and it included our entire mail loop:

Mail from Google Account -> through Barracuda Cloud Protection Layer -> to Barracuda device -> to local Exchange/ POP server. We called this "Mail QOS Inbound."
Mail from Exchange/ local server -> out through Barracuda smart host or using DNS MX records -> to Google servers for POP pickup. We called this "Mail QOS Outbound."

With this setup, it was actually pretty noisy as there seemed to always be a delay or an empty mailbox that would alarm the KNM monitor. I can't claim to have fully realized my dream of reliable end-to-end mail flow monitoring, as there was just too much noise. But the idea is extremely promising and a great thing to communicate to a client.

However, I've upgraded to KNM 5 standalone and I am having a ton of trouble with mail server authentication and relay. Even though I authenticate SMTP with a Gmail account to Google, it doesn't like my local email address and won't relay messages. I'm having a lot of the same difficulty with local server relay to Google.

Our credentials are set correctly and authentication appears to work but some piece of the mechanism isn't working as easily as it used to. Having said all that, my questions are as follows:

How are other people using Mail Server QOS monitors? Inbound? Outbound? Are you using this monitor at all?
Are you using Gmail or another hosted mail service? (Or do you have your own server somewhere else?)
We want to test the whole mail loop - is this the way it is supposed to be configured? I find less value in using the same mail server for SMTP and POP.
Has anyone successfully gotten the situation I described above to work with Google and their local server?

Happy to open a support ticket to resolve the authentication and relay issues if I need to, but I don't see many involved Mail QOS discussions in the forum and I am really curious to hear what others are up to.

Appreciate your time and feedback!

Thanks,

Kerry

Forum Post: Re: Make some ticket notes become a KB article

Paul Haaker — Fri, 24 May 2013 20:32:00 GMT

Or automate if as per this thread

community.kaseya.com/.../85840.aspx

Forum Post: Re: Uninstall previous Kaseya agent and replace with current agent?

Paul Haaker — Fri, 24 May 2013 20:30:00 GMT

Just write a script that your agent will run to remove the other agent.

If you look in Kaseya under Audit/Add/Remove via your VSA you will see both agents listed , and it includes the string you need to run to uninstall.

So pick the string for the other agent , add this into your script , and run on all affected machines.

This will only uninstall the other agent .. and you can check it's has worked by rerunning the audit and checking again what is listed in Add/Remove

Cheers

Forum Post: Re: Moving a ticket from one desk to another

Paul Haaker — Fri, 24 May 2013 20:14:00 GMT

Oh .. I'm assuming you are using SD 1.4 and Kaseya V6.3 ?

Forum Post: IP management

smwein — Fri, 24 May 2013 19:27:00 GMT

Can someone help me? I'm trying to create a script or report that will pull all the IPs on a machine. I can run reports that pull the man IP but not the secondary IPs.

Thanks for the help.

Steven

Forum Post: Alert times are off

Gino Tomasetti — Fri, 24 May 2013 19:27:00 GMT

Hello All,

Our office is in the Boston area, EST is our time zone. Our SaaS Kaseya server must be in the UK or something, we have to set our System time to VSA server -4 hours.

Please see the screen shot. When a monitored server first goes down, let's say at 4:30 PM, we get an alert saying that the agent hasn't checked in since 8:30 PM, which of course is 4 hours into the future, that's impossible.

When we go into the format email area, the time it reports is <qt> which is UTC time. Is there a way to make it read QT minus 4 hours?

thanks

Forum Post: Re: Windows Disk Cleanup or CCLEANER

NIKNAKS456 — Fri, 24 May 2013 19:13:00 GMT

please share

Forum Post: Re: cscript problem on windows 7 64 bit

SMason — Fri, 24 May 2013 17:54:00 GMT

All of this is expected behavior for the x64 architecture and isn't necessarily any wrongdoing on Kaseya's part.

Forum Post: Some questions regarding KNM 5.0

Terry Lam — Fri, 24 May 2013 16:50:00 GMT

Hi,

I would like to know the following information:

1. Does gateway has a network traffic optimization ability?

2. Minimum bandwidth requirement for the connection between gateway and server?

3. How does the gateway connection work in the WAN connection that has WAN optimizer in between? Can WAN optimizer recognized gateway communication protocol and compress the communication channel of the gateway?

4. Any full list of hardware and OS support matrix for the monitor template?

5. I find that the Windows monitor template retrieves event id of Windows 2003 or below only. Is there any regular update of the templates? or should it be modified by customer?

6. How can KNM monitor the space utilization of VMWare data store by using CIM? Seems CIM is very complicated, and need strong development skill to understand and create a CIM monitor script. Is there any template or script that can scan the available data store, then we just select the ones we wants to monitor?

7. Could you provide me some attractive dashboard screen shots?

Thanks & Regards

Terry

Forum Post: Re: KES scan failures after 2 seconds. ErrorRegistryScan

Timothy Smith — Fri, 24 May 2013 15:57:00 GMT

Is this applicable to AVG 9 or just 2012?

Forum Post: Alert After Multiple Patch Failure

eperson — Fri, 24 May 2013 15:45:00 GMT

I am currently having a problem with patch failures and I wanted to reach out to the community to see if anyone else has addressed the same problem.

I have found that in the majority of cases, when I receive an alert for a patch failure, if I check again after the next attempt, the patch has installed without issue. To cut down on ticket noise, I am trying to find the best way to send an alert only after a patch has failed on more than one attempt.

My first thought was to simply create a view of machines with failed patches, then on the day after most machines would have run the second attempt at patch installation, run a script against all machines in the view to create an email to our ticketing system. I can't do this because it doesn't seem possible to create views on machines with failed patches.

Has anyone else had the same problem? How have you addressed it?

Thanks in advance.

Forum Post: AVG 9 Removal Succeeds - AVG 2012 Install Fails - Succeeds When Restarted

eperson — Fri, 24 May 2013 15:37:00 GMT

I opened support ticket, but I wanted to see if anyone else had seen this issue and had any suggestions on a resolution.

I am having a problem when updating machines from AVG 9 to AVG 2012. Until this past weekend (5/18) the majority installs completed without issue. Since 5/18, every time I have scheduled an upgrade overnight, the removal of AVG 9 completes, but the install of AVG 2012 fails. The error message is (with different time stamps) "FAILED at 1:06:09 AM 24-May-13 (AVG did not start properly)". In every case, I then run the installation process of AVG 2012 and the install succeeds without issue.

Has anyone else seen this problem?

Thanks in advance.

Forum Post: Re: Does Uninstalling Kaseya Agent uninstall AVG?

Elliot Tabush — Fri, 24 May 2013 15:17:00 GMT

But you get the partial KES license back even if you dont uninstall AVG.

Forum Post: Re: vmware esxi 5 datastore monitoring

El Sarner — Fri, 24 May 2013 13:23:00 GMT

Hi Tomas

have the problem with this script with the login

Have deleted getaccountuser , nada no authentication.

Thank you

Forum Post: Re: KLC 6.3 - Mac OS X / X11VNC

Dylan M. Lagi — Fri, 24 May 2013 13:20:00 GMT

@xreeee - You have a ticket for this yet? If not, fire it up, let me know the ticket # and we will review, thx.

Forum Post: Re: SYM BE 1.1 Reports / Alarms

Sander Rozemuller — Fri, 24 May 2013 11:02:00 GMT

Hello,

Main tasks are:

Create a sql view

create a xml file like the one attached in the topic.

Place the xml in the following dir: Kaseya\xml\Reporting\DataSetRegistration\1\Monitoring

Push the run registration button at change reporting config

Take a look in Info Center at report parts you wil see the part you've created.

Forum Post: Re: View all machines for an organization

Tjibbe Buijsman — Fri, 24 May 2013 09:36:00 GMT

You should be able to select the organisation itself instead of the machine group. When the organisation is selected you can view all the machines in it.

If this is not an option, possibly you can create a view and share this view.

Forum Post: Re: Dependency monitors within object

RA — Fri, 24 May 2013 06:39:00 GMT

The same function is there in v5, called dependency setting in the property page of both group and device. There is a slight change in the algorithm in v5 to make this feature less expensive in terms of cpu cycles, so make sure the dependency monitor tests faster with lower alarm count.

@will no way to script this yet, but stay tuned.

Forum Post: Re: Block Installation of IE 10 for some users

HardKnoX — Fri, 24 May 2013 03:08:00 GMT

Here is some history on this issue with IE 9 community.kaseya.com/.../60214.aspx

Since the issue with IE9 I have opted to use the "KB Override" under patch management and the registry modification in the "Toolkit to Disable Automatic Delivery of Internet Explorer". This means Kaseya Automatic Update, WSUS and Windows updates can't install IE 10 and you can still patch IE 10 and deployed it manually or by a custom agent procedure.