select reqId, reqProvider, rspDocument, rspTs from tbl_SSO_Log where rspDocument is not null and datediff( day, rspTs, getDate() ) <= 1 and reqProvider = 'rpcisb.salesteamportal.com' order by txId desc

Req ID	Requestor	Response TS	Issuer	C14N	Valid
#htmleditformat( reqId )#	#htmleditformat( reqProvider )#	#rspTs#	#htmleditformat( _srIssuer )#	#htmleditformat( _canonicalizationMethod )#	#_assertionValidated#