Find Objects, that don´t occure in a model

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); 

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:

• Scan through all the sub folders and find all the “Object Repository” folders and finds the “Unused” folder
  • This assumes the report is being run on the object repository folder
• If it can’t find the unused folder, it will automatically create one
• Go through every object in the Object Repository and their sub folders (excluding the unused folder)
  • If there are 0 occurrences for that object (Ie, the object is never used in a model), move it to the “Unused” folder.
    • Go through all the attributes and find the “Last Changed” attribute and update it to today’s date and time
• Go through every object inside the “Unused” folder
  • If the object has 1 or more occurrences
    • Find the type of object and move it into the corresponding Object Repository Folder
    • If the Object Repository folder type doesn’t exist than it will put it into the unknown folder
• Lastly, we go through every object inside the “Unused” folder again
  • We look for the “Last Changed” attribute and determine the number of days between “Last Changed” and today
  • If the “Last Changed” date is greater than 35 days we delete it from the unused folder
    • The “Last Changed” date is updated when it gets moved to the unused folder
• Generate report of all the Objects that were moved to the unused folder, all the objects that were moved from the unused folder into the correct Object Repository Folder, and the objects that were removed

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.