Find out which Databases are in use

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

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

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

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