Hi Ryan, No i havent received solution for the same. I tried as below but receiving error. #set($splitMessage = $eventMessage.split("<br>")) #set($Message = $splitMessage[6]) Health Rule Violation: ${latestEvent.healthRule.name} What is impacted: $impacted Summary: ${latestEvent.summaryMessage} Event Time: ${latestEvent.eventTime} This is an automated message from AppDynamics. Subject : Health Rule Violation - ${latestEvent.healthRule.name} Impacted Component: $impacted Message = $Message
... View more
Hi
When using email templates, how do I capture the current threshold value configured and the value that was observed.
with the below template, I couldn't get the threshold value and actual observed value
Health Rule Violation: ${latestEvent.healthRule.name}
What is impacted: $impacted
Summary: ${latestEvent.summaryMessage}
Event Time: ${latestEvent.eventTime}
Threshold Value: ${latestEvent.threshold}
Actual Observed Value: ${latestEvent.observedValue}
Output:
... View more
Issue is with db schema. The Appleid field was created earlier and deleted, but due to indexing it might have not been deleted. The new field that we are seeing AppleId(notice the i in id) now, is the one we are seeing but there are two fields showing in the backend. we had performed a rollover/indexing to have the old field deleted. And it resolved the issue
... View more
I am pushing values from power automate to appd schema. All values getting captured under APPd schema but not AppleId which is email ID which i defined as string here appleId value is null why is it not capturing the value
... View more
Hi Mario, Thanks for the update. Since its not creating updated values, we have applied formula at power automate itself. Now issues is "type": "string",
"value": "abcd@ef.gh.com" value ""abcd@ef.gh.com""not poping up under AppD schem , though the value is getting parsed. I have initiated as string and earlier it worked , once i have deleted schema and created again, value showing as null
... View more
we are feeding data for every 5 mins and if you see the data its 229 all the time in metric graph where as when we execute the query its different 219 value. 16/12/2024 23:55:00,46,0,229,229,5 17/12/2024 23:55:00,46,0,229,229,5 18/12/2024 23:55:00,46,0,229,229,5
... View more
Hi Mario, Thanks for the response. When i added the query as metric, i m getting old value. For ex, the expiration days are 219 days. but it shows 229 days on the day when i created the metric. why is that it not showing the current value. the value is not changing.
... View more
Hi Mario, Thanks, query worked as we input max can we do to alias the result filed name (toInt((tokenExpirationDateTime - now()) / (24*60*60*1000)))) to tokenExpirationDateTime
... View more
Hi Ryan, Support provided query for which we are unable to create metrics . we have tweeked s below SELECT (toInt(tokenExpirationDateTime - now()) / (24*60*60*1000)) AS daysleft FROM intune_dep WHERE tokenName = "Wipro-EY-Intune" AND (toInt(tokenExpirationDateTime - now()) / (24*60*60*1000)) >= 30 and when created metrics we are getting error Following fields (toInt(tokenExpirationDateTime - now()) / (24*60*60*1000)) AS daysleft in the select clause are not supported. could you help on the query
... View more
1] Tried using Until since to pull the no of days between the expirationDateTime and system date, based on token name as we have many token names expirationDateTime eventTimestamp pickupTimestamp 2025-07-26T23:00:03+05:30 2024-11-21T17:06:33+05:30 2024-11-21T17:06:33+05:30 Token name AppD can you suggest the query to be used such that we get value in no of days the certificate gets expired
... View more