How to create custom facets in AppInternals Xpert so that they can be used for grouping common elements in Dashboards?

How to add custom facets in AppInternals Xpert so that they can be used for grouping in Dashboards?

The following demonstrates an example where custom grouping is performed using custom facets in AppInternals Xpert based on SQL statement or procedure name

1. Locate following file/s under the AppInternals Xpert SMP installation directory config/webdashboards/facets.local.template or config/webdashboards/facets.local.properties. Only edit the .local.template file if the .local.properties file does not exist. Open it in a good text editor.
2. Next, pick the right option for your case from below
   • If you are editing the .local.template file it will only have one uncommented line (NumberOfCustomFacets=0) replace that line with following three lines:

   NumberOfCustomFacets=1
CustomFacetName1=DB Statement - Procedure
CustomFacetType1=Host > Java > JDBC > Statement;Host > Java > JDBC > Procedure;Host > .NET > ADO > Statement;Host > .NET > ADO > Procedure


   
   
   • If you are editing the .local.properties file locate the NumberOfCustomFacets element and increment it by 1 (NumberOfCustomFacets=X) and add the following two lines to the bottom of the list of facets replacing X with the total number of facets:

   CustomFacetNameX=DB Statement - Procedure
CustomFacetTypeX=Host > Java > JDBC > Statement;Host > Java > JDBC > Procedure;Host > .NET > ADO > Statement;Host > .NET > ADO > Procedure


   
   
   • If you are editing the .local.properties file then simply save the file. If you are editing the .local.template file you need to save file as facets.local.properties in the same location as facets.local.template
3. After making above changes as applicable to your case restart AppInternals Xpert SMP services on the data source server machine.
4. Restart the dashboards service on the dashboards server
5. Now, in dashboards look for existing elements and objects in dashboards that would be under following hierarchy Host > JAVA > JDBC > Statement or Host > .NET > ADO > Statement or Host > .NET > ADO > Procedure or Host > Java > JDBC > Procedure
6. Notice DB Statement - Procedure now shows up in the Group By drop down in addition to already existing facets like Data Source, Metric Display Name, Host, Operating System, Object, Object Type, Metric/Template so that you are now able to create grouping for these elements based on the new facet