topic RE: Extract Object version history in Product Forum

Extract Object version history

GlennHouston — Wed, 25 Sep 2019 07:48:00 GMT

Hi,

I'd like to extract the most recent "Date and Time" value for multiple objects that are within my organisation's object library. I can't find any reports that allow me to do this - is there a way I can get this information?

I need this data because our design authority requires it to be documented when migrating objects from one environment to another, and currently i'm having to check each object's most recent date and time version manually (which is taking a long time due to the large number of objects used by my process).

Thanks in advance,

Glenn.

------------------------------
Glenn H
Australia/Brisbane
------------------------------

RE: Extract Object version history

peraug — Thu, 26 Sep 2019 11:43:00 GMT

do you have access to the DB directly? if so you could just query the db for the info ..
this will list all processes/objects with last edit date..
Invoke-Sqlcmd -ServerInstance $DB_server -Query "SELECT name,lastmodifieddate FROM $DB_Database.dbo.BPAProcess"
BR
PE

------------------------------
Per Egil Raugstad
Prinsipal analyst IT infrastructure
Equinor ASA
Europe/Oslo
------------------------------

RE: Extract Object version history

GlennHouston — Fri, 27 Sep 2019 00:21:00 GMT

Thank you, PE. I don't have access to but will see if our platform team will run the query.

------------------------------
Glenn Houston
Senior Solutions Lead
Telstra
Australia/Brisbane
------------------------------