I am trying to find Software install date on all the machine available on the network.

select
S.DISPLAY_NAME as SOFTWARE_NAME,
S.DISPLAY_VERSION as VERSION,
M.NAME as MACHINE_NAME,
S.INSTALL_DATE as INSTALL_DATE,
M.ID as MACHINE_ID
from MACHINE M
left join MACHINE_SOFTWARE_JT MSJ ON M.ID = MSJ.MACHINE_ID
left join SOFTWARE S ON MSJ.SOFTWARE_ID = S.ID
where S.ID = 10

I do get install date from this report but some of them (software) install date are not getting populated.

For almost all of the software whose Install Date is not getting populated has their INSTALL DATE in inventory.xml as well as on the ARP.



4 Comments   [ + ] Show Comments

Comments

  • The INSTALL_DATE column in the software table isn't machine specific. If you want to know when a particular title was installed on a machine you will need to use the asset history and look for the string containing when the title was detected.
  • Above query do get us the Install_Date for most of Software but not for all applications .
  • Also you may not be able to find the installation date if the software was already on the machine when the agent was installed and inventory created
  • Hobbsy : I had made inventory then ran a report . I could see installed date of software are being pushed from client (inventory ) to server but report didn't had it .
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity