NEW SCCM SQL query - List Configuratin Item current values for specific Baseline and Collection

[huncut]

Hi All,

Would it be possible, to list curent values for configuration items, whether CI status is compliant/non-compliant, for specific C.Baseline and COllection?
So query CB for its CI members for specific collection.
Report rows would be devices, and report Columns would be CI name.

Thank you
Huncut

 

[Garth]

Hi All,

Would it be possible, to list curent values for configuration items, whether CI status is compliant/non-compliant, for specific C.Baseline and COllection?
So query CB for its CI members for specific collection.
Report rows would be devices, and report Columns would be CI name.
View attachment 4177
Thank you
Huncut

have you looked at the builtin reports for this? This would be my first place to look.