Jump to content

Axle

Members
  • Content Count

    9
  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Location
    Australlia
  • Agent Count
    1000 - 1500 Agents
  1. Axle

    Script help - SQL get value

    Hi, Got around to working out a better way to do this. Updated script: SELECT IFNULL( (SELECT LEFT(`subject`,250) AS `Ticket Subject` FROM tickets WHERE computerid = '%computerid%' AND starteddate > ADDDATE(NOW(), -3) AND NOT `subject` LIKE 'LTVM uest%' AND NOT `subject` LIKE '%success%' GROUP BY `Ticket Subject` HAVING COUNT(*) > '350' LIMIT 1), '0') AS `Ticket Subject`; Follow that with an IF @sqlresult@ = 0 THEN jump to :exitscript So far 100% success rate. Cheers, Axle
  2. Axle

    Script help - SQL get value

    Hi All, If anyone finds this having the same problem the issue was that when there were less then 350 tickets it would return an empty dataset and that seems to break the script. If it returns any details because there are more then 350 tickets then it will work successfully. If I find a better way of doing this I will update this post. Cheers, Axle
  3. Hi All, Hoping that someone can point me in the right direction for this one. This is the current script: SELECT LEFT(t.SUBJECT,250) AS `Ticket Subject` FROM tickets t JOIN computers c ON c.computerid=t.computerid WHERE c.computerid = '%computerid%' AND TIMEDIFF(t.starteddate, NOW()) < '72:00:00' AND NOT t.subject LIKE 'LTVM Guest%' AND NOT t.subject LIKE '%success%' GROUP BY `Ticket Subject` HAVING COUNT(*) > '350' This script was setup by the old admin that is no longer with the company. I was having a look into it because it seemed to be logging false positives and found that the section <TIMEDIFF(t.starteddate, NOW())> is actually finding a negative value so it wasn't working as intended. I updated it to <TIMEDIFF(NOW(), t.starteddate) < '72:00:00'> and that broke the script. I also tried <TIMEDIFF(t.starteddate, NOW()) > '-72:00:00> and <starteddate > DATE_SUB(NOW(), INTERVAL 72 HOUR)> but the script is still failing at that line. All 3 options above run correctly when running them against the DB myself so im at a loss to why they are failing in the script. I attempted to simplify it by changing the whole script to this: SELECT LEFT(`subject`,250) AS `Ticket Subject` FROM tickets WHERE computerid = '%computerid%' AND starteddate > DATE_SUB(NOW(), INTERVAL 72 HOUR) AND NOT `subject` LIKE 'LTVM Guest%' AND NOT `subject` LIKE '%success%' GROUP BY `Ticket Subject` HAVING COUNT(*) > '350' But that also failed in the script despite working in mysql. Has anyone had this happen before? Any ideas where I am going wrong? edit: if it matters, still on v11 patch 19. Any help is appreciated. Cheers, Axle
  4. Thanks @DarrenWhite99 I have a call with Labtech support later this week so I'll be sure to bring that up.
  5. @MetaMSP Yep I am already having that talk with our account manager and trying (unsuccessfully so far) to spin it as a positive for them. I want to have Automate, Manage and Control all behind a load balancer. I have done plenty of Master/Slave on unix but not windows, but unix is another thing that is in no way supported unfortunately. vMotion is already configured but it doesn't help for patching downtime. @DarrenWhite99 we are just off 10,000 currently. 8 CPU's, 36GB RAM, HDD are all on enterprise grade SSD storage with unlimited IOPs.
  6. Hi, I am currently looking for a way to make our Labtech instance more robust and ensure up-time as we are now using it on a 24/7/365 basis. I am currently looking to build out a new environment where the Labtech service is split out over 2-3 servers to try an improve the performance but it doesn't really help with up-time as if I need to patch one of them it will still take everything down. Does anyone have a current setup that has any redundancy built into it? Ideally I would like to have the Database in a clustered environment and then 2 front end servers (App/IIS) behind a load balancer. I have been in contact with Support and our account manager only to be told that there is no support for this and haven't had much luck finding any recent posts here or any other site for people running a High Availability setup. Fortunately I have access to a test environment so if you don't have anything currently setup but have some good ideas to do this let me know and I will add it to the list of things I want to try. Cheers, Axle
  7. @eburger If you are still after an answer, I asked my Account manager this last week and the reply back was that there is no support at all. No just for the database but as a whole.
×