Jump to content
[[Template core/front/profile/profileHeader is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

Community Reputation

0 Neutral

My Information

  • Agent Count
  1. Hello All, Does anybody know the 'Additional Where' parameter to get the dataviews within Custom Tabs to only show that client's results? I've tried 'Clients.Name = '%clientname%' and various other queries but I'm very new to SQL Any help would be appreciated! The Custom Tab is on the Device field Thank you
  2. Hi Guys, I'm wondering if anyone has found a way (Or if it's even possible) to have a script automatically fill in the 'Deployments & Defaults' password for the 'Login to use for Administrative Access' At the moment, we have a script that creates a domain administrator on every DC Server, with a random password. This script then updates the password weekly and then stores the password in an EDF on the device. I'm wondering if anyone knows of a way to have a script (or the same script) automatically update the Deployments & Defaults Password with this Account? Or even add it to the Passwords tab so that it's a selectable option
  3. Hi OffSite, Thanks for the response.. Are you confident that those are all of the failure codes from server 2008 - 2012/2016? I'm finding that no matter what we monitor, there is always something not quite right.. How did you add the Crimson Logs to LT? Did you use a Template or the Registry?
  4. We're currently in a position whereby we're migrating away from Windows Server Backup onto Acronis Backup Cloud, The problem that we're facing at the moment is that we have a number of customers who are still using Windows Server Backup and we have no native method of monitoring this inside Labtech.. At the moment we've tried to use a Powershell Script to export the last backup result to the registry and then monitor the registry key for a lack of success code, which has been hit and miss as Windows Server Backup requires that the 'Command Line Tools'' be installed from Server Manager, and it also doesn't account for if a schedule was stopped after a last backup completed succesfully. Does anybody have any consistent monitors/ideas for monitoring Windows Backups even under the circumstances that a schedule may be stopped etc?
  5. Hello All, My goal is to create a monitor to look for the 'Backup Not Installed' view in Labtech's Backup Manager to create a Ticket every day so that we may manually check the Backup Status. I've run the SQL Spy whilst opening the 'Backup Not Installed' view and it has given me the following SQL Code: EDTSelect Computers.ComputerId,IFNULL(TempA.LtJobId, '') as `LastBackupJobId`,`clients`.`Name` as `Client`,`locations`.`Name` as `Location`,IF(v_extradatacomputers.friendlyname = '', IFNULL(computers.name, ''), v_extradatacomputers.friendlyname) as `Computer Name`,IFNULL(TempC.Value, '') as `Backup Solution Installed`,IFNULL(l_backupjobstatus.statusname, '') as `Last Backup Status`,IFNULL(TempA.starttime, '') as `Last Backup Time`,IFNULL(TempB.Count, 0) as `Job Fails (In Last 7 Days)`,IFNULL(TempD.Count, 0) as `Warning Logs (In Last 7 Days)`, Computers.ComputerId as `Hidden_ComputerID` FROM computers LEFT JOIN clients ON computers.clientid = clients.clientid LEFT JOIN `v_extradatacomputers` ON computers.computerid = `v_extradatacomputers`.computerid LEFT JOIN locations ON computers.locationid = locations.locationid LEFT JOIN (SELECT backupsolutioninfo.ComputerId, PluginGUID, `Value` FROM backupsolutioninfo WHERE InfoId = -1) AS `TempC` ON TempC.ComputerID = Computers.ComputerID LEFT JOIN (SELECT tempa.ltjobid, tempa.computerid, tempa.starttime, tempa.jobstatus, tempa.pluginguid FROM h_backupjobs tempa JOIN v_backuplastjobid ON tempa.ltjobid = v_backuplastjobid.LtJobId) AS `TempA` ON computers.computerid = tempa.computerid AND tempc.pluginguid = tempa.pluginguid LEFT JOIN l_backupjobstatus ON tempa.jobstatus = l_backupjobstatus.statusid LEFT JOIN (SELECT COUNT(*) AS `Count`, h_backupjobs.computerid, pluginguid FROM `h_backupjobs` WHERE `h_backupjobs`.`JobStatus` IN (0,6) AND `StartTime` >= '2016-11-21 14:25:55Z' GROUP BY h_backupjobs.computerid, pluginguid) AS `TempB` ON (TempC.pluginguid = TempB.pluginguid AND TempB.computerid = Computers.ComputeriD) LEFT JOIN (SELECT COUNT(*) AS `Count`, pluginguid, h_backupsolutionlogs.computerid FROM h_backupsolutionlogs WHERE logtypeid IN (1,2) AND LogTime >= '2016-11-21 14:25:55Z' GROUP BY h_backupsolutionlogs.computerid, pluginguid) AS `TempD` ON (TempD.Computerid = Computers.Computerid AND TempD.pluginguid = TempC.pluginguid) WHERE `computers`.`OS` LIKE '%Server%' AND `Computers`.`ComputerId` IN (SELECT ComputerId FROM usersec WHERE UserId=1) AND `Computers`.`ComputerId` NOT IN (SELECT computerid FROM computerroledefinitions JOIN roledefinitions ON computerroledefinitions.roledefinitionid = roledefinitions.roledefinitionid WHERE roletype LIKE 'Backup') ORDER BY IFNULL(TempC.Value, '') ASC LIMIT 0,30 226.7665 I'm wondering if anybody knows a way I can create such a monitor or at least such a query on the database to show me the same data that the 'Backup Not Installed' view does? Thanks in advance!
  6. Hello, Does anybody have a consistent method of monitoring for Off-Site Azure Backups? We're currently using the Crimson Logs but I'm finding that it's hit and miss on actually finding failures and even harder to look for the 'lack of success' event ID At the moment, I'm using a Powershell script found on here for Local Windows Backup which is working a treat.. I don't know if this can be modified at all to work for Azure? Script for Windows Backup: get-pssnapin windows.serverbackup -erroraction silentlyContinue add-pssnapin windows.serverbackup -erroraction silentlyContinue $result = "WBJOB" $trap = (Get-Command -type cmdlet | where {$_.Name -eq 'Get-WBJob'}) if (!$trap) { $result = "WBSUMMARY" } write-host $result $errordesc = "No error" If ($result -eq "WBJOB") { write-host "Retrieving using Get-WBJob" $backupdata = Get-WBJob -previous 1 if ($backupdata.hResult -ne 0) { $errordesc = $backupdata.errorDescription } reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "JobStartTime" /d $backupdata.startTime /t REG_SZ /f reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "JobEndTime" /d $backupdata.endTime /t REG_SZ /f reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "Error" /d $errordesc /t REG_SZ /f reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "ResultCode" /d $backupdata.HResult /t REG_SZ /f } If ($result -eq "WBSUMMARY") { write-host "Retrieving using Get-WBSummary" $backupdata = Get-WBSummary $errordesc = $backupdata.detailedmessage if ($backupdata.detailedmessage -eq $null) { $errordesc = "No error" } reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "JobStartTime" /d $backupdata.LastSuccessfulBackupTime /t REG_SZ /f reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "JobEndTime" /d "Cannot be retrieved" /t REG_SZ /f reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "Error" /d $errordesc /t REG_SZ /f reg add HKLM\Software\MSP-Monitoring\Backups\WindowsBackup /v "ResultCode" /d $backupdata.LastBackupResultHR /t REG_SZ /f }
  • Create New...