Summary Table

Categories Total Count
PII 0
URL 0
DNS 1
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].[uspGetADDomains]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

BEGIN TRY

SELECT 'VHA01'
UNION SELECT 'VHA02'
UNION SELECT 'VHA03'
UNION SELECT 'VHA04'
UNION SELECT 'VHA05'
UNION SELECT 'VHA06'
UNION SELECT 'VHA07'
UNION SELECT 'VHA08'
UNION SELECT 'VHA09'
UNION SELECT 'VHA10'
UNION SELECT 'VHA11'
UNION SELECT 'VHA12'
UNION SELECT 'VHA15'
UNION SELECT 'VHA16'
UNION SELECT 'VHA17'
UNION SELECT 'VHA18'
UNION SELECT 'VHA19'
UNION SELECT 'VHA20'
UNION SELECT 'VHA21'
UNION SELECT 'VHA22'
UNION SELECT 'VHA23'
UNION SELECT 'AAC'
UNION SELECT 'DVA'
UNION SELECT 'VBA'
UNION SELECT '
DNS '
;
END TRY

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