K1000 ticket rule for announce new softwares availble in the Service Desk User Downloads
Hi, and sorry for my bad english :(
we use K1000 (latest version) for many things. One oh these is the User Downloads in the User console Portal (our users are not administrators of theri PC, so we deploy useful software on-demand via the User Console).
It's possibile to schedule something (like a custom ticket rule) that looks in the User Downloads section and announces via email to me and some other my coleagues the new downloads i add or i update with newer versions of the same software? (i.e. Java 8u121 -> 8u131)
Thank you :)
1 Comment
[ + ] Show comment
Answers (2)
Please log in to answer
Posted by:
JasonEgg
7 years ago
Here is a report that will show you the Software Library items created in the past hour:
SELECT
SOFTWARE.DISPLAY_NAME AS 'Software Inventory Name',
KBOT.NAME AS 'Script Name',
PORTAL.INSTALLATION_NOTES,
PORTAL.CREATED,
PORTAL.MODIFIED,
PORTAL.ENABLED,
PORTAL.RESTRICT_MACHINE,
PORTAL.NOTES
FROM PORTAL
LEFT JOIN SOFTWARE
ON PORTAL.SOFTWARE_ID = SOFTWARE.ID
LEFT JOIN KBOT
ON KBOT.ID = PORTAL.KBOT_ID
WHERE SUBDATE(PORTAL.CREATED,INTERVAL 1 HOUR) >= NOW()
Create that report, then create a report schedule for that report which runs every hour. Make sure to select "Don't send empty reports" on the schedule creation page. You can change "PORTAL.CREATED" to "PORTAL.MODIFIED" on the final line to report on User Downloads which have been modified in the past hour.
Comments:
-
I really thank you for your code. Now i've modified it for my goal. Now, for me, it's perfect :) - c.castellari 7 years ago
Posted by:
c.castellari
7 years ago
This is my final query. Thanks to @JasonEg
SELECT
SOFTWARE.DISPLAY_NAME AS 'Software Display Name',
KBOT.NAME AS 'Script Name',
PORTAL.CREATED,
PORTAL.MODIFIED,
PORTAL.ENABLED,
PORTAL.RESTRICT_MACHINE,
PORTAL.NOTES,
PORTAL.ID,
LABEL.NAME AS 'Label'
FROM PORTAL
LEFT JOIN SOFTWARE
ON PORTAL.SOFTWARE_ID = SOFTWARE.ID
LEFT JOIN KBOT
ON KBOT.ID = PORTAL.KBOT_ID
LEFT JOIN PORTAL_LABEL_JT
ON PORTAL.ID = PORTAL_LABEL_JT.PORTAL_ID AND PORTAL_LABEL_JT.LABEL_ID <> 0
LEFT JOIN LABEL
ON PORTAL_LABEL_JT.LABEL_ID = LABEL.ID
WHERE TIMESTAMP(PORTAL.MODIFIED) >= SUBDATE(NOW(), INTERVAL 1 DAY)
This :) - c.castellari 7 years ago