cancel

TRIM Query

Highlighted
MWilson88
Respected Contributor.

TRIM Query

Can you advise if it is possible to query TRIM to indicate what files have been created and left untouched i.e. no events recorded against a particular file since its creation.

 

Any advice/info would be greatly appreciated.

 

Thanks,

 

Matt

1 REPLY
Damitha
Super Contributor.

Re: TRIM Query

Hi Matt,

 

Not sure whether this would help. If you have access to the database you might be able to run a query like below.

 

select recordid from tsrecord

where regdatetime = syslastupdated

and rcrectypeuri in (<Add folder record type uris here>)

 

 

 

Regards,

Damitha Bogahawatta
Principal Consultant
Talent Consulting Services