Summary Table

Categories Total Count
PII 0
URL 0
DNS 2
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

?-- =============================================
-- Description: Returns Active Directory domain list
--
-- Maintenance Log:
--
-- Update By Update Date Description
-- ----------- --------- ----------------------------
-- =============================================

CREATE PROCEDURE [dbo].[uspRptGetADDomainsWithSelectAll]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

BEGIN TRY
SELECT NULL AS ADDomainValue, '[All]' AS ADDomainLabel
UNION SELECT 'VHA01' AS ADDomainValue, 'VHA01' AS ADDomainLabel
UNION SELECT 'VHA02' AS ADDomainValue, 'VHA02' AS ADDomainLabel
UNION SELECT 'VHA03' AS ADDomainValue, 'VHA03' AS ADDomainLabel
UNION SELECT 'VHA04' AS ADDomainValue, 'VHA04' AS ADDomainLabel
UNION SELECT 'VHA05' AS ADDomainValue, 'VHA05' AS ADDomainLabel
UNION SELECT 'VHA06' AS ADDomainValue, 'VHA06' AS ADDomainLabel
UNION SELECT 'VHA07' AS ADDomainValue, 'VHA07' AS ADDomainLabel
UNION SELECT 'VHA08' AS ADDomainValue, 'VHA08' AS ADDomainLabel
UNION SELECT 'VHA09' AS ADDomainValue, 'VHA09' AS ADDomainLabel
UNION SELECT 'VHA10' AS ADDomainValue, 'VHA10' AS ADDomainLabel
UNION SELECT 'VHA11' AS ADDomainValue, 'VHA11' AS ADDomainLabel
UNION SELECT 'VHA12' AS ADDomainValue, 'VHA12' AS ADDomainLabel
UNION SELECT 'VHA15' AS ADDomainValue, 'VHA15' AS ADDomainLabel
UNION SELECT 'VHA16' AS ADDomainValue, 'VHA16' AS ADDomainLabel
UNION SELECT 'VHA17' AS ADDomainValue, 'VHA17' AS ADDomainLabel
UNION SELECT 'VHA18' AS ADDomainValue, 'VHA18' AS ADDomainLabel
UNION SELECT 'VHA19' AS ADDomainValue, 'VHA19' AS ADDomainLabel
UNION SELECT 'VHA20' AS ADDomainValue, 'VHA20' AS ADDomainLabel
UNION SELECT 'VHA21' AS ADDomainValue, 'VHA21' AS ADDomainLabel
UNION SELECT 'VHA22' AS ADDomainValue, 'VHA22' AS ADDomainLabel
UNION SELECT 'VHA23' AS ADDomainValue, 'VHA23' AS ADDomainLabel
UNION SELECT 'AAC' AS ADDomainValue, 'AAC' AS ADDomainLabel
UNION SELECT 'DVA' AS ADDomainValue, 'DVA' AS ADDomainLabel
UNION SELECT 'VBA' AS ADDomainValue, 'VBA' AS ADDomainLabel
UNION SELECT '
DNS ' AS ADDomainValue, ' DNS ' AS ADDomainLabel
;
END TRY

BEGIN CATCH
PRINT 'There was an error getting the active directory details with null handler' + CHAR(13);
SELECT * FROM dbo.ufnGetErrorInfo();
EXEC uspRaiseErrorInfo;
END CATCH
END
GO