/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Find Software installed date from k1000.

02/10/2015 3011 views
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 .

Be the first to answer this question

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