AnsweredAssumed Answered

Is there a way to see how long a file has been sitting in a certain state?

Question asked by Kevin Sisto on Sep 9, 2015
Latest reply on Sep 14, 2015 by Jason Kerns



I have recently been tasked with querying a bunch of data from different workflows and having Excel put the data into tables.  The queries include number of files in a state, number of files moved in and out of a certain states, and the final piece that i can't figure out, the amount of time (days) a file has sat in a state. Is there a report generator that can give me these numbers that i can dump into Excel?  I know that if i set up a state notification it will give you the number of days (See below) but i was wondering if there is a way to get that metadata.  I'm new to programming and SQL stuff so any help is appreciated.


Thank you!