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
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
In reply to Hello Bennet, 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
In reply to Hi Nikita, 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()
}
}
In reply to Hi Bennet, by billie1989
