/build/static/layout/Breadcrumb_cap_w.png

Software Question


K1000 ticket rule for announce new softwares availble in the Service Desk User Downloads

07/06/2017 818 views
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

Comments

  • 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?
    • i'd like an email when i (ore one of my colleagues) add a new software availble in the service desk -> user downloads
    • "Or do you want to send an alert to others when you upload a new item to user download section?"

      This :)


Community Chosen Answer

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.
Answered 07/14/2017 by: JasonEgg
Red Belt

  • I really thank you for your code. Now i've modified it for my goal. Now, for me, it's perfect :)

All Answers

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)
Answered 08/10/2017 by: c.castellari
Orange Senior Belt

 
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