I am looking to create a report for all of my monitored PCs that will show me all new software installed on endpoints each day. I don't believe our K1000 environment has this report currently. Has anyone developed one already?

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

4

In 5.4 only. This will not show the exact time the software was installed, but it will show when a change occured based on the last inventory. Change the "1 DAY" to match what you need.

SELECT NAME, TIME, VALUE1 as Software, VALUE2 as Version

FROM ASSET_HISTORY A

WHERE FIELD_NAME = 'SOFTWARE'
AND CHANGE_TYPE = 'DETECTED'
AND TIME > DATE_SUB(NOW(), INTERVAL 1 DAY)
ORDER BY NAME
Answered 04/09/2013 by: dugullett
Red Belt

  • this assumes you're running this close to midnight as it really means "software installed in the last 1440 minutes"

    I find what most people intend is :"everything from the entire calendar day yesterday and today so far":
    and TIME > date_sub( curdate(), interval 1 day)

    e.g. if you run this at midnight you get the same answer as what is above, but if you run it midday you don't lose yesterday morning's entries.

    if you're running it daily it shouldn't matter too much, but the above is important when the big boss comes knocking and you run it adhoc and the wonder why it's missing what is showed earlier.

    p.s. i wish i could format comments
    • I agree Gilly.... I created this one a while back.

      http://kace.uservoice.com/forums/139919-itninja/suggestions/2936287-add-the-ability-to-format-selected-text-as-code-in
Please log in to comment

Answers

0

The only way I know of to get the install date would be to use wmic to query the machines as a custom software inventory item and then run a report on that software.

I created one for the year 2013, since it brings it in as one string with this simple query you would need an item for everyday to use it as is.  You would have to manipulate the output or create an item that returns the query as mutliple strings using the /output and /format:sortby options then run a report to create a more generic software item

You may be better off running something like a pstools batch job to query the machines with wmic and report back to you each day.

Answered 04/09/2013 by: SMal.tmcc
Red Belt

  • I would go with dugullett or
    put in a enhancement request to add this feature
    http://kace.uservoice.com/forums/82699-k1000
Please log in to comment
Answer this question or Comment on this question for clarity