Profile picture for user MoellerBennet

Hi,

maybe you too know the problem, that over the years the amount of databases on your ARIS tenant has increased and you might also have lost sight of which databases are still in use and which ones are not needed anymore.

I am trying to find out which databases we still need and which ones not, but so far I am struggling to find a good method to do so. How have you guys done so?

My first thought was to write a report for that but I am lacking experience and knowledge to do so at the moment. I am still getting into everything concerning ARIS.

Kind regards,

Bennet

by Nikita Martyanov
Posted on Sat, 08/27/2022 - 10:03

Hello Bennet,

I think the easiest and the most effective way is to write a report to go through all the objects in each database and find the last modified object in it and the user who made that modification (or even list of objects/models for each database). Then you can contact those users and ask them if they still need this DB on the server or it could be archived.

Another idea is to find something in standard reports for databases. Maybe there's some similar functions are already implemented.

P.S.: it's perfect case and task to dive into ARIS scripting. ARIS Script Help is very useful: all the methods are described and even with examples sometimes.

---

BR, Nikita

0
by Bennet Möller Author
Posted on Mon, 08/29/2022 - 11:47

In reply to by billie1989

Hi Nikita,

thank you so much for your answer!

I have been working on that report and I now have a report that shows me the date of the last modified object in one database.

Now I would like to extend it so that it goes through all our databases and returns the data in .xsl-file ideally. Do you have any advice on how I could make it go through many databases? So far all that I found was ArisData.getDatabaseNames() to get all Databases. How do I "select" it to access its objects and models? Do I use ArisData.openDatabase() for that?

Thank you in advance.

Best regards, Bennet

0
by Nikita Martyanov
Posted on Mon, 08/29/2022 - 12:23

In reply to by MoellerBennet

Hi Bennet,

There's an example in ARIS Script Help:

 var myDBs = ArisData.GetDatabaseNames()
 if(myDBs.length>0 && ArisData.getActiveDatabase().IsValid() )
 {
     var dbReadOnly = ArisData.openDatabase( myDBs[0], true );
     ...
     dbReadOnly.close()
 }

You can combine your script that returns last modification and this piece of code to go through all the DBs:

var myDBs = ArisData.GetDatabaseNames()
if (ArisData.getActiveDatabase().IsValid()) {
  for (var i=0;i<myDBs.length;i++) {
    var dbReadOnly = ArisData.openDatabase( myDBs[i], true );
    ...
    dbReadOnly.close()
  }
}

 

0
by Bennet Möller Author
Posted on Mon, 08/29/2022 - 13:42

In reply to by billie1989

Hi Nikita,

Thank you very much again!

If you have some advice on how to make my report output the data in an excel file I would greatly appreciate it! That would be the last piece in the puzzle for me.

Edit: solved.

Best regards, Bennet

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock