Query based on File Modified date

Document ID : KB000112346
Last Modified Date : 29/08/2018
Show Technical Document Details
Introduction:
The software on some of the computers in my environment needs to be updated.  I can tell by the modified date of some of the files if the software needs to be updated.




 
Question:
I would like to scan all machines and query against the file version of a hardware driver. The file is amdkmpfd.sys. I have a script to update the driver, but would like to only run the script if the existing file version is older than a certain date. 
Environment:
Windows
Answer:
Create a new software signature for amdkmpfd.sys specifying the file version to be older than the required date:
After the new signature is run and collected on all machines it will list only the machines with the older file that needs updating.
Create an SD package for the updated driver script. 
A computer group can then be made based on a software query for computers having that software signature installed and not having the updated driver installed.
Once the query group is created an SD policy job can be made deploying the updated driver package to that group.
See below for more details:

Create a new signature definition for the outdated driver:
User-added image
User-added image
User-added image

Browse to the outdated amdkmpfd.sys file and specify the date range:
User-added image

Create a new group based on a query for the signature AND NOT having the updated Driver package installed:
User-added image
User-added image
User-added image
User-added image
User-added image

Create a Software Policy to push the Updated Driver package to the Query Group:
User-added image
User-added image
User-added image
User-added image
User-added image
 
Additional Information:
Please reference the following technical documents for creating signatures and software policies:

KB000011305 
https://comm.support.ca.com/kb/how-do-you-create-a-custom-signatures-to-find-software/kb000011305

KB000015682 
https://comm.support.ca.com/kb/how-to-create-a-software-based-policy-to-deploy-the-am-and-rc-agent-plugins-to-machines-that-have-already-been-pushed-the-sd-agent-and-then-to-reboot-the-machines/kb000015682