Category: Powershell

Adventures in Powershell – Math and dates

Adventures in Powershell – Math and dates

One month I found myself in a situation where I had to take over an ERP vendor price file update that happens every two weeks.  The actual import into the ERP system was fairly straight forward, as the prices have a built in “price not effective until such and such date” but due to reasons beyond my control there were a few requirements that had to be accomplished prior to the import.

Those requirements are, in no particular order:

  • The files have to be no more than two weeks old, otherwise they are not the current files
  • The file sizes of each file have to be evenly divisible by 272.  This tells you how many items are in the file
  • The files have to be renamed to include the effective date of the prices
  • Those files have to then be archived off to a zip file and copied over to the ERP system’s import folder

Previous to myself, this was all done manually.

I was able to get the requirements above into a Powershell script (skip to end for the full code).  I can’t take original credit for any of this as I found most of what I needed on Stack Exchange and Microsoft’s Scripting Guy blog.

Anyway, I just put it all together into what I needed.

Let’s go through things step by step.

Step 1:  Set some variables for each of the price files (FF being full file, CO being changes only)


#Declare Price Update Files

#vendor1
$sourcevendor1ff = "\\servershare\download\vendor1FF"
$sourcevendor1co = "\\servershare\download\vendor1CO"
#vendor2
$sourcevendor2ff = "\\servershare\download\vendor2FF"
$sourcevendor2co = "\\servershare\download\vendor2CO"
#vendor3
$sourcevendor3ff = "\\servershare\download\vendor3FF"
$sourcevendor3co = "\\servershare\download\vendor3CO"

Step 2: Get the modified date of each file


#Get date of price files
$FileDatevendor1ff = (Get-ChildItem $sourcevendor1ff).LastWriteTime
$FileDatevendor1co = (Get-ChildItem $sourcevendor1co).LastWriteTime
$FileDatevendor2ff = (Get-ChildItem $sourcevendor2ff).LastWriteTime
$FileDatevendor2co = (Get-ChildItem $sourcevendor2co).LastWriteTime
$FileDatevendor3ff = (Get-ChildItem $sourcevendor3ff).LastWriteTime
$FileDatevendor3co = (Get-ChildItem $sourcevendor3co).LastWriteTime

Step 3: Have the person running the script enter the effective date of the files


#Enter the effective date of the Price files
$effective = read-host 'Enter the price effective date in format yyyymmdd'
$effectiveDate = [datetime]::ParseExact($effective,"yyyyMMdd",$null)

Step 4:  Echo to the person what day of the year the modified date of each file is (i.e. Jan 31 is the 31 day of the year, February 20 is day 51 and so on and so on).  This is useful when you need to determine which file is causing the script to stop in step 6.

#Determine days of the year for all variables
    write-host "You entered an effective date of $effectiveDate"
    #Determine Day of Year for effective date
    write-host "Day of the Year for what you entered for an effective date:" $effectiveDate.DayOfYear
    #Determine day of year for vendor1ff
    write-host "vendor1FF was last modified at $FileDatevendor1ff.  Day of the year for vendor1ff file:" $FileDatevendor1ff.DayOfYear
    #Determine day of year for vendor1co
    write-host "vendor1CO was last modified at $FileDatevendor1co.  Day of the year for vendor1co file:" $FileDatevendor1co.DayOfYear
    #Determine day of year for vendor2co
    write-host "vendor2FF was last modified at $FileDatevendor2ff.  Day of the year for vendor2co file:" $FileDatevendor2co.DayOfYear
    #Determine day of year for vendor2ff
    write-host "vendor2CO was last modified at $FileDatevendor2co.  Day of the year for vendor2ff file:" $FileDatevendor2ff.DayOfYear
    #Determine day of year for vendor3co
    write-host "vendor3FF was last modified at $FileDatevendor3ff.  Day of the year for vendor3co file:" $FileDatevendor3co.DayOfYear
    #Determine day of year for vendor3ff
    write-host "vendor3CO was last modified at $FileDatevendor3co.  Day of the year for vendor3ff file:" $FileDatevendor3ff.DayOfYear

Step 5: Do some math to make sure all files are less than 14 days old, and make this a variable

</pre>
#Calculate if price file dates are good

#vendor1co
$pricefilevendor1comath = $effectiveDate.DayOfYear - $FileDatevendor1co.DayOfYear
write-host "There are $pricefilevendor1comath days between what you typed and the modified date of file $sourcevendor1co"
#vendor1FF
$pricefilevendor1ffmath = $effectiveDate.DayOfYear - $FileDatevendor1ff.DayOfYear
write-host "There are $pricefilevendor1ffmath days between what you typed and the modified date of file $sourcevendor1ff"
#vendor2FF
$pricefilevendor2ffmath = $effectiveDate.DayOfYear - $FileDatevendor2ff.DayOfYear
write-host "There are $pricefilevendor2ffmath days between what you typed and the modified date of file $sourcevendor2ff"
#vendor2CO
$pricefilevendor2comath = $effectiveDate.DayOfYear - $FileDatevendor2co.DayOfYear
write-host "There are $pricefilevendor2comath days between what you typed and the modified date of file $sourcevendor2co"
#vendor3FF
$pricefilevendor3ffmath = $effectiveDate.DayOfYear - $FileDatevendor3ff.DayOfYear
write-host "There are $pricefilevendor3ffmath days between what you typed and the modified date of file $sourcevendor3ff"
#vendor3CO
$pricefilevendor3comath = $effectiveDate.DayOfYear - $FileDatevendor3co.DayOfYear
write-host "There are $pricefilevendor3comath days between what you typed and the modified date of file $sourcevendor3co"

Step 6: Do some if/else logic where if any file is older than 14 days, the script stops and tells you


#Do Date math to be sure price file is valid.
#All six files have to be less 13 days or fewer from the
#new effective price date
#vendor1CO Test
if ($pricefilevendor1comath -ge 14) {
write-host "Your price file for vendor1co is too old, get an updated one. Stopping script."
Break
}
#vendor1FF Test
if ($pricefilevendor1ffmath -ge 14) {
write-host "Your price file for vendor1ff is too old, get an updated one. Stopping script."
Break
}
#vendor2FF Test
if ($pricefilevendor2ffmath -ge 14) {
write-host "Your price file for vendor2ff is too old, get an updated one. Stopping script."
Break
}
#vendor2CO Test
if ($pricefilevendor2comath -ge 14) {
write-host "Your price file for vendor2co is too old, get an updated one. Stopping script."
Break
}
#vendor3FF Test
if ($pricefilevendor3ffmath -ge 14) {
write-host "Your price file for vendor3ff is too old, get an updated one. Stopping script."
Break
}
#vendor3CO Test
if ($pricefilevendor3comath -ge 14) {
write-host "Your price file for vendor3co is too old, get an updated one. Stopping script."
Break
}

Step 7: If the proceeding steps all show files less than 14 days old, rename the files and move them to a temp folder


#If all six price files are 13 or fewer days old, begin processing
else {
#vendor1 Process
write-host "- Starting vendor1 Files"
$sourcearchivevendor1 = "\\servershare\it\price data\vendor1\Temp"

$destvendor1ff = "$sourcearchivevendor1\vendor1ff$effective"
$destvendor1co ="$sourcearchivevendor1\vendor1co$effective"
write-host "- Copying vendor1FF from download to temp folder"
Copy-Item $sourcevendor1ff $destvendor1ff
write-host "- Copying vendor1CO from download to temp folder"
Copy-Item $sourcevendor1co $destvendor1co 

Step 8:  Take the items from the temp folder, archive them into a zip file, and copy them to the ERP import folder


write-host "- Archiving vendor1 to zip file"
$destinationvendor1archive = "\\servershare\it\price data\vendor1\vendor1_$effective.zip"
add-type -AssemblyName "system.io.compression.filesystem"
[io.compression.zipfile]::CreateFromDirectory($sourcearchivevendor1, $destinationvendor1archive)
write-host "- Copying vendor1CO to Share"
copy-item $destvendor1co "\\ERPPriceFiles\IN"
write-host "- vendor1 files processed" 

Step 9:  Calculate the number of parts that are in the file and store that number in a variable


#Find the number of records in each file
$Sizevendor1CO = get-item "$destvendor1co"
$Numvendor1co = $Sizevendor1CO.length/272
$lengthvendor1CO = $Sizevendor1CO.length

$Sizevendor1FF = get-item "$destvendor1ff"
$numvendor1FF = $Sizevendor1FF.length/272
$lengthvendor1FF = $Sizevendor1FF.length

$emailvendor1CO = "vendor1CO is $lengthvendor1CO bytes long and has $Numvendor1co records."
$emailvendor1FF = "vendor1FF is $lengthvendor1FF bytes long and has $numvendor1FF records." 

Step 10:  Set up your email server and email info


#Declare SMTP Server
$smtpServer = "smtp.email.local"
$smtpFrom = "pricefiles@domain.local"
$smtpTo = "notifications@yournamehere.com"
$messageSubject = "vendor1vendor3vendor2 Price File Record Count for $effective"

#Declare email message body
$message = New-Object System.Net.Mail.MailMessage $smtpfrom, $smtpto
$message.Subject = $messageSubject
$message.IsBodyHTML = $true
$style = "<style>BODY{font-family: Arial; font-size: 10pt;}"
$style = $style + "TABLE{border: 1px solid black; border-collapse: collapse;}"
$style = $style + "TH{border: 1px solid black; background: #dddddd; padding: 5px; }"
$style = $style + "TD{border: 1px solid black; padding: 5px; }"
$style = $style + "</style>" 

Step 11:  Send an email with the file size of each file, the number of items in each file, and a hyperlink to an Excel log


write-host "- Sending email with number of records"
#actual powershell script
$message.Body = "$emailvendor1CO <br> $emailvendor1FF <br>Update file ""\\servershare\it\price data\vendor1\_datalog_vendor1vendor2vendor3.xlsx"" with those counts<br><br> $emailvendor2CO <br> $emailvendor2FF <br>Update file ""\\servershare\it\price data\vendor2\_datalog_vendor1vendor2vendor3.xlsx"" with those counts<br><br>$emailvendor3CO<br>$emailvendor3FF<br>Update file ""\\servershare\it\price data\vendor3\_datalog_vendor1vendor2vendor3.xlsx"" with those counts<br><br>"

$smtp = New-Object Net.Mail.SmtpClient($smtpServer)
$smtp.Send($message)

Step 12:  Clean up your temp folder


write-host "Cleaning up Files"
#File Cleanup
Remove-Item $destvendor1ff
Remove-Item $destvendor1co
Remove-Item $destvendor2ff
Remove-Item $destvendor2co
Remove-Item $destvendor3ff
Remove-Item $destvendor3co

#Done 

And that’s it.  This script has made it quite easy for me over the last couple of years.

Below, here it is in its entirety:


&nbsp;
<pre>
#Declare Price Update Files

#vendor1
$sourcevendor1ff = "\\servershare\download\vendor1FF"
$sourcevendor1co = "\\servershare\download\vendor1CO"
#vendor2
$sourcevendor2ff = "\\servershare\download\vendor2FF"
$sourcevendor2co = "\\servershare\download\vendor2CO"
#vendor3
$sourcevendor3ff = "\\servershare\download\vendor3FF"
$sourcevendor3co = "\\servershare\download\vendor3CO"

#Get date of price files
$FileDatevendor1ff = (Get-ChildItem $sourcevendor1ff).LastWriteTime
$FileDatevendor1co = (Get-ChildItem $sourcevendor1co).LastWriteTime
$FileDatevendor2ff = (Get-ChildItem $sourcevendor2ff).LastWriteTime
$FileDatevendor2co = (Get-ChildItem $sourcevendor2co).LastWriteTime
$FileDatevendor3ff = (Get-ChildItem $sourcevendor3ff).LastWriteTime
$FileDatevendor3co = (Get-ChildItem $sourcevendor3co).LastWriteTime

#Enter the effective date of the Price files
$effective = read-host 'Enter the price effective date in format yyyymmdd'
$effectiveDate = [datetime]::ParseExact($effective,"yyyyMMdd",$null)

#Determine days of the year for all variables
write-host "You entered an effective date of $effectiveDate"
#Determine Day of Year for effective date
write-host "Day of the Year for what you entered for an effective date:" $effectiveDate.DayOfYear
#Determine day of year for vendor1ff
write-host "vendor1FF was last modified at $FileDatevendor1ff. Day of the year for vendor1ff file:" $FileDatevendor1ff.DayOfYear
#Determine day of year for vendor1co
write-host "vendor1CO was last modified at $FileDatevendor1co. Day of the year for vendor1co file:" $FileDatevendor1co.DayOfYear
#Determine day of year for vendor2co
write-host "vendor2FF was last modified at $FileDatevendor2ff. Day of the year for vendor2co file:" $FileDatevendor2co.DayOfYear
#Determine day of year for vendor2ff
write-host "vendor2CO was last modified at $FileDatevendor2co. Day of the year for vendor2ff file:" $FileDatevendor2ff.DayOfYear
#Determine day of year for vendor3co
write-host "vendor3FF was last modified at $FileDatevendor3ff. Day of the year for vendor3co file:" $FileDatevendor3co.DayOfYear
#Determine day of year for vendor3ff
write-host "vendor3CO was last modified at $FileDatevendor3co. Day of the year for vendor3ff file:" $FileDatevendor3ff.DayOfYear

#Calculate if price file dates are good

#vendor1co
$pricefilevendor1comath = $effectiveDate.DayOfYear - $FileDatevendor1co.DayOfYear
write-host "There are $pricefilevendor1comath days between what you typed and the modified date of file $sourcevendor1co"
#vendor1FF
$pricefilevendor1ffmath = $effectiveDate.DayOfYear - $FileDatevendor1ff.DayOfYear
write-host "There are $pricefilevendor1ffmath days between what you typed and the modified date of file $sourcevendor1ff"
#vendor2FF
$pricefilevendor2ffmath = $effectiveDate.DayOfYear - $FileDatevendor2ff.DayOfYear
write-host "There are $pricefilevendor2ffmath days between what you typed and the modified date of file $sourcevendor2ff"
#vendor2CO
$pricefilevendor2comath = $effectiveDate.DayOfYear - $FileDatevendor2co.DayOfYear
write-host "There are $pricefilevendor2comath days between what you typed and the modified date of file $sourcevendor2co"
#vendor3FF
$pricefilevendor3ffmath = $effectiveDate.DayOfYear - $FileDatevendor3ff.DayOfYear
write-host "There are $pricefilevendor3ffmath days between what you typed and the modified date of file $sourcevendor3ff"
#vendor3CO
$pricefilevendor3comath = $effectiveDate.DayOfYear - $FileDatevendor3co.DayOfYear
write-host "There are $pricefilevendor3comath days between what you typed and the modified date of file $sourcevendor3co"

#Do Date math to be sure price file is valid.
#All six files have to be less 13 days or fewer from the
#new effective price date
#vendor1CO Test
if ($pricefilevendor1comath -ge 14) {
write-host "Your price file for vendor1co is too old, get an updated one. Stopping script."
Break
}
#vendor1FF Test
if ($pricefilevendor1ffmath -ge 14) {
write-host "Your price file for vendor1ff is too old, get an updated one. Stopping script."
Break
}
#vendor2FF Test
if ($pricefilevendor2ffmath -ge 14) {
write-host "Your price file for vendor2ff is too old, get an updated one. Stopping script."
Break
}
#vendor2CO Test
if ($pricefilevendor2comath -ge 14) {
write-host "Your price file for vendor2co is too old, get an updated one. Stopping script."
Break
}
#vendor3FF Test
if ($pricefilevendor3ffmath -ge 14) {
write-host "Your price file for vendor3ff is too old, get an updated one. Stopping script."
Break
}
#vendor3CO Test
if ($pricefilevendor3comath -ge 14) {
write-host "Your price file for vendor3co is too old, get an updated one. Stopping script."
Break
}

#If all six price files are 13 or fewer days old, begin processing
else {
#vendor1 Process
write-host "- Starting vendor1 Files"
$sourcearchivevendor1 = "\\servershare\it\price data\vendor1\Temp"

$destvendor1ff = "$sourcearchivevendor1\vendor1ff$effective"
$destvendor1co ="$sourcearchivevendor1\vendor1co$effective"
write-host "- Copying vendor1FF from download to temp folder"
Copy-Item $sourcevendor1ff $destvendor1ff
write-host "- Copying vendor1CO from download to temp folder"
Copy-Item $sourcevendor1co $destvendor1co
write-host "- Archiving vendor1 to zip file"
$destinationvendor1archive = "\\servershare\it\price data\vendor1\vendor1_$effective.zip"
add-type -AssemblyName "system.io.compression.filesystem"
[io.compression.zipfile]::CreateFromDirectory($sourcearchivevendor1, $destinationvendor1archive)
write-host "- Copying vendor1CO to Share"
copy-item $destvendor1co "\\ERPPriceFiles\IN"
write-host "- vendor1 files processed"

#vendor2 Process
write-host "- Starting vendor2 Files"
$sourcearchivevendor2 = "\\servershare\it\price data\vendor2\Temp"

$destvendor2ff = "$sourcearchivevendor2\vendor2ff$effective"
$destvendor2co ="$sourcearchivevendor2\vendor2co$effective"
write-host "- Copying vendor2FF from download to temp folder"
Copy-Item $sourcevendor2ff $destvendor2ff
write-host "- Copying vendor2CO from download to temp folder"
Copy-Item $sourcevendor2co $destvendor2co
write-host "- Archiving vendor2 to zip file"
$destinationvendor2archive = "\\servershare\it\price data\vendor2\vendor2_$effective.zip"
add-type -AssemblyName "system.io.compression.filesystem"
[io.compression.zipfile]::CreateFromDirectory($sourcearchivevendor2, $destinationvendor2archive)
write-host "- Copying vendor2CO to Share"
copy-item $destvendor2co "\\ERPPriceFiles\IN"
write-host "- vendor2 files processed"

#vendor3 Process
write-host "- Starting vendor3 files"
$sourcearchivevendor3 = "\\servershare\it\price data\vendor3\Temp"
$sourcevendor3ff = "\\servershare\download\vendor3FF"
$sourcevendor3co = "\\servershare\download\vendor3CO"
$destvendor3ff = "$sourcearchivevendor3\vendor3ff$effective"
$destvendor3co ="$sourcearchivevendor3\vendor3co$effective"
write-host "- Copying vendor3FF from download to temp folder. Larger file, takes longer"
Copy-Item $sourcevendor3ff $destvendor3ff
write-host "- Copying vendor3CO from download to temp folder"
Copy-Item $sourcevendor3co $destvendor3co
$destinationvendor3archive = "\\servershare\it\price data\vendor3\vendor3_$effective.zip"
write-host "- Archiving vendor3 to zip file"
add-type -AssemblyName "system.io.compression.filesystem"
[io.compression.zipfile]::CreateFromDirectory($sourcearchivevendor3, $destinationvendor3archive)
write-host "- Copying vendor3CO to Share"
copy-item $destvendor3co "\\ERPPriceFiles\IN"
write-host "- vendor3 files processed"

write-host "- Calcuating number of records"

#Find the number of records in each file
$Sizevendor1CO = get-item "$destvendor1co"
$Numvendor1co = $Sizevendor1CO.length/272
$lengthvendor1CO = $Sizevendor1CO.length

$Sizevendor1FF = get-item "$destvendor1ff"
$numvendor1FF = $Sizevendor1FF.length/272
$lengthvendor1FF = $Sizevendor1FF.length

$emailvendor1CO = "vendor1CO is $lengthvendor1CO bytes long and has $Numvendor1co records."
$emailvendor1FF = "vendor1FF is $lengthvendor1FF bytes long and has $numvendor1FF records."

$Sizevendor2CO = get-item "$destvendor2co"
$Numvendor2co = $Sizevendor2CO.length/272
$lengthvendor2CO = $Sizevendor2CO.length

$Sizevendor2FF = get-item "$destvendor2ff"
$numvendor2FF = $Sizevendor2FF.length/272
$lengthvendor2FF = $Sizevendor2FF.length

$emailvendor2CO = "vendor2CO is $lengthvendor2CO bytes long and has $Numvendor2co records."
$emailvendor2FF = "vendor2FF is $lengthvendor2FF bytes long and has $numvendor2FF records."

$Sizevendor3CO = get-item "$destvendor3co"
$Numvendor3co = $Sizevendor3CO.length/272
$lengthvendor3CO = $Sizevendor3CO.length

$Sizevendor3FF = get-item "$destvendor3ff"
$numvendor3FF = $Sizevendor3FF.length/272
$lengthvendor3FF = $Sizevendor3FF.length

$emailvendor3CO = "vendor3CO is $lengthvendor3CO bytes long and has $Numvendor3co records."
$emailvendor3FF = "vendor3FF is $lengthvendor3FF bytes long and has $numvendor3FF records."

#Declare SMTP Server
$smtpServer = "smtp.email.local"
$smtpFrom = "pricefiles@domain.local"
$smtpTo = "notifications@yournamehere.com"
$messageSubject = "vendor1vendor3vendor2 Price File Record Count for $effective"

#Declare email message body
$message = New-Object System.Net.Mail.MailMessage $smtpfrom, $smtpto
$message.Subject = $messageSubject
$message.IsBodyHTML = $true
$style = "<style>BODY{font-family: Arial; font-size: 10pt;}"
$style = $style + "TABLE{border: 1px solid black; border-collapse: collapse;}"
$style = $style + "TH{border: 1px solid black; background: #dddddd; padding: 5px; }"
$style = $style + "TD{border: 1px solid black; padding: 5px; }"
$style = $style + "</style>"

write-host "- Sending email with number of records"
#actual powershell script
$message.Body = "$emailvendor1CO <br> $emailvendor1FF <br>Update file ""\\servershare\it\price data\vendor1\_datalog_vendor1vendor2vendor3.xlsx"" with those counts<br><br> $emailvendor2CO <br> $emailvendor2FF <br>Update file ""\\servershare\it\price data\vendor2\_datalog_vendor1vendor2vendor3.xlsx"" with those counts<br><br>$emailvendor3CO<br>$emailvendor3FF<br>Update file ""\\servershare\it\price data\vendor3\_datalog_vendor1vendor2vendor3.xlsx"" with those counts<br><br>"

$smtp = New-Object Net.Mail.SmtpClient($smtpServer)
$smtp.Send($message)

write-host "Cleaning up Files"
#File Cleanup
Remove-Item $destvendor1ff
Remove-Item $destvendor1co
Remove-Item $destvendor2ff
Remove-Item $destvendor2co
Remove-Item $destvendor3ff
Remove-Item $destvendor3co

#Done

}

 

***DISCLAIMER*** I am not responsible for this breaking or damaging any of your stuff.  Copyrights belong to their original owners***

 

Clearing AX Client Cache for One User in a RDS Environment Using Powershell

Clearing AX Client Cache for One User in a RDS Environment Using Powershell

“You should clear that person’s AX cache”.

How many times have you heard that?  If you are running Dynamics 2012 (R2 in my case), this post may help.

Let’s start with some assumptions.

    1. You have the AX client deployed using Remote Desktop Services (RemoteAPP)
    2. You are not using User Profile Disks
    3. You have multiple RDS Hosts people connect to

If that describes your environment, read on.  If not, or if it’s close, keep reading.  You may be able to modify my solution to fit your needs.

The goal:  Remove all local AX cache files for one user in the following locations:

  1. All files/folders starting with “vsa” located here: \\%hostname%\c$\users\%username%\Appdata\Local\Microsoft\Dynamics AX\
  2. All files ending in “*.kti” or “.auc” located here: \\%hostname%\c$\users\%username%\Appdata\Local
  3. Additionally, be able to do this for Production, Test, Dev, and Training AX RDS servers

Requirements:  User running the Powershell script must have full rights to each user folder on each RDS host server.  Domain Admin members in AD would be a good place to start for the quick and dirty way.

What it does:

  1. Prompts the person to enter the AD username of the desired user of whose cache you want cleared (line 5)
  2. Prompts the person to make sure that user has had their RDS session closed, otherwise the AX client may still be running, thus locking the files you want to delete (line 6)
  3. Asks if you are sure (line 8).  If you enter Y, the script continues, otherwise a N will skip over everything until line 64.
  4. Asks which AX environment you want to do this in (line 13)
  5. Connects to the RDS server for the environment specified in step 4.

There are if/else statements from here on out (line 17, 24, 31, and then 38) that are hard coded for specific servers dependent on which AX environment you chose.

The code:

#This script will connect to AX RDS servers and delete the AX client cache
#Make sure the user has been logged out of the RDS box first otherwise the files will be locked

#Provide the Active Directory Username
$axuser = read-host 'Enter the AD username'
write-host "Make sure that $axuser has been logged out of their RDS session before proceeding"

$Yousure = read-host 'Are you sure you want to continue? Y/N'
If ($yousure -match "y")
 {

#Provide the AX Environment
write-host "Possible AX Environments:  Test, Training, Dev, Prod"
$axenvironment = read-host 'Enter the AX Environment'
    
#Connect to AX environment chosen and delete local cache    
    If ($axenvironment -match "Test")
        {
            write-host "Removing Test AX cache for username $axuser"
            get-item "\\axtestrds\c$\Users\$axuser\AppData\Local\Microsoft\Dynamics Ax\vsa*" | foreach ($_) {remove-item $_.fullname -recurse} 
            get-item "\\axtestrds\c$\Users\$axuser\AppData\Local\*.kti" | foreach ($_) {remove-item $_.fullname -recurse} 
            get-item "\\axtestrds\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse}
        }
        else { If ($axenvironment -match "Training")
            {
                write-host "Removing Training AX cache for username $axuser"
                get-item "\\TrainingRDS\c$\Users\$axuser\AppData\Local\Microsoft\Dynamics Ax\vsa*" | foreach ($_) {remove-item $_.fullname -recurse} 
                get-item "\\TrainingRDS\c$\Users\$axuser\AppData\Local\*.kti" | foreach ($_) {remove-item $_.fullname -recurse } 
                get-item "\\TrainingRDS\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse } 
            }
                else { If ($axenvironment -match "Dev")
                    {
                        write-host "Removing Dev AX cache for username $axuser"
                        get-item "\\DevRDS\c$\Users\$axuser\AppData\Local\Microsoft\Dynamics Ax\vsa*" | foreach ($_) {remove-item $_.fullname -recurse } 
                        get-item "\\DevRDS\c$\Users\$axuser\AppData\Local\*.kti" | foreach ($_) {remove-item $_.fullname -recurse } 
                        get-item "\\DevRDS\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse } 
                    }
                    else { If ($axenvironment -match "Prod")
                        {
                            write-host "Removing Prod AX cache for username $axuser"
                            get-item "\\ProdRDS02\c$\Users\$axuser\AppData\Local\Microsoft\Dynamics Ax\vsa*" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS02\c$\Users\$axuser\AppData\Local\*.kti" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS02\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS03\c$\Users\$axuser\AppData\Local\Microsoft\Dynamics Ax\vsa*" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS03\c$\Users\$axuser\AppData\Local\*.kti" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS03\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS04\c$\Users\$axuser\AppData\Local\Microsoft\Dynamics Ax\vsa*" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS04\c$\Users\$axuser\AppData\Local\*.kti" | foreach ($_) {remove-item $_.fullname -recurse } 
                            get-item "\\ProdRDS04\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse } 
                            get-item "\\ProdRDS05\c$\Users\$axuser\AppData\Local\Microsoft\Dynamics Ax\vsa*" | foreach ($_) {remove-item $_.fullname -recurse} 
                            get-item "\\ProdRDS05\c$\Users\$axuser\AppData\Local\*.kti" | foreach ($_) {remove-item $_.fullname -recurse } 
                            get-item "\\ProdRDS05\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse } 
                            get-item "\\1075rds09\c$\Users\$axuser\AppData\Local\*.auc" | foreach ($_) {remove-item $_.fullname -recurse} 
                            }
                                else { write-host "You did not enter the right command"
                                    }
                        }
                    }
                }

#Reminder to clear usage data in AX Client
write-host "Now that cache has been cleared, connect to AX client on $axenvironment and clear the usage data for $axuser"
}
else 
                    {write-host "You chose not to continue.  Well played"
                    }

***DISCLAIMER*** I am not responsible for this breaking or damaging any of your stuff.  Copyrights belong to their original owners***