What field do you use for historical software install dates?

pavan Punna
Tera Contributor

Hi everyone,
Our SAM team needs to find the historical installation dates of software to validate against older vendor invoices (e.g., verifying if a user installed an app in 2024 vs 2026). The  install_date  field is mostly empty since discovery tools (like Tanium) don’t pull historical registry dates out of the box.
I initially suggested using the  sys_created_on  (Created) date on the  cmdb_sam_sw_install  table. However, we found this is unreliable because if an endpoint drops off the network or misses a scan, ServiceNow deletes the install record. When the machine is scanned again later, it creates a brand new record, resetting the Created date to “today.”
Since we can’t rely on  install_date  or  sys_created_on , what fields or data points are you using to accurately compare installed software against historical invoice dates? Are there any out-of-the-box ServiceNow fields we might be overlooking for this use case?

0 REPLIES 0