Powershell Command over PrintQueue

In JD Edwards EnterpriseOne (JDE) environments, file management in directories like PrintQueue, media objects, and upload folders becomes critical for performance, cleanup, and troubleshooting.

Over time, these folders grow significantly, especially in production environments. PowerShell provides a fast and reliable way to analyze, filter, copy, and count JDE-related files.

This blog covers practical PowerShell commands used in real JDE environments for PrintQueue analysis and file operations.

1. Finding JDE PrintQueue Information

The PrintQueue directory in JDE stores batch print outputs, reports, and spool files. Over time, it accumulates large volumes of data.

Typical Path:

C:\JDEdwardsPPack\E920\PrintQueue

You can inspect files using:

Get-ChildItem -Path "C:\JDEdwardsPPack\E920\PrintQueue"

What This Helps With:

• Identify active and old print jobs
• Analyze disk usage
• Support troubleshooting for UBE printing issues

2. Copying PrintQueue Files Based on Age (Retention Strategy)

In large JDE environments, old PrintQueue files need to be archived based on age.

Example: Files older than 1000 days

Get-ChildItem -Path "C:\JDEdwardsPPack\E920\PrintQueue" |
Where-Object {$_.LastWriteTime -lt (Get-Date).AddDays(-1000)} |
Copy-Item -Destination "C:\JDEdwardsPPack\E920\GoLive\PrintQueueArc"

Why This Matters:

• Prevents PrintQueue folder from growing uncontrollably
• Improves system performance
• Helps in archival strategy for compliance

3. Finding a Specific File in JDE Folder

Sometimes troubleshooting requires locating a specific report or PDF generated by JDE.

Example:

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

4. Counting Files in a JDE Folder

To understand storage usage or file volume, you can count files easily.
Example:
Get-ChildItem -Path "D:\JDEdwards\E920\mediaobj\htmlupload" -File |
Measure-Object | Select-Object -ExpandProperty Count

5. Counting Files Between Date Range
For audit or cleanup planning, filtering by date range is extremely useful.
Script:
$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

6. Best Practices for JDE File Management

✔ Always Archive Before Delete

Never delete PrintQueue files directly in production without backup.

Final Thoughts

PowerShell is a powerful tool for managing JD Edwards PrintQueue and file system growth. With simple commands, administrators can:

• Analyze file usage
• Archive old print jobs
• Count media objects
• Improve system performance
• Support compliance requirements