<div>
Hi,<br><br>some old solutions were using a Microsoft tool "DelProf.exe". But I don't have seen recent updates of this tool.<br><br>Here is another scripted solution based on GPO that could do the work :<br><br>​<a href="https://zamarax.com/2020/04/20/how-to-delete-old-user-profiles-using-gpo-and-powershell/" rel="ugc">How to delete old profiles with GPO and Powershell</a>​​​
</div>


Tech

doctorbill

<div>
This script gives an error:<br>gci -force 'C:\Users'-ErrorAction SilentlyContinue | ? { $_ -is [io.directoryinfo] } | % {$len = 0gci -recurse -force $_.fullname -ErrorAction SilentlyContinue | % { $len += $_.length }$_.fullname, '{0:N2} GB' -f ($len / 1Gb)$sum = $sum + $len}“Total size of profiles”,'{0:N2} GB' -f ($sum / 1Gb)<br><br>Error:<br>ForEach-Object : Cannot convert 'System.Object[]' to the type 'System.Management.Automation.ScriptBlock<br>parameter 'RemainingScripts'. Specified method is not supported.<br>At line:1 char:88<br>+ ... ryinfo] } | % {$len = 0gci -recurse -force $_.fullname -ErrorAction S ...<br>+ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: InvalidArgument: (:) [ForEach-Object], ParameterBindingException<br>&nbsp; &nbsp; + FullyQualifiedErrorId : CannotConvertArgument,Microsoft.PowerShell.Commands.ForEachObjectCommand
</div>


SENIOR SYSTEM ARCHITECT

DEMAN-BARCELO (MVP) Thierry

<div>
This also does not return anything:<br>Get-WMIObject -class Win32_UserProfile | Where {(!$_.Special) -and ($_.ConvertToDateTime($_.LastUseTime) -lt (Get-Date).AddDays(-60))}| Measure-Object<br><br>If I put in 0 rather than -60 it returns all profiles but any other value returns 0
</div>


<div>
Hello,<br>I found another site where the lines are well reported :<br><a href="http://woshub.com/delete-old-user-profiles-gpo-powershell/" rel="ugc">How to Delete Old User Profiles Using GPO and PowerShell? | Windows OS Hub (woshub.com)</a>&nbsp;<br><br>So, the first script is working well, but not the second one for me. Probably because of the date format.&nbsp;
</div>


<div>
Awesome:<br>The first script now works<br>What about the 2nd and data format - any ideas?
</div>


<div>
Yes, we should have to work the format of the value of "LastUseTime" &nbsp;: 20210704161119.224000+000<br><br>Here is the little script I have done to have that working :<br><pre><code class="code-10 nolinks" id="code-20-43310308-1"><span>function ConvertDate($LastDate){</span>
<span>&nbsp; $d=[string]$LastDate</span>
<span>&nbsp; if($d.length -ge 25){</span>
<span>&nbsp; &nbsp; $t=$d.split(".")</span>
<span>&nbsp; &nbsp; $d=$t[0] </span>
<span>&nbsp; &nbsp; $findDate=[System.DateTime]::ParseExact($d,'yyyyMMddHHmmss',[System.Globalization.DateTimeFormatInfo]::CurrentInfo)</span>
<span>&nbsp; &nbsp; }</span>
<span>&nbsp; Else {$FindDate=""}</span>
<span>&nbsp; Return $FindDate </span>
<span>}</span>
<span></span>
<span>#$a=convertDate("20210704182913.353000+000")</span>
<span>#echo $a</span>
<span>Get-WMIObject -class Win32_UserProfile| Where {(!$_.Special) -and (ConvertDate($_.LastUseTime) -lt (Get-Date).AddDays(-60))}| Measure-Object</span>
</code></pre>You can also remove the part "|measure" to have the list of profiles detected. The LocalPath field should indicate the name of found profiles.<br><br><br>
</div>


IT Professional

Albert Widjaja

<div>
I tried to adapt the script so that it in UK date (04/07/2021 4th July 2021):<br>----------<br>function ConvertDate($LastDate){<br>&nbsp; $d=[string]$LastDate<br>&nbsp; if($d.length -ge 25){<br>&nbsp; &nbsp; $t=$d.split(".")<br>&nbsp; &nbsp; $d=$t[0]<br>&nbsp; &nbsp; $findDate=[System.DateTime]::ParseExact($d,'ddMMyyyyHHmmss',[System.Globalization.DateTimeFormatInfo]::CurrentInfo)<br>&nbsp; &nbsp; }<br>&nbsp; Else {$FindDate=""}<br>&nbsp; Return $FindDate<br>}<br><br>#$a=convertDate("20210704182913.353000+000")<br>#echo $a<br>Get-WMIObject -class Win32_UserProfile| Where {(!$_.Special) -and (ConvertDate($_.LastUseTime) -lt (Get-Date).AddDays(-60))}| Measure-Object<br><br>Got this error:<br>Exception calling "ParseExact" with "3" argument(s): "The DateTime represented by the string is not supported in<br>calendar System.Globalization.GregorianCalendar."<br>At line:6 char:5<br>+ &nbsp; &nbsp; $findDate=[System.DateTime]::ParseExact($d,'ddMMyyyyHHmmss',[Syst ...<br>+ &nbsp; &nbsp; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: NotSpecified: (:) [], MethodInvocationException<br>&nbsp; &nbsp; + FullyQualifiedErrorId : FormatException<br><br>
</div>


<div>
Correction:<br>---------<br>function ConvertDate($LastDate){<br>&nbsp; $d=[string]$LastDate<br>&nbsp; if($d.length -ge 25){<br>&nbsp; &nbsp; $t=$d.split(".")<br>&nbsp; &nbsp; $d=$t[0]<br>&nbsp; &nbsp; $findDate=[System.DateTime]::ParseExact($d,'ddMMyyyyHHmmss',[System.Globalization.DateTimeFormatInfo]::CurrentInfo)<br>&nbsp; &nbsp; }<br>&nbsp; Else {$FindDate=""}<br>&nbsp; Return $FindDate<br>}<br><br>#$a=convertDate("04072021182913.353000+000")<br>#echo $a<br>Get-WMIObject -class Win32_UserProfile| Where {(!$_.Special) -and (ConvertDate($_.LastUseTime) -lt (Get-Date).AddDays(-60))}| Measure-Object<br><br>Same error
</div>


<div>
Have you verified the actual format of LastUseTime?<br><br><div style="margin-left: 20px;"><ul><li style="list-style-type: none;"><ul><li>You can try and test the function directly with a specific value.</li></ul></li></ul></div><div style="margin-left: 20px;">Is the content of $a in comment corresponding at your data?&nbsp;</div>
</div>


<div>
The server time is set to ddMMyyyy<br>ie 04/07/2021<br>Should I be using the / characters?
</div>


<div>
No, that is not linked to your server time:<br><br>Can you indicate what are the numbers displayed by this command ? (here is a sample on my system)<br><br><pre><code class="code-1 nolinks" id="code-20-43310331-1"><span>PS U:\test&gt; Get-WMIObject -class Win32_UserProfile | ft lastusetime</span>
<span></span>
<span>lastusetime</span>
<span>-----------</span>
<span>20210704201058.640000+000</span>
<span></span>
</code></pre>
</div>


<div>
lastusetime<br>-----------<br>20210704082448.091000+000<br>20210704082447.966000+000<br>20210704201545.436000+000<br>20210704201545.444000+000<br>20210704082447.716000+000<br>20210704082447.591000+000<br>20210704082447.419000+000<br>20210704082447.138000+000<br>20210704082446.872000+000<br>20210704082442.997000+000<br>20210704082446.684000+000<br>20210704082446.544000+000<br>20210704082446.388000+000<br>20210704082446.247000+000<br>20210704082446.091000+000<br>20210704082445.919000+000<br>20210704082445.684000+000<br>20210704082445.528000+000<br>20210704082445.450000+000<br>20210704082445.403000+000<br>20210704082445.356000+000<br>20210704082445.278000+000<br>20210704082445.184000+000<br>20210704082445.122000+000<br>20210704082445.044000+000<br>20210704082444.966000+000<br>20210704082444.903000+000<br>20210704201546.366000+000<br>20210704082444.778000+000<br>20210704201546.408000+000<br>20210704201546.415000+000<br>20210704201546.422000+000
</div>


<div>
Is this suggesting ALL profiles have been used today?<br><br>
</div>


<div>
So you should change nothing in the script that I proposed. The format is the same:<br>Year (4 digits), Month, day, hour, minutes, seconds.<br><br>All dates are for the 4th of July.
</div>


<div>
Perhaps you should use another approach :<br><br><pre><code class="code-1 nolinks" id="code-20-43310337-1"><span>PS U:\test&gt; get-childitem c:\users |ft name,lastwritetime,lastaccesstime</span>
<span></span>
<span>Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LastWriteTime &nbsp; &nbsp; &nbsp; LastAccessTime</span>
<span>---- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;------------- &nbsp; &nbsp; &nbsp; --------------</span>
<span>administrator 04/06/2020 10:19:46 04/07/2021 12:18:46</span>
<span>annick &nbsp; &nbsp; &nbsp; &nbsp;11/05/2021 16:40:17 04/07/2021 12:18:46</span>
<span>Public &nbsp; &nbsp; &nbsp; &nbsp;25/11/2020 15:41:03 04/07/2021 22:09:05</span>
<span>UserNa.DOMAIN&nbsp;01/07/2021 19:35:12 04/07/2021 21:50:29</span>
</code></pre>
</div>


<div>
Using that I get the following:<br>-------------------------------------------------------<br>PS C:\Users\administrator.VIVANT&gt; get-childitem c:\users |ft n<br><br>Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LastWriteTime &nbsp; &nbsp; &nbsp; LastAccessTime<br>---- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ------------- &nbsp; &nbsp; &nbsp; --------------<br>.NET v4.5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;06/06/2018 16:37:33 06/06/2018 16:37:33<br>.NET v4.5 Classic &nbsp; &nbsp;06/06/2018 16:37:29 06/06/2018 16:37:29<br>aaron &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22/06/2020 15:44:49 22/06/2020 15:44:49<br>adam &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 18/03/2021 13:27:44 18/03/2021 13:27:44<br>Administrator &nbsp; &nbsp; &nbsp; &nbsp;29/03/2019 16:58:07 29/03/2019 16:58:07<br>administrator.VIVANT 02/07/2021 09:17:39 02/07/2021 09:17:39<br>carmine.pertosa &nbsp; &nbsp; &nbsp;09/09/2020 11:10:30 09/09/2020 11:10:30<br>carolann.tullett &nbsp; &nbsp; 22/04/2021 15:42:40 22/04/2021 15:42:40<br>carolina.murcia &nbsp; &nbsp; &nbsp;13/02/2019 11:15:56 13/02/2019 11:15:56<br>Cody.Dixon &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20/03/2020 13:00:45 20/03/2020 13:00:45<br>Daniel.Crockett &nbsp; &nbsp; &nbsp;02/07/2021 14:13:53 02/07/2021 14:13:53<br>darren.chowrimootoo &nbsp;02/07/2021 08:46:41 02/07/2021 08:46:41<br>Hatice.Yusuf &nbsp; &nbsp; &nbsp; &nbsp; 18/02/2019 15:56:01 18/02/2019 15:56:01<br>inventas.admin &nbsp; &nbsp; &nbsp; 31/03/2020 13:39:18 31/03/2020 13:39:18<br>ishaq.javed &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/04/2021 12:00:36 28/04/2021 12:00:36<br>John.Zierold &nbsp; &nbsp; &nbsp; &nbsp; 10/02/2020 14:04:09 10/02/2020 14:04:09<br>jordan.kyriakou &nbsp; &nbsp; &nbsp;24/11/2020 14:04:31 24/11/2020 14:04:31<br>krishna.mehta &nbsp; &nbsp; &nbsp; &nbsp;02/07/2021 09:10:57 02/07/2021 09:10:57<br>Matt.Smith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20/03/2020 12:27:45 20/03/2020 12:27:45<br>michael.c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;06/06/2019 20:23:40 06/06/2019 20:23:40<br>MSSQL$MICROSOFT##WID 01/01/2020 16:55:35 01/01/2020 16:55:35<br>neil.moonesawmy &nbsp; &nbsp; &nbsp;02/07/2021 10:31:38 02/07/2021 10:31:38<br>nicole.czaja &nbsp; &nbsp; &nbsp; &nbsp; 10/02/2020 13:58:23 10/02/2020 13:58:23<br>peter.pieri &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13/03/2020 12:31:55 13/03/2020 12:31:55<br>Public &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/09/2016 12:34:54 12/09/2016 12:34:54<br>Saidullah.Rahmani &nbsp; &nbsp;08/01/2019 11:05:51 08/01/2019 11:05:51<br>sean.kapoor &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13/09/2019 14:03:33 13/09/2019 14:03:33<br>shoheb.rahman &nbsp; &nbsp; &nbsp; &nbsp;02/07/2021 09:09:26 02/07/2021 09:09:26<br>Voyager &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;28/06/2019 10:00:29 28/06/2019 10:00:29<br>Yasmin.Cadinouche &nbsp; &nbsp;14/04/2020 10:23:34 14/04/2020 10:23:34<br><br><br>
</div>


<div>
So you have interesting dates with old access on some profiles you can use this command:<br><pre><code class="code-1 nolinks" id="code-20-43310348-1"><span>get-childitem c:\users |where { $_.lastaccesstime -lt (Get-Date).AddDays(-60)}</span>
</code></pre><br>Now, you just have to remove selected folder, after selecting only "regular" users and not "system" users.
</div>


<div>
Almost there<br>Can you give me the script as an example of a folder removal please
</div>


<div>
Here is a folder removal with all the content (you need full permissions on the folders):<br><br><pre><code class="code-1 nolinks" id="code-20-43310352-1"><span>remove-item c:\users\user1 -force -Recurse</span>
</code></pre>
</div>


<div>
Can I use the powershell to do this - ie select all folders older than a certain date and delete them, but using the powershell as above with the changed script:<br><br>Get-WMIObject -class Win32_UserProfile | Where {(!$_.Special) -and (!$_.Loaded) -and ($_.ConvertToDateTime($_.LastUseTime) -lt (Get-Date).AddDays(-30))} | Remove-WmiObject –WhatIf
</div>


<div>
You could use the folders found (with ChildItem), to search with Get-wmiobject the Win32_Userprofile where the localpath correspond.<br><br><pre><code class="code-1 nolinks" id="code-20-43310361-1"><span>get-WMIObject -class Win32_UserProfile | Where { $_.localpath -eq "c:\users\folderFound"}</span>
</code></pre><br>A complete script could be something like :<br><br><pre><code class="code-1 nolinks" id="code-20-43310361-2"><span>$f=get-childitem c:\users |where { $_.lastwritetime -lt (Get-Date).AddDays(-60)} | select fullname</span>
<span>foreach ($i in $f){ $g=$i.fullname; get-WMIObject -class Win32_UserProfile | Where { $_.localpath -like "$g"} }</span>
</code></pre><br>
</div>


<div>
Sorry - still not clear to me<br>How do I use this:<br><br>$f=get-childitem c:\users |where { $_.lastwritetime -lt (Get-Date).AddDays(-60)} | select fullname foreach ($i in $f){ $g=$i.fullname; get-WMIObject -class Win32_UserProfile | Where { $_.localpath -like "$g"} }<br>&nbsp;<br>In this script:<br>Get-WMIObject -class Win32_UserProfile | Where {(!$_.Special) -and (!$_.Loaded) -and ($_.ConvertToDateTime($_.LastUseTime) -lt (Get-Date).AddDays(-30))} | Remove-WmiObject –WhatIf <br><br>And to keep user profiles such as system, network service, local administrator etc<br><br>
</div>


<div>
Would it be:<br>Get-WMIObject -class Win32_UserProfile | Where {(!$_.Special) -and (!$_.Loaded) -and ($_.ConvertToDateTime($_.LastUseTime) -lt (Get-Date).AddDays(-30))} | Remove-WmiObject –WhatIf | Remove-WmiObject –WhatIf
</div>


<div>
Sorry:<br><br>Would it be:<br>Get-WMIObject -class Win32_UserProfile | Where {(!$_.Special) -and (!$_.Loaded) -and ($_.ConvertToDateTime($_.LastUseTime) -lt (Get-Date).AddDays(-60))} | Remove-WmiObject –WhatIf | Remove-WmiObject –WhatIf
</div>


<div>
Sorry<br>Still unclear - I am not so versed in Powershell as you are<br>What is the script to remove all profiles older than 60 Days and exclude profiles such as system, network service, local administrator etc <br>Can you give the whole working script together so I understand please<br>I think we are almost there with this
</div>


<div>
Or does this script do that:<br><br>$f=get-childitem c:\users |where { $_.lastwritetime -lt (Get-Date).AddDays(-60)} | select fullname<br>foreach ($i in $f){ $g=$i.fullname; get-WMIObject -class Win32_UserProfile | Where {(!$_.Special) -and (!$_.Loaded) -and ($_.localpath -like "$g")} } | Remove-WmiObject –WhatIf<br><br>Again - what is the function of the WhatIf please
</div>


<div>
I am not sure about the following:<br>{(!$_.Special) -and (!$_.Loaded) <br>I know the ! means do not remove but what are .Special and .Loaded referring to
</div>


<div>
Thanks so much for your help<br>Great to work with a PowerShell script expert
</div>


<div>
<div class="content wysiwyg-content fr-view">
Does anyone have a powershell script that checks the age of a user profile on a terminal server and deletes it if it has been unused for a specific time or is older than a certain date?<br><br>
</div>
</div>



Does anyone have a powershell script that checks the age of a user profile on a terminal server and deletes it if it has been unused for a specific time or is older than a certain date?

User Profiles

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.