SCCM SQL Query to get Client Settings

Boopathi S 3,386

Hello,

There are 100+ client settings created under \Administration\Overview\Client Settings.

How to get each all the client settings of 100+ Client settings. Please share if any SCCM SQL query exists.

AllenLiu-MSFT 44,421 Reputation points Microsoft Vendor

2024-10-02T01:39:30.0966667+00:00

I test Sherry's query in my lab, it works well, have you try it?

1 answer

Sherry Kissinger 4,641 Reputation points

2024-10-01T18:07:13.5933333+00:00

Not perfect, but it's a start:

Select

cs.Name 'ClientSettings Name In the Console'

,ca.Name 'Policy Section'

,cap.Name 'Policy Element'

,capv.DwordValue, capv.StringValue, capv.XmlValue

from ClientAgentProperty_Value capv

join vSMS_ClientSettings cs on cs.id = capv.ClientSettingsID

join ClientAgentProperty cap on cap.ID=capv.PropertyID

join clientAgent ca on ca.ID=cap.ClientAgentID
Please sign in to rate this answer.

1 person found this answer helpful.
Sherry Kissinger 4,641 Reputation points

2024-10-01T18:39:03.28+00:00

More info (with caveats)

/**

If you want the Schedules decoded, check this out. It's dated...but still works.

However, because you are not supposed to 'ever' modify the cm_ database, either make a new database,

or leverage the 'MASTER' database to store these functions, and then just 'call them' from your sql

https://sccmnotes.wordpress.com/2017/06/13/decoding-the-sms_scheduletoken-in-t-sql/

**/

Select

cs.Name 'ClientSettings Name In the Console'

,ca.Name 'Policy Section'

,cap.Name 'Policy Element'

,capv.DwordValue, capv.StringValue, capv.XmlValue

,case when len(capv.stringvalue) = 16 then [CustomDB].[dbo].fn_ParseScheduleTokenString

end as 'Schedule'

,irc.ClassName, irc.SMSClassID,irc.PropertyName

from ClientAgentProperty_Value capv

join vSMS_ClientSettings cs on cs.id = capv.ClientSettingsID

join ClientAgentProperty cap on cap.ID=capv.PropertyID

join clientAgent ca on ca.ID=cap.ClientAgentID

left join v_InventoryReportClass irc on irc.InventoryReportID=capv.StringValue

order by cs.name, ca.name
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SCCM SQL Query to get Client Settings

1 answer

Your answer