Back to OIM Explorer

dbo.QBM_ZDynamicUserShrink

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 688 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVStringToInt source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL32 lines
1CREATE PROCEDURE QBM_ZDynamicUserShrink(2  @Slotnumber int,3  @Dummy1 varchar(38),4  @Dummy2 varchar(38),5  @GenProcIDDummy varchar(38)6)7AS8BEGIN9  DECLARE @DynamicUserLifetime int10  BEGIN TRY11    SELECT12      TOP 1 @DynamicUserLifetime = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\DynamicUserLifetime'),13      7)14    DELETE dialoguser15    FROM dialoguser u16    WHERE17      u.IsDynamicUser = 1 AND datediff(dd,18    u.lastlogin,19    getutcdate()) > @DynamicUserLifetime AND NOT EXISTS(20    SELECT TOP 1 121    FROM DialogDeferredOperation do22    WHERE23      do.UserInformation LIKE 'Identifier=' + u.UID_DialogUser + '%')24  END TRY25  BEGIN CATCH26    EXEC QBM_PSessionErrorAdd DEFAULT27    RAISERROR('',28    18,29    1)30      WITH NOWAIT31  END CATCH32END
Open raw exported source
SQL ยท Raw6 lines
1  create   procedure QBM_ZDynamicUserShrink ( @Slotnumber int , @Dummy1 varchar(38) , @Dummy2 varchar(38) , @GenProcIDDummy varchar(38) ) AS begin2 declare @DynamicUserLifetime int BEGIN TRY  select top 1 @DynamicUserLifetime = dbo.QBM_FCVStringToInt(dbo.QBM_FGIConfigparmValue('Common\DynamicUserLifetime'3), 7) delete dialoguser from dialoguser u where u.IsDynamicUser = 1 and datediff(dd, u.lastlogin, getutcdate()) > @DynamicUserLifetime  and Not exists 4(select top 1 1 from DialogDeferredOperation do where do.UserInformation like 'Identifier=' + u.UID_DialogUser + '%' )  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd5 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 6