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].[uspRptGetADDomainsWithNullHandler]
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