Installation Type:  
Server configuration
 
Licensing:  
Enterprise edition (64 bit)  
Serial Number: 1185-5314-6299-8150-5058-5641
 
Installation Directories:  
Product: D:\ColdFusion2018  
Web Root: D:\ColdFusion2018\cfusion\wwwroot
 
Server Information:  
Web Server: Built-in web server  
Hostname / IP Address: TNWG01A-V2223 (Development Server)  
Admin Port: 8500  
ODBC Services: installed  
ColdFusion Server Profile: Development Profile  
ColdFusion Solr Search Services: not installed  
ColdFusion Pdfg Services: not installed  
ColdFusion .NET Integration Services: not installed  
RDS: enabled
 
Disk Space Information (for Installation Target):  
Required: 672 MB  
Available: 73,781 MB
      

[http://127.0.0.1:8500/CFIDE/administrator/index.cfm](http://127.0.0.1:8500/CFIDE/administrator/index.cfm)  
[http://TNWG01A-V2223:8500/CFIDE/administrator/index.cfm](http://TNWG01A-V2223:8500/CFIDE/administrator/index.cfm)  
Ae!l1KheF8=sD8@m68fN8s9O6eHoew
   

Allowed IP for access ColdFusion Administrator  
10.159.224.114  
10.159.18.112  
10.159.18.32  
10.159.39.100  
10.159.18.228
       ![Adobes ColdFusion 2018 Installnyvhere Cancel x Int...](Exported%20image%2020250808202330-0.png)  
![Adobes ColdFusion 2018 Installnyvhere Cancel x End...](Exported%20image%2020250808202331-1.png)  
![Adobes ColdFusion 2018 Installnyvhere Cancel x Ins...](Exported%20image%2020250808202334-2.png)   ![Adobes ColdFusion 2018 InstallAnmhere Cancel Insta...](Exported%20image%2020250808202335-3.png)  
![Adobes ColdFusion 2018 InstallAnmhere Cancel Selec...](Exported%20image%2020250808202335-4.png)   ![Adobes ColdFusion 2018 InstallAnmhere Cancel Subco...](Exported%20image%2020250808202336-5.png)  
![Adobes ColdFusion 2018 InstallAnmhere Cancel Remot...](Exported%20image%2020250808202337-6.png)

Ae!l1KheF8=sD8@m68fN8s9O6eHoew
   
![Adobes ColdFusion 2018 InstallAnmhere Cancel Acces...](Exported%20image%2020250808202338-7.png)   ![Adobes ColdFusion 2018 WARNING CPU License Count T...](Exported%20image%2020250808202339-8.png)  
![Adobes ColdFusion 2018 InstallAnmhere Cancel Selec...](Exported%20image%2020250808202342-9.png)  
![Adobes ColdFusion 2018 InstallAnmhere Cancel Built...](Exported%20image%2020250808202344-10.png)   ![Adobes ColdFusion 2018 InstallAnmhere Cancel Perfo...](Exported%20image%2020250808202344-11.png)     
![Adobes ColdFusion 2018 InstallAnmhere Cancel Admin...](Exported%20image%2020250808202345-12.png)  

Ae!l1KheF8=sD8@m68fN8s9O6eHoew
 ![Adobes ColdFusion 2018 InstallAnmhere Cancel Enabl...](Exported%20image%2020250808202346-13.png)

Ae!l1KheF8=sD8@m68fN8s9O6eHoew
   
![Adobes ColdFusion 2018 InstallAnmhere Cancel Serve...](Exported%20image%2020250808202347-14.png)  

Installation Type:  
Server configuration
 
Licensing:  
Enterprise edition (64 bit)  
Serial Number: 1185-5314-6299-8150-5058-5641
 
Installation Directories:  
Product: D:\ColdFusion2018  
Web Root: D:\ColdFusion2018\cfusion\wwwroot
 
Server Information:  
Web Server: Built-in web server  
Hostname / IP Address: TNWG01A-V2223  
Admin Port: 8500  
ODBC Services: installed  
ColdFusion Server Profile: Development Profile  
ColdFusion Solr Search Services: not installed  
ColdFusion Pdfg Services: not installed  
ColdFusion .NET Integration Services: not installed  
RDS: enabled
 
Disk Space Information (for Installation Target):  
Required: 672 MB  
Available: 73,759 MB
 ![Machine generated alternative text Adobes ColdFusi...](Exported%20image%2020250808202347-15.png)   ![Machine generated alternative text Adobes ColdFusi...](Exported%20image%2020250808202351-16.png)   ![Machine generated alternative text Adobes ColdFusi...](Exported%20image%2020250808202352-17.png)     
![Machine generated alternative text Adobe ColdFusio...](Exported%20image%2020250808202352-18.png)

Ae!l1KheF8=sD8@m68fN8s9O6eHoew
 ![Machine generated alternative text Adobe ColdFusio...](Exported%20image%2020250808202353-19.png)   ![Machine generated alternative text Adobe ColdFusio...](Exported%20image%2020250808202353-20.png)  

==Change the ColdFusion user account==

94. ==Open the Services Control Panel. (For example, select Start \> Settings \> Control Panel \> Administrative Tools \> Services.)==
95. ==Right-click ColdFusion 2018 Application Server, and select Properties. The ColdFusion 2018 Application Server Properties (Local Computer) dialog box appears.==

ColdFusion 2018 Application Server  
SVC-ColdFusion-App@cbp.dhs.gov  
yt9Pejye6uuc+x8DGrBONFwrkm1yq4rz

97. ==On the Log On tab, select This account, and enter the account information.==
98. ==Click OK.====￼====In the Services control panel, right-click ColdFusion 2018 Application Server, and select Restart.==

|   |
|---|
|_Note:_ **Do not rename your Windows Administrator account. This causes problems with security policies and profiles.**|
   

Allowed IP for access ColdFusion Administrator  
10.159.224.114  
10.159.18.112  
10.159.18.32  
10.159.39.100  
10.159.18.228

![ColdFusion 11 Application Server Properties Local ...](Exported%20image%2020250808202354-21.png)

**Reuse highlighted accounts**
 ![SQL Server Browser ADSVCSQL8ROWSERD01 SQL server W...](Exported%20image%2020250808202354-22.png)  

Data & Services \> Datasource

|   |   |   |   |   |   |   |
|---|---|---|---|---|---|---|
|Type|CF Data Source Name|Database|Server|Port|User Name|Password|
|**Microsoft SQL Server :**|ADEX_DSN|ADEX|tnwg01a-p0657\wsg1||||
|**Microsoft SQL Server :**|ADEX_Web|ADEX|tnwg01a-p0657\wsg1||||
|**Microsoft SQL Server :**|DMZ_Provisioning|ADEX|TNWG01A-V1983.DMZ.CBP.DHS.GOV|64088|DMZ\SVC-ADEX-Provision||
|**Microsoft SQL Server :**|OperationsManager|OperationsManager|tnwg01a-p0664\wsg1||||
|**Microsoft SQL Server :**|OperationsManagerDW|OperationsManagerDW|tnwg01a-p0665\wsg1||||
|**Microsoft SQL Server :**|PowerShell|Master|tnwg01a-p0657\wsg1||||
|**Microsoft SQL Server :**|PS|Master|tnwg01a-p0657\wsg1||||
|**Microsoft SQL Server :**|SAT_Provisioning|Orchestrator|tnwg01a-v1322.sat.cbp.dhs.gov\wsg1||SVC-ADEX-Provisioning||
|**Microsoft SQL Server :**|SCCM-CAS|CM_WSG|TNWG01A-V0980\WSG1||||
|**Microsoft SQL Server :**|SCCM-P01-SUSDB|SUSDB|tnwg01a-v0980\wsg1||||
|**Microsoft SQL Server :**|**DMGCONFIGMGR**|CM_SM2|TNWG01A-P0869\DMGCONFIGMGR||||
 
**SQL Job**
 
|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_01|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_01] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_01]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_01]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_01] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_01](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_01] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_01_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_01(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_01_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_01(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 12/1/2016|
   

|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_02|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_02] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_02]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_02]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_02] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_02](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_02] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_02_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_02(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_02_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_02(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 1/1/2017|
 
|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_03|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_03] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_03]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_03]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_03] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_03](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_03] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_03_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_03(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_03_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_03(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 2/1/2017|
 
|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_04|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_04] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_04]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_04]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_04] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_04](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_04] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_04_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_04(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_04_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_04(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 3/1/2017|
   

|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_05|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_05] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_05]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_05]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_05] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_05](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_05] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_05_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_05(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_05_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_05(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 4/1/2017|
 
|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_06|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_06] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_06]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_06]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_06] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_06](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_06] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_06_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_06(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_06_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_06(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 5/1/2017|
   

|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_07|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_07] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_07]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_07]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_07] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_07](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_07] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_07_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_07(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_07_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_07(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 6/1/2017|
 
|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_08|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_08] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_08]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_08]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_08] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_08](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_08] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_08_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_08(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_08_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_08(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 7/1/2017|
   

|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_09|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_09] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_09]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_09]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_09] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_09](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_09] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_09_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_09(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_09_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_09(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 8/1/2017|
 
|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_10|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_10] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_10]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_10]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_10] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_10](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_10] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_10_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_10(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_10_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_10(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 9/1/2017|
   

|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_11|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_11] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_11]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_11]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_11] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_11](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_11] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_11_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_11(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_11_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_11(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO  <br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_11] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_11]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_11]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_11] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_11](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [numeric](18, 0) NULL,  <br>[C_Value07] [numeric](18, 0) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_11] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_11_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_11(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_11_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_11(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 10/1/2017|
 
|   |   |
|---|---|
|Name:|ADEX_WorkStation_UserInfo_12|
|Owner:|AD\SVC-EDME-WSG-SYSCENT|
|Steps:|USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_12] Script Date: 05/24/2010 14:49:50 ******/  <br>IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ADEX_WorkStation_UserInfo_12]') AND type in (N'U'))  <br>DROP TABLE [dbo].[ADEX_WorkStation_UserInfo_12]  <br>GO<br><br>  <br><br>USE [ADEX]  <br>GO<br><br>  <br><br>/****** Object: Table [dbo].[ADEX_WorkStation_UserInfo_12] Script Date: 05/24/2010 14:49:50 ******/  <br>SET ANSI_NULLS ON  <br>GO<br><br>  <br><br>SET QUOTED_IDENTIFIER ON  <br>GO<br><br>  <br><br>SET ANSI_PADDING ON  <br>GO<br><br>  <br><br>CREATE TABLE [dbo].[ADEX_WorkStation_UserInfo_12](  <br>[id] [int] IDENTITY(1,1) NOT NULL,  <br>[UserID] [varchar](50) NULL,  <br>[WRKSTDOMAIN] [varchar](50) NULL,  <br>[WRKST] [varchar](50) NULL,  <br>[LogonServer] [varchar](50) NULL,  <br>[C_LogonServer] [varchar](50) NULL,  <br>[intTime] [varchar](50) NULL,  <br>[C_Time] [varchar](50) NULL,  <br>[Ver] [varchar](50) NULL,  <br>[C_Ver] [varchar](50) NULL,  <br>[Value01] [varchar](max) NULL,  <br>[C_Value01] [varchar](max) NULL,  <br>[Value02] [varchar](max) NULL,  <br>[C_Value02] [varchar](max) NULL,  <br>[Value03] [varchar](max) NULL,  <br>[C_Value03] [varchar](max) NULL,  <br>[Value04] [varchar](max) NULL,  <br>[C_Value04] [varchar](max) NULL,  <br>[Value05] [varchar](max) NULL,  <br>[C_Value05] [varchar](max) NULL,  <br>[Value06] [varchar](max) NULL,  <br>[C_Value06] [varchar](max) NULL,  <br>[Value07] [varchar](max) NULL,  <br>[C_Value07] [varchar](max) NULL,  <br>[Value08] [varchar](max) NULL,  <br>[C_Value08] [varchar](max) NULL,  <br>[Value09] [varchar](max) NULL,  <br>[C_Value09] [varchar](max) NULL,  <br>[Value10] [varchar](max) NULL,  <br>[C_Value10] [varchar](max) NULL,  <br>[Value11] [varchar](max) NULL,  <br>[C_Value11] [varchar](max) NULL,  <br>[Value12] [varchar](max) NULL,  <br>[C_Value12] [varchar](max) NULL,  <br>[Value13] [varchar](max) NULL,  <br>[C_Value13] [varchar](max) NULL,  <br>[Value14] [varchar](50) NULL,  <br>[C_Value14] [varchar](50) NULL,  <br>[Value15] [varchar](50) NULL,  <br>[C_Value15] [varchar](50) NULL,  <br>[cdirNet][varchar](max) NULL,  <br>CONSTRAINT [PK_ADEX_WorkStation_UserInfo_12] PRIMARY KEY CLUSTERED  <br>(  <br>[id] ASC  <br>)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  <br>) ON [PRIMARY]<br><br>  <br><br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_12_UserID_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_12(UserID,WRKST)  <br>GO  <br>CREATE NONCLUSTERED INDEX IX_ADEX_WorkStation_UserInfo_12_value14_Value15_WRKST  <br>ON dbo.ADEX_WorkStation_UserInfo_12(Value14,Value15)  <br>GO  <br>SET ANSI_PADDING OFF  <br>GO|
|Schedule:|Monthly Recurring Day 1 of every 12 month(s) occurs 3:08:05PM Start Date 11/1/2017|
   

|   |   |
|---|---|
|Name:|Process Temporary User PIV-Exempt Requests|
|Owner:|sys-admin ==script was updated to 7 day exemption==|
|Steps:|EXEC sp_configure 'show advanced options', 1  <br>GO  <br>-- To update the currently configured value for advanced options.  <br>RECONFIGURE  <br>GO  <br>-- To enable the feature.  <br>EXEC sp_configure 'xp_cmdshell', 1  <br>GO  <br>-- To update the currently configured value for this feature.  <br>RECONFIGURE  <br>GO<br><br>  <br><br>SET NOCOUNT ON<br><br>  <br><br>BEGIN TRY  <br>DECLARE @COUNTER BIGINT,  <br>@HASH VARCHAR(255),  <br>@cmd VARCHAR(2000),  <br>@cmd2 VARCHAR(2000)<br><br>  <br><br>SET @COUNTER = 0  <br>DECLARE @GET_HASH CURSOR  <br>SET @GET_HASH = CURSOR FOR  <br>  <br>SELECT [HASH]  <br>FROM [ADEX].[dbo].[WSG_PivMgmt]  <br>WHERE TimeStamp NOT BETWEEN dateadd(day,-7,getdate()) AND getdate() AND living_status = 1  <br>OPEN @GET_HASH  <br>FETCH NEXT FROM @GET_HASH INTO @HASH  <br>WHILE @@FETCH_STATUS = 0  <br>BEGIN<br><br>  <br><br>set @cmd = 'NET group SG-USER-PIVEXEMPT /domain ' + @HASH + ' /del'<br><br>  <br>  <br><br>/***** You will need to uncomment the below in order to execute the command *****/  <br>--EXEC (@cmd)<br><br>  <br><br>exec master.dbo.xp_cmdshell @cmd, no_output;<br><br>  <br>  <br><br>PRINT @cmd  <br>UPDATE [ADEX].[dbo].[WSG_PivMgmt]  <br>SET living_status = 0  <br>WHERE [HASH] = @HASH and TimeStamp NOT BETWEEN dateadd(day,-7,getdate()) AND getdate() AND living_status = 1<br><br>  <br><br>SET @COUNTER = @COUNTER + 1;<br><br>  <br><br>FETCH NEXT FROM @GET_HASH INTO @HASH  <br>END<br><br>  <br><br>CLOSE @GET_HASH  <br>DEALLOCATE @GET_HASH<br><br>  <br><br>END TRY  <br>BEGIN CATCH  <br>SELECT  <br>@@SERVERNAME AS ServerName,  <br>ERROR_NUMBER() AS ErrorNumber,  <br>ERROR_SEVERITY() AS ErrorSeverity,  <br>ERROR_STATE() AS ErrorState,  <br>ERROR_PROCEDURE() AS ErrorProcedure,  <br>ERROR_LINE() AS ErrorLine,  <br>ERROR_MESSAGE() AS ErrorMessage,  <br>GETDATE() AS ErrorDate;  <br>END CATCH;<br><br>  <br>  <br><br>-- To allow advanced options to be changed.  <br>EXEC sp_configure 'show advanced options', 1  <br>GO  <br>-- To update the currently configured value for advanced options.  <br>RECONFIGURE  <br>GO  <br>-- To enable the feature.  <br>EXEC sp_configure 'xp_cmdshell', 0  <br>GO  <br>-- To update the currently configured value for this feature.  <br>RECONFIGURE  <br>GO|
|Schedule:|Daily Recurring every 1 hour(s) occurs 12:08:05AM Start Date 3/13/2017|
 
|   |   |
|---|---|
|Name:|Process WSG SCOM Config Version 3-18-2020|
|Owner:|AD\SVC-ColdFusion-App /CmdExec|
|Steps:|D:\Data\ProcessSCOMconfig\ProcessCBP_Custom_ConfigurationV03-18-2020.exe|
|Schedule:|Daily Recurring once daily occurs 1:00:00AM Start Date 11/12/2010|
   

|   |   |
|---|---|
|Name:|RunProcess SCOM Alerts Version 3-18-2020  <br>Process runs on tnwg01a-p0657 and tnwg01a-p0665|
|Owner:|AD\SVC-ColdFusion-App /CmdExec|
|Steps:|D:\Data\ProcessSCOMconfig\ProcessAlerts_V03-18-2020.exe|
|Schedule:|Every 2 mins.|