/build/static/layout/Breadcrumb_cap_w.png

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
  • Ok, so do you want an email alert that tells you when a software download is used? Or do want an alert that tells you when a new version of a software application is available? Or do you want to send an alert to others when you upload a new item to user download section? - Hobbsy 3 years ago
    • i'd like an email when i (ore one of my colleagues) add a new software availble in the service desk -> user downloads - c.castellari 3 years ago
    • "Or do you want to send an alert to others when you upload a new item to user download section?"

      This :) - c.castellari 3 years ago

Answers (2)

Posted by: JasonEgg 3 years ago
Red Belt
1

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 3 years ago
Posted by: c.castellari 3 years ago
Orange Senior Belt
0
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)

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ