Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Agent Count
  1. Npprojects

    Custom Tabs - Dataview

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

    Deployments & Defaults

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

    Monitoring Windows Server Backups

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

    Backup Manager

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

    Microsoft Azure Backup

    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 }