SQL changes required for version 11.0 to 11.1

NovaBACKUP xSP / Remote Workforce
Last Updated: Nov 30, 2012 12:43PM PST
If upgrading from Version 11.0 to 11.1 you will need to run the following SQL Queries to update the stored procedures. You will need to run the queries in the following order:

 

  • get_user_last_backup
  • get_total_computer_count
  • get_total_computer_count_using_license_index

 

For the following queries you will need to replace [BackupServer] with [Your Server Name]

 


Update get_user_last_backup query:


 

?
USE [BackupServer]
GO
-- Object: StoredProcedure [dbo].[get_user_last_backup]
-- Script Date: 05/05/2010 15:15:55
SET ansi_nulls ON
GO
SET quoted_identifier ON
GO
-- =============================================
-- Create date: 23-Feb-2010
-- Description: Get the id and date of the last backup
-- request for a specified user.
-- =============================================
CREATE PROCEDURE [dbo].[Get_user_last_backup]
-- parameters for the stored procedure
@uid NUMERIC
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET nocount ON;
-- Select the last backup request for the user
SELECT TOP 1 requestid, requestdate
FROM requests
WHERE userid = @uid
AND requesttype = 'BACKUP'
ORDER BY requestdate DESC
END

 


Update get_total_computer_count query:


 

?
USE [BackupServer]
GO

-- Object: StoredProcedure [dbo].[get_total_computer_count
-- Script Date: 05/10/2010 13:28:20
SET ansi_nulls ON
GO
SET quoted_identifier ON
GO
-- =============================================
-- Returns the total number of computers that are allowed to
-- perform backups for all users
-- =============================================
ALTER PROCEDURE [dbo].[Get_total_computer_count]
AS
BEGIN
SET nocount ON;
SELECT SUM(numcomputers)
FROM users
WHERE enabled = 'YES'
AND accountstatus = 'ACTIVE'
AND users.licensestatus = 'NORM'
END

 


Update get_total_computer_count_using_license_index query:


 

?
USE [BackupServer]
GO
-- Object: StoredProcedure [dbo].[get_total_computer_count_using_license_index]
-- Script Date: 05/10/2010 13:28:32
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Returns the total number of computers that are allowed
-- to perform backups for all users
-- =============================================
ALTER PROCEDURE [dbo].[get_total_computer_count_using_license_index]
@LicenseId int
AS
BEGIN
SET NOCOUNT ON;
SELECT
SUM(Users.NumComputers)
FROM Users
INNER JOIN
Groups ON Users.GroupId = Groups.GroupId
AND Users.Enabled='YES'
AND Users.AccountStatus='ACTIVE'

AND Users.LicenseStatus='NORM'
AND Groups.LicenseId = @LicenseId
END

NovaCare Status

NovaStor Support

Contact Us

  • E-Mail NovaStor Support

    Click Here to submit your case to the NovaStor Support Team.

  • Phone Support

    If you have NovaCare Support you can call our support line:

    US Support:
    Call +1(805) 409-3140
    Press 2 for Technical Support
    Monday through Friday
    8am - 5pm PST

    EMEA Support:
    Call +49 (40) 63809 - 989
    Monday through Friday
    9am - 5pm CET (GMT+1)

TeamViewer