I have a need to be able to query all of the content types defined within a site collection and return the Name of the content type, description, policy statement, retention detail (on or off, and any defined retention stages and if records and non-records are classified the same).  Does anyone have a powershell script that can help with this?  I have found a few that will return the name and description, but nothing about the retention schedules (this is the critical piece for me. 

Thank you in advance to anyone who can help!

Hi,

According to your description, my understanding is that you want to query all of the content type's retention policy details in site collections using PowerShell.

I suggest you can use Policy.GetPolicy function under Microsoft.Office.RecordsManagement.InformationPolicy namespace to get the retention policy details.

Here is a code snippet for your reference:

$Policy = [Microsoft.Office.RecordsManagement.InformationPolicy.Policy]::GetPolicy($ctype);

More information:

Policy.GetPolicy method

Thanks

Best Regards