Alerts and Emails for licensing in the K1000 SMA
Hi there folks.
Just wondering what the best way is to set some sort of alert or notification (preferably email),
to let some users know about license compliance issues.
Say the number of available licenses left is less that 10 from total license
count, then we send an email or an alert.
Or say if our surplus or variance in the license compliance hits a certain threshhold,
I would like to alert the sales team to make adjustments to our next purchase.
I cant seem to find any way to configure alerts to the license compliance section.
Thank for all the help in advance...
Answers (1)
There is no "out of the box" solution here, you could use the following SQL as a report which will give you details of all products approaching compliance. You could then run the report as a schedule, with the "Don't send Empty Reports" box ticked
SELECT ID, PRODUCT_NAME, VARIANCE
FROM SAM_COMPLIANCE_SUMMARY
WHERE VARIANCE <= 10
You could also turn this code into a ticket rule and add in your email as a variable, so the SELECT Statement will look like this
SELECT
ID as ID,
PRODUCT_NAME as PRODUCT,
'YourEmail@YourDomain.co.uk' AS EMAIL_ADDRESS,
VARIANCE as VARIANCE
FROM SAM_COMPLIANCE_SUMMARY
WHERE VARIANCE <= 10
You can then tick the "Email each recipient in query results" Place EMAIL_ADDRESS as the "Column Containing Email Addresses".Give it a title and add to the Message box
$product - $variance
No need for an Update statement, just set the schedule to run once a day/week/month and you will get regular emails if products near compliance
Comments:
-
Thanks Hobbsy. Thanks for taking the time for all these details. Will give it a shot. Cheers. - akmagnum 6 months ago
