Benötigte SQL- Änderungen für ein Update von Version 11.0 auf 11.1

NovaBACKUP xSP / Remote Workforce
Zuletzt Aktualisiert: Nov 30, 2012 12:43PM PST
Wenn Sie von Version 11.0 auf 11.1 updaten, so müssen Sie die folgenden SQL- Abfragen auf der BackupServer Datenbank ausführen. Bitte beachten Sie die Reihenfolge!
 
  • get_user_last_backup
  • get_total_computer_count
  • get_total_computer_count_using_license_index

Hinweis: Bitte passen Sie gegebenenfalls die Datenbank [BackupServer] auf Ihre Installation an.
 

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

Kontaktieren Sie uns

  • NovaStor E-Mail Support

    Klicken Sie hier um eine Supportanfrage an das NovaStor Support Team zu senden.

  • Telefon Support

    Wenn Sie NovaCare Premium besitzen, können Sie unsere Support Mitarbeiter auch direkt telefonisch erreichen:

    Telefon: +49 (40) 63809 - 989

    Montag bis Freitag
    09:00 – 17:00 CET (GMT+1)

TeamViewer