Find out which Databases are in use

Bennet Möller on August 26, 2022

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

Tags: #aris; #arisreport; #arisreportscripting

Bookmark

Notify Moderator

Best Reply

Nikita Martyanov on August 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

or register to reply.

Show in context Notify Moderator

4 Replies

Nikita Martyanov on August 27, 2022 - 10:03

Best reply

Hello Bennet,

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

or register to reply.

Notify Moderator

Bennet Möller Author on August 29, 2022 - 11:47 as Reply to Nikita Martyanov

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

or register to reply.

Notify Moderator

Nikita Martyanov on August 29, 2022 - 12:23 as Reply to Bennet Möller

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()
  }
}

or register to reply.

Notify Moderator

Bennet Möller Author on August 29, 2022 - 13:42 as Reply to Nikita Martyanov

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

or register to reply.

Notify Moderator