SCCM SQL Query to get file name path and details

Question

_{Friday, January 29, 2016 6:43 PM}

Hi Folks,

I need to get report how many user machines have abc.xml file in specific location .

For example :

abc.xml file will be C:\Program files\XYZ\abc.xml

Now I need report which contains this abc.xml file

Can anyone help

Please click answer If it works Thanks KMI

All replies (3)

_{Friday, January 29, 2016 7:35 PM ✅Answered | 1 vote}

I would use a CI to do this. Then you can report on who is complaint or not.

Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

_{Monday, February 1, 2016 7:28 AM ✅Answered | 1 vote}

Dear Sir,

Concur with Garth. Quick search and got below an step-by-step example for your need:

https://sccmdiet.wordpress.com/2014/09/10/sccm-2012-configuration-items-configuration-baselines-compliance-settings-part-4/

Best regards

Frank

_{Tuesday, February 2, 2016 7:48 AM}

Thank you both

Please click answer If it works Thanks KMI