report to calculate the time that the laptop

[shid077]

i need a report to calculate  the time that the laptop has spent in the stockroom since the state has changed from In-Use to In- Stock.

is it from alm_asset table or /sys_history_set table??

if from /sys_history_set table then how.

Please respond asap.

[Mark Manders]

You either need to use PA for this or create metrics/add custom fields to your form. Never report on the sys_history_set table.

There are no 'until now' options and you even need to check what kind of data you do have available. Are you recording the date something is set to 'in stock' or is that just a simple state change? Like with everything: you can't report on data that isn't available.

[shid077]

is it from sys_history_line table calculate  the time that the laptop has spent in the stockroom since the state has changed from In-Use to In- Stock??

then how to calculate that.

[Mark Manders]

Again: NEVER report on the sys_history_set table. 

Check on what data you have and otherwise create it (metrics/PA). You can't report on data that isn't available.