Powershell Command over PrintQueue

 

Copy Folders using where clause -

get-childitem -Path "C:\JDEdwardsPPack\E920\PrintQueue" |  where-object {$_.LastWriteTime -lt (get-date).AddDays(-2500)} |  copy-item -destination "C:\JDEdwardsPPack\E920\GoLive\PQ2500"

get-childitem -Path "C:\JDEdwardsPPack\E920\PrintQueue" |  where-object {$_.LastWriteTime -lt (get-date).AddDays(-2000)} |  copy-item -destination "C:\JDEdwardsPPack\E920\GoLive\PQ2000"

get-childitem -Path "C:\JDEdwardsPPack\E920\PrintQueue" |   where-object {$_.LastWriteTime -lt (get-date).AddDays(-1500)} |  copy-item -destination "C:\JDEdwardsPPack\E920\GoLive\PQ1500"

get-childitem -Path "C:\JDEdwardsPPack\E920\PrintQueue" |  where-object {$_.LastWriteTime -lt (get-date).AddDays(-1000)} |  copy-item -destination "C:\JDEdwardsPPack\E920\GoLive\PQ1000"

get-childitem -Path "C:\JDEdwardsPPack\E920\PrintQueue" | where-object {$_.LastWriteTime -lt (get-date).AddDays(-500)} |  copy-item -destination "C:\JDEdwardsPPack\E920\GoLive\PQ500"

--Find File in Folder

Get-ChildItem -Path "X:\JDEdwards\E920\mediaobj\htmlupload  " -Filter "FILE-10-0-10-141-58881134646742537-1504646610815.pdf"   

-- Count Number of Files in Folder using PowerShell

$Path = "D:\JDEdwards\E920\mediaobj\htmlupload"      

$StartDate = "2017-01-01"

$EndDate = "2023-01-01"     

(Get-ChildItem -Path $Path -File -Recurse | Where-Object { $_.CreationTime -ge  $StartDate -and $_.CreationTime -le $EndDate }).Count

JDE Web Package Build

 

Application 9.2

Tools Release 9.2.5.x

Verify Tools Planner ESU, Tools ESU and Tools ASI is completed

Three new applications have been delivered, off of menu GH9083, for the web client:

• P9601W - Package Assembly
• P9621W - Package Definition
• P9631W - Package Deployment

Configure Deployment Server INI

[INSTALL]

ClientType=deployment

[JDENET_KERNEL_DEF11]
KrnlName=PACKAGE BUILD KERNEL
dispatchDLLName=jdekrnl.dll
dispatchDLLFunction=_JDEK_DispatchPkgBuildMessage@28
MaxNumberOfProcesses=1
numberOfAutoStartProcesses=1

 

Also, make sure the following matches the content in the jde.ini on the Enterprise Server:

[SECURITY]
SecurityServer=xxxxxxx
User=JDE
Password=xxxxxxxx
DefaultEnvironment=DV920

[JDENET]
serviceNameListen=6017
serviceNameConnect=6017

Start and Stop Deployment Server service - JDE B9 Client Network

Set Service to Start Automatic 

Use Application P9601W to Package Assembly,followed by Define and deployment....

JDE Check-In Process Based on Tool Release

 

Tools Prior to 9.2.1

Specs - > From Dev Workstation to Central Objects (F987*) Table

Artifacts - > From Dev WorkStation source, include, java, res copied  to Deployment Server pathcode folder

Tools 9.2.1. to 9.2.4.x

Tools 9.2.1.x -> 

Specs -> From Dev Workstation to Central Objects (F987*) Table

Artifacts - > From Dev WorkStation source, include, java, res copied  to Deployment Server pathcode folder

Artifacts - > From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780H

Tools 9.2.3.x - >  

Specs -> From Dev Workstation to Central Objects (F987*) Table

Artifacts - > From Dev WorkStation source, include, java, res copied  to Deployment Server pathcode folder

Artifacts - > From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780R. 

NER and TER Artifacts not copied to Deployment Server and Repository. 

BSFN Artifacts continue copied to Deployment Server Pathcode folder

BSFN Artifacts are copied to Repository F98780R and F98780H

NER and TER Artifacts (.c and .h) are created at build time.

Tools 9.2.4.x -> 

Specs -> From Dev Workstation to Central Objects (F987*) Table

Artifacts - > From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780H. 

BSFN, NER and TER Artifacts not copied to Deployment Server.  

NER and TER Artifacts are not copied to Repository F98780R and F98780R. 

BSFN Artifacts are copied to Repository F98780R and F98780R. 

NER and TER Artifacts (.c and .h) are created at build time.

Tools 9.2.5.x or higher

E1Local Database is removed

Specs - Copied from the User Spec Tables (F98xxxUS) to the Central Objects (F987xxx) Check-in location tables.

Artifacts -> From Dev WorkStation source, include, java, res copied  to Repository F98780R and F98780H

JDE Submitted Job Execution Performance

Jobs in JDE Need to be evaluate for performance. Below Query will give Minimum, Average and Maximum Runtime of Jobs 

 --Create Table based on above Select Query 

 SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) AS EXECUTION_MINUTE INTO SVM920.F986114_EXECUTION FROM SVM920.F986114 WHERE JCENHV LIKE '%PD920%' AND JCJOBSTS='D' AND DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) >0 ORDER BY JCPID,JCVERS,EXECUTION_MINUTE DESC

 --- SQL Query to find Execution Time in Minute 

SQL SERVER - 

 SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) AS EXECUTION_MINUTE FROM SVM920.F986114 WHERE JCENHV LIKE '%PD920%' AND JCJOBSTS='D' AND DATEDIFF(MINUTE,JCSTDTIM,JCETDTIM) >0 ORDER BY JCPID,JCVERS,EXECUTION_MINUTE DESC

AS400 -> 

SELECT JCJOBNBR,JCPID,JCVERS,JCSTDTIM,JCETDTIM,TIMESTAMPDIFF(4, char(JCETDTIM - JCSTDTIM)) AS EXECUTION_MINUTE FROM SVM920.F986114 WHERE 

JCPID='R55TRE03' AND JCVERS='SSI00001' 

AND JCENHV LIKE '%PD920%' AND JCJOBSTS='D'   AND TIMESTAMPDIFF(4, char(JCETDTIM - JCSTDTIM)) >0

ORDER BY JCJOBNBR DESC,JCVERS,EXECUTION_MINUTE DESC;

 -- Finally Find Minimum, Average and Maximum Time for Job to complete 

 SELECT JCJOBNBR, JCPID, JCVERS, MIN(EXECUTION_MINUTE) AS MINIMUM,AVG(EXECUTION_MINUTE) AS AVERAGE,MAX(EXECUTION_MINUTE) AS MAXIMUM FROM SVM920.F986114_EXECUTION GROUP BY JCPID,JCVERS