Discussion Feed

Due to the limitations of dashboarding in AppD, we're going to be trying to move some data over to Power BI as the front end.   I've been following along with the below article, which has helped a great deal.   https://community.appdynamics.com/t5/Knowledge-Base/How-do-I-retrieve-metrics-and-so-I-can-display-them-with/ta-p/39478   The problem I'm running into is with custom metric paths. When I get the URL from the controller, it looks something like this:   https://allscripts-dev.saas.appdynamics.com/controller/rest/applications/Server%20&%20Infrastructure%20Monitoring/metric-data?metric-path=Application%20Infrastructure%20Performance%7CRoot%5C%7CPROD%5C%7CSCMCON%7CIndividual%20Nodes%7CSCM-AG2-18.4-HOSTED-AG0SCM2ASC2S001-java-MA%7CCustom%20Metrics%7Callscripts-300-second-monitors-duration&time-range-type=BEFORE_NOW&duration-in-mins=60   Here it is decoded for easier reading:   https://allscripts-dev.saas.appdynamics.com/controller/rest/applications/Server   & Infrastructure Monitoring/metric-data?metric-path=Application Infrastructure Performance|Root\|PROD\|SCMCON|Individual Nodes|SCM-AG2-18.4-HOSTED-AG0SCM2ASC2S001-java-MA|Custom Metrics|allscripts-300-second-monitors-duration&time-range-type=BEFORE_NOW&duration-in-mins=60   The problem comes into play with the hierarchy paths. Web servers are all over the place, scattered throughout different hierarchy paths. For the server above, It's in the |PROD|SCMCON| portion of the path that I'm stuck on. I'm struggling with figuring out code that will work like an AppD Dashboard where I can select "All Servers" and get back data for this metric from all of them. I can replace "|SCM-AG2-18.4-HOSTED-AG0SCM2ASC2S001-java-MA|" with "|*|" which works, but I don't get any data when I try to use |*|*| in place of the |PROD|SCMCON| portion of the URL.   Any guidance or assistance would be appreciated. ... View more

Question about working with Json data.   So I have a template file that is in json format that I need to work with. Within that Json file there are a bunch of different "widgets". Within each widget, there is a listing of "entity" names, one per server (but invalid servers that need removed and replaced with this script).   I need to import this json file. Go into each widget. Look at the formatting of the existing entities, save that. Remove all the existing entities. Then add an entity for each server in my serverlist using the formatting template I saved.   The entities I need to remove are deep into the file, so that may throw a cog into this. I have attached a screenshot of the entities that need to come out, you can see they are under .entityNames within each widget.   Any tips or suggestions would be helpful. I've been researching myself online. The following text can be copied and pasted into your code editor:   # So far I'm able to successfully import my json data using this code $jsoninput = Get-Content -Path "$thisfolder\APPD-DASHBOARD-GENERATOR.input.json" | ConvertFrom-Json # I then run a foreach against each widget found within the json. foreach ($widget in $jsoninput.widgetTemplates) { # I then look up the first entity in the widget, I'm going to use this as a template later. $first1 = $widget.dataSeriesTemplates.metricMatchCriteriaTemplate.entityMatchCriteria.entityNames| Select-Object -First 1 # I then need a method for removing each of the existing entities found... foreach ($entity in $widget.dataSeriesTemplates.metricMatchCriteriaTemplate.entityMatchCriteria.entityNames) { !!! Not sure what to do here !!! } # I then need a method for adding an entry for each server found in the server list. foreach ($server in $servers) { # I have this template from earlier $first1   }   } ... View more