Back to OIM Explorer

dbo.QBM_FGIQBMServerInfo

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.136 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVBitToString source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL36 lines
1CREATE FUNCTION dbo.QBM_FGIQBMServerInfo(2  @UID_QBMServer varchar(38)3) RETURNS nvarchar(max4)5AS6BEGIN7  DECLARE @Erg nvarchar(max)8  SELECT9    TOP 1 @erg = 'Queue = ' + isnull(s.QueueName,10    '<none>') + ';' + ' Cluster = ' + dbo.QBM_FCVBitToString(s.IsCluster) + ';' + ' AutoUpdate = ' + dbo.QBM_FCVBitToString(s.isNoAutoupdate ^ 1) +11    ';' + ' ConfigImported = ' + dbo.QBM_FCVBitToString(sign(len(isnull(S.JobserverConfiguration, '')))) + '; ' + ' Server = ' + isnull(s.FQDN,12    isnull(s.Ident_server, '<none>')) + ';' + ' Parent = ' + isnull(isnull(p.FQDN, isnull(p.Ident_server,13    '<none>')),14    '<none>') + ';'15  FROM QBMServer s16  LEFT17  OUTER18  JOIN QBMServer p19    ON s.UID_ParentQBMServer = p.UID_QBMServer20  WHERE21    s.UID_QBMServer = @UID_QBMServer22  SELECT23    @Erg = CONCAT(@erg,24    ' Tags = ',25    string_agg(convert(nvarchar(max), replace(t.Ident_QBMServerTag, '%Globals.QIM_ProductNameShort%', 'One Identity')),26    N '; '),27    ';')28  FROM QBMServer s29  JOIN QBMServerHasServerTag sht30    ON s.UID_QBMServer = sht.UID_QBMServer31  JOIN QBMServerTag t32    ON sht.UID_QBMServerTag = t.UID_QBMServerTag33  WHERE34    s.UID_QBMServer = @UID_QBMServer endLabel:35  RETURN(@erg)36END
Open raw exported source
SQL ยท Raw9 lines
1  create   function dbo.QBM_FGIQBMServerInfo(@UID_QBMServer varchar(38)) returns nvarchar(max) as begin declare @Erg nvarchar(max) select top 1 2@erg = 'Queue = '+ isnull(s.QueueName, '<none>') + ';' + ' Cluster = ' + dbo.QBM_FCVBitToString(s.IsCluster) + ';' + ' AutoUpdate = ' + dbo.QBM_FCVBitToString3(s.isNoAutoupdate ^ 1) + ';' + ' ConfigImported = ' + dbo.QBM_FCVBitToString(sign(len(isnull(S.JobserverConfiguration, '')))) + '; ' + ' Server = ' + isnull4(s.FQDN, isnull(s.Ident_server, '<none>')) + ';' + ' Parent = ' + isnull(isnull(p.FQDN, isnull(p.Ident_server, '<none>')), '<none>') + ';' from QBMServer5 s left outer join QBMServer p on s.UID_ParentQBMServer = p.UID_QBMServer where s.UID_QBMServer = @UID_QBMServer select @Erg = concat(@erg , ' Tags = '6 , string_agg(convert(nvarchar(max) , replace(t.Ident_QBMServerTag, '%Globals.QIM_ProductNameShort%', 'One Identity') )  , N'; ' )  , ';' ) from QBMServer7 s join QBMServerHasServerTag sht on s.UID_QBMServer = sht.UID_QBMServer join QBMServerTag t on sht.UID_QBMServerTag = t.UID_QBMServerTag where s.UID_QBMServer8 = @UID_QBMServer endLabel: return(@erg) end 9