1) Reading the Software update classification from ConfigMgr using SQL
In order to get the Software update Classifications sync Settings we caneed to look into the V_UpdateCategoryInstances our Information, we would use the following query:
Select CategoryInstanceName,IsSubscribed from v_LocalizedCategories as loccat
join v_UpdateCategoryInstances as upcat on loccat.CategoryInstanceID = upcat.CategoryInstanceID
Where CategoryTypeName = 'UpdateClassification' AND AllowSubscription = '1'
And here is what it looks like when you run the query to get the Software update classification