I´m searching for a report or a functionality in ARIS, that is able to find all objects in a group that don´t occure in any model.
I thought there would be a standard functionality in ARIS that would help me with this problem but I couldn´t find it.
Can anyone help me with this question?
Kind regards
Marco
Thanks,
Re-organize - was just the function I was looking for
Marco
Hi David,
I am trying to implement your abovre provided solution, could you please provide me a step by step procedure on whre should I be pasting this code and how should I be running it. Require urgent assistance if you could so.
Thanks & Regards,
Tarun R.
Here is the exact code that we utilize to archive unused objects into an unused folder. There are very specific criteria that you need to follow for this to work
1) You must have an Object Repository Group and this code runs against that group (this assumes all your objects are filed in a single group)
2) There are sub groups for every object type that you have. Ie, a group called "Events", "Functions", "Positions" etc.
Here is a step by step of what it does:
var oOutput = Context.createOutputObject(); // Output object
var nLocale = Context.getSelectedLanguage(); // Selected database language
var oSelGroups = ArisData.getSelectedGroups();
var today = new Date();
var one_day=1000*60*60*24; //This is one day based on milliseconds 1000 milliseconds * 60 seconds * 60 minutes * 24 hours
var isStage = false;
var countUnusedObjects = 0;
var objectRepositoryGroup = [];
var unusedGroup;
var foundUnusedGroup = false;
//Find the unused object repository groups
for (var n = 0; n < oSelGroups.length;n++)
{
var selGroupChildren = oSelGroups[n].Childs(true);
for (var m = 0;m<selGroupChildren.length;m++)
{
if (selGroupChildren[m].Path(nLocale).toUpperCase().contains("UNUSED"))
{
unusedGroup = selGroupChildren[m];
foundUnusedGroup = true;
}
else
{
objectRepositoryGroup.push(selGroupChildren[m]);
}
}
}
//create the unused group if we have too
//This assumes only one folder is selected, that is the object repository folder
if (!foundUnusedGroup && oSelGroups.length > 0)
{
unusedGroup = oSelGroups[0].CreateChildGroup("Unused", nLocale);
}
for (var n = 0; n < oSelGroups.length;n++)
{
var aObjects = oSelGroups[n].ObjDefList(true);
for (var i = 0; i < aObjects.length; i++)
{
var objectName = aObjects[i].Name(nLocale);
var objectGroup = aObjects[i].Group().Path(nLocale);
var objectType = aObjects[i].Type();
var objCount = aObjects[i].OccList().length
if (objCount == 0 && objectGroup != unusedGroup.Path(nLocale))
{
oOutput.OutputLn("Object: " + objectName, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn(" - Occurence: " + objCount, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn(" - Group: " + objectGroup, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
var attrList = aObjects[i].AttrList(nLocale);
//We go through the attributes, set the last change date to today
for (var m=0;m<attrList.length;m++)
{
var attrType = attrList[m].Type();
var attrValue = attrList[m].getValue();
var somethingToWasteSpace = "";
if (attrType.toUpperCase().contains("LAST CHANGE"))
{
var lastChangeDt = new Date(attrValue);
//This gets the last time it was changed
oOutput.OutputLn(" - Last Changed Date: " + lastChangeDt, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn(" - Days between Change: " + Math.ceil((today.getTime()-lastChangeDt.getTime())/(one_day)), "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
attrList[m].setValue(today); //This command updates the last change to the current date and time
}
}
//We now move this object into the unused folder
if (!isStage)
aObjects[i].ChangeGroup(unusedGroup);
countUnusedObjects++;
}
}
}
oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("Count of unused objects: " + countUnusedObjects, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("---------------------------------", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("Objects Moved", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
//========We now go through all the unused objects and move the ones that are used back to the right folders=========
var unusedObjects = unusedGroup.ObjDefList(true);
var movedUnusedObject = false;
for (var n=0;n<unusedObjects.length;n++)
{
var objCount = unusedObjects[n].OccList().length;
var objType = unusedObjects[n].Type();
if (objCount > 0)
{
for (var m = 0; m < objectRepositoryGroup.length;m++)
{
if (objectRepositoryGroup[m].Path(nLocale).toUpperCase().contains(objType.toUpperCase()))
{
if (!isStage)
unusedObjects[n].ChangeGroup(objectRepositoryGroup[m]);
movedUnusedObject = true;
}
}
//If we can't find the directory move it to the unknown directory
if (!movedUnusedObject)
{
for (var m = 0; m < objectRepositoryGroup.length;m++)
{
if (objectRepositoryGroup[m].Path(nLocale).toUpperCase().contains("UNKNOWN"))
{
if (!isStage)
unusedObjects[n].ChangeGroup(objectRepositoryGroup[m]);
movedUnusedObject = true;
}
}
}
oOutput.OutputLn("Object: " + unusedObjects[n].Name(nLocale), "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn(" - Occurence: " + objCount, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn(" - Group: " + unusedObjects[n].Group().Path(nLocale), "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
}
movedUnusedObject=false;
}
//========Lastly, we go through the unused folder again, look for objects that haven't been updated in the last 35 days. Remove them=========
oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("---------------------------------", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("Deleted Objects", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
//Get the used objects again
unusedObjects = unusedGroup.ObjDefList(true);
var toDelete = false;
for (var n = 0; n < unusedObjects.length;n++)
{
var attrList = unusedObjects[n].AttrList(nLocale);
for (var m=0;m<attrList.length;m++)
{
var attrType = attrList[m].Type();
var attrValue = attrList[m].getValue();
if (attrType.toUpperCase().contains("LAST CHANGE"))
{
var lastChangeDt = new Date(attrValue);
if (Math.ceil((today.getTime()-lastChangeDt.getTime())/(one_day)) > 35)
toDelete = true;
}
}
if (toDelete)
{
oOutput.OutputLn("Object: " + unusedObjects[n].Name(nLocale), "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn(" - Group: " + unusedObjects[n].Group().Path(nLocale), "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
oOutput.OutputLn(" - Type: " + unusedObjects[n].Type(), "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);
//uncomment this command when i am ready to delete stuff
unusedGroup.Delete(unusedObjects[n]);
}
toDelete = false;
}
oOutput.WriteReport();
Hi David,
Really appriciate your elaborate response, I tried running the above code and as you said by creating a repository too, but I am not sure if am posting the code at the right location.
See what I am currently doing is,
1. I create a report in Local > scripts module > Evalutaion > Reports > and then create a new report in design view. And here the option I choose is running the report at database level.
2. Then I paste the code and run it on my database. Then a pop up appears asking for in which format I would like to have my output, excel doc pdf etc...
Am I following the right steps in concern with pasting your code and running it at the right place. My aim is to know where could I paste the code and the procedure to run it.
Thanks again for your help and concern :)
Regards,
Tarun R.
Yep, Reports folder, create a new report, you want to uncheck Opens Dialog Box (since we aren't prompting for information from the user), you want it to Write to Database checked and you want Available to Users checked. Next screen you want to run it on groups and have the output create a PDF file only.
Copy and paste the code in and run it against your object repository.
Hi David,
It's working perfectly fine. Thanks a lot for your imputs for the same :)
Regards,
Tarun R.
David Tse on
If you go to administration, you can right click the database and do re-organize. This will remove all unused objects (assuming you are looking for just removing the objects).
Here is some code for a custom script I built. This is the part that finds the unused objects. The actual script goes through all objects in a database, finds unused objects and moves them to an "unused" folder. It will check back in 35 days and remove the object if it is not used. If it is used, it will move it to the appropriate object folder.
var oOutput = Context.createOutputObject(); // Output object var nLocale = Context.getSelectedLanguage(); // Selected database language //var aModels = ArisData.getSelectedModels(); // Array of selected models var oSelGroups = ArisData.getSelectedGroups(); var countUnusedObjects = 0; for (var n = 0; n < oSelGroups.length;n++) { var aObjects = oSelGroups[n].ObjDefList(true); for (var i = 0; i < aObjects.length; i++) { var objectName = aObjects[i].Name(nLocale); var objectGroup = aObjects[i].Group().Path(nLocale); var objectType = aObjects[i].Type(); var objCount = aObjects[i].OccList().length if (objCount == 0) { //THIS IS THE UNUSED OBJECT, DO SOMETHING WITH IT countUnusedObjects++; } } } oOutput.OutputLn("", "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10); oOutput.OutputLn("Count of unused objects: " + countUnusedObjects, "Arial", 10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 10);