Query based on File Modified date

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/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.




 

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

Resolution

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:

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for image>

Browse to the outdated amdkmpfd.sys file and specify the date range:

<Please see attached file for image>

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

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for image>

Create a Software Policy to push the Updated Driver package to the Query Group:

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for 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