Pages

Monday, February 3, 2014

Count Number of Tables,Forms EDT's in AX 2012


To count number of Tables, EDT's, Form's.. etc all objects in AOT . Run the below job to get number of objects available in AOT. 



static void daxCountTablesInAX(Args _args)
{    
    // Count of all the Objects.    
    info (strFmt("Tables in AX: %1", treenode::findNode('\\Data Dictionary\\Tables').AOTchildNodeCount()));    
    info (strFmt("Extended Data Types in AX: %1", treenode::findNode('\\Data Dictionary\\Extended Data Types').AOTchildNodeCount()));    
    info (strFmt("Forms in AX: %1", treenode::findNode('\\Forms').AOTchildNodeCount()));
    info (strFmt("Parts-- Infoparts in AX: %1", treenode::findNode('\\Parts\\Info Parts').AOTchildNodeCount()));
    info (strFmt("Part- Form Parts in AX: %1", treenode::findNode('\\Parts\\Form Parts').AOTchildNodeCount()));
    info (strFmt("Part -- Cues in AX: %1", treenode::findNode('\\Parts\\Cues').AOTchildNodeCount()));
    info (strFmt("Part-- Cue Groups in AX: %1", treenode::findNode('\\Parts\\Cue Groups').AOTchildNodeCount()));
    info (strFmt("DataSets in AX: %1", treenode::findNode('\\Data Sets').AOTchildNodeCount()));
    info (strFmt("SSRS Reports in AX: %1", treenode::findNode('\\SSRS Reports\\Reports').AOTchildNodeCount()));
    info (strFmt("SSRS Reports report style templates in AX: %1", treenode::findNode('\\SSRS Reports\\Report Style Templates').AOTchildNodeCount()));
    info (strFmt("SSRS Report report datasources in AX: %1", treenode::findNode('\\SSRS Reports\\Report Datasources').AOTchildNodeCount()));
    info (strFmt("Report Images in AX: %1", treenode::findNode('\\SSRS Reports\\Report Images').AOTchildNodeCount()));
    info (strFmt("Report Templates in AX: %1", treenode::findNode('\\Reports\\Report Templates').AOTchildNodeCount()));
    info (strFmt("Report Section Templates in AX: %1", treenode::findNode('\\Reports\\Section Templates').AOTchildNodeCount()));
    info (strFmt("Visual Studio Projects of Dynamics AX Model Projects in AX: %1", treenode::findNode('\\Visual Studio Projects\\Dynamics AX Model Projects').AOTchildNodeCount()));
    info (strFmt("Visual Studio Projects of C Sharp Projects in AX: %1", treenode::findNode('\\Visual Studio Projects\\C Sharp Projects').AOTchildNodeCount()));
    info (strFmt("Visual Studio Projects of Web Application Projects in AX: %1", treenode::findNode('\\Visual Studio Projects\\Web Application Projects').AOTchildNodeCount()));
    info (strFmt("Visual Studio Projects of Analysis Services Projects in AX: %1", treenode::findNode('\\Visual Studio Projects\\Analysis Services Projects').AOTchildNodeCount()));
    info (strFmt("Menus  in AX: %1", treenode::findNode('\\Menus').AOTchildNodeCount()));
    info (strFmt("Menu Items Display in AX: %1", treenode::findNode('\\Menu Items\\Display').AOTchildNodeCount()));
    info (strFmt("Menu Items Output in AX: %1", treenode::findNode('\\Menu Items\\Output').AOTchildNodeCount()));
    info (strFmt("MenuItems Action in AX: %1", treenode::findNode('\\Menu Items\\Action').AOTchildNodeCount()));
    info (strFmt("Reports- Report Templates in AX: %1", treenode::findNode('\\Reports\\Report Templates').AOTchildNodeCount()));
    
}

No comments: