topic How can I get the Database application IDs in Splunk AppDynamics

How can I get the Database application IDs

CommunityUser — Tue, 03 Jul 2018 07:22:44 GMT

Hi,

I have a DB Monitoring enabled and some HRV configured, so when I view the details of a violation, I can see in the URL an Application ID which is not any of my Applications... If I try to get the HRVs for this unknown application ID through the REST API, it is succesfully returning the violations for my database.

How can I get the application IDs for each of my databases other than manually expecting the URL in the browser for each of them?

The rest calls I am using are:

/controller/rest/applications/458/problems/healthrule-violations?time-range-type=BEFORE_NOW&duration-in-mins=3600

But if I try:

/controller/rest/applications

I don't see application with id 458

Re: How can I get the Database application IDs

CommunityUser — Tue, 03 Jul 2018 08:50:17 GMT

So... it seems I figured out this one as well, but if someone can confirm it would be nice:

It seems like the application Id wich I see in the URL is not different for every application but that is actually the id of the internal "Database Monitoring" application. Meaning that I can get HRVs from the API for all the databases with a single request against the "Database Monitoring" app or its internal ID.

Re: How can I get the Database application IDs

Yogesh_Chouk — Tue, 03 Jul 2018 10:46:25 GMT

Hi,

Yes, that is correct. Database Monitoring is itself an application. As you already checked the Database Monitoring application id, you can use it to retrieve HR violations.

Please follow docs for more information.

https://docs.appdynamics.com/display/PRO43/Alert+and+Respond+API#AlertandRespondAPI-RetrieveAllHealthRuleViolationsinaBusinessApplication

Thanks,

Yogesh

Re: How can I get the Database application IDs

CommunityUser — Mon, 26 Nov 2018 15:31:20 GMT

So how do I find out what this magic application ID is?

Re: How can I get the Database application IDs

CommunityUser — Tue, 27 Nov 2018 21:25:06 GMT

Hi @Anonymous

We thought the new REST API released in version 4.5.4 might be of your interest. Using this API you can fetch the list of your monitored Database Servers and their details.

Product Update, November 2018 (v4.5.4) provides complete information on what's new in v4.5.4.

Hope it helps.

Re: How can I get the Database application IDs

CommunityUser — Wed, 28 Nov 2018 07:21:27 GMT

Hi,
Thanks for the message and bringing my attention to this updated API. I will definitely review and get use of it!

Lyubo