Find Software installed date from k1000.
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.
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
-
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. - chucksteel 9 years ago
-
Above query do get us the Install_Date for most of Software but not for all applications . - rock_star 9 years ago
-
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 9 years ago
-
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 . - rock_star 9 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
