[mssms] RE: Compliance Baseline report

I recently put this together for a report we use to look at a lot of information on a computer. This is the DCM part. (FYI, we are using build 1602) SELECT ba.AssignmentName, ciinfo.DisplayName, ciinfo.Description, v_CISettings.SettingName, v_CISettings.SettingDescription, CASE WHEN cs.Complianc

[mssms] Odd exit code during OSD

I've Googled, but haven't found any definitive answers. We have some ports that used wired NAC and computers connected to these ports require special network settings in order to connect. We're trying to change these settings during OSD with package that contains a PowerShell script (shown below).

[mssms] RE: Query for servers pending reboot - software update compliance

Try: SELECT DISTINCT vrs.ResourceID ,vrs.ResourceType ,vrs.Name0 ,vrs.SMS_Unique_Identifier0 ,vrs.Resource_Domain_OR_Workgr0 ,vrs.Client0 FROM v_r_system vrs Inner Join vSMS_Update_ComplianceStatus ucs ONucs.machineid = vrs.resourceid WHERE ucs.LastEnforce

[mssms] Query for servers pending reboot - software update compliance

Hello all, I'm trying to take the following query and modify it specifically for SERVERS. Can someone help me out with what changes I need to make? Thanks you, Brian SELECT DISTINCT vrs.ResourceID, vrs.ResourceType, vrs.Name0,vrs.SMS_Unique_Identifier0, vrs.Resource_Domain_OR_Workgr0,vrs.Cli

[mssms] Compliance Baseline report

I need to create a report that provides the compliant and non compliant counts for specific compliance baselines. Does anyone have sample SQL for something like that? There is a technet article with some samples but they are not getting exactly what I need. Just looking for the wisdom of the g