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