Extract Object version history
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-09-19 08:48 AM
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
------------------------------
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
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-09-19 12:43 PM
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-09-19 01:21 AM
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
------------------------------
------------------------------
Glenn Houston
Senior Solutions Lead
Telstra
Australia/Brisbane
------------------------------
