scep.ps1

$lastData=(get-date).AddYears(-5)
$myFile = 'your_chosen_location'
$lastData = import-csv $myFile| select -ExpandProperty Timestamp -Last 1


$data=Invoke-Sqlcmd -Query "select * from [SCCM_DATABASE(ex: CM_XXX)].dbo.v_AM_NormalizedDetectionHistory scep 
where scep.timestamp > '${lastData}'
order by scep.Timestamp asc" -ServerInstance "SCCM_SQL_Server_FQDN"


if ($data)
{

	if ((Get-Item $myFile).length -gt 2500kb)
	{
		$data | export-csv $myFile -NoTypeInformation
	}
	else
	{
		$data | export-csv $myFile -Append -NoTypeInformation
	}
}