Jump to content


Established Members
  • Posts

  • Joined

  • Last visited

cfreeman21's Achievements


Newbie (1/14)



  1. We have been challenged to get 98%+ on Servers and Workstations and we usually get 9x%. Challenges I am facing are Machines not checking, online, or Not active or not rebooting as they should. What are you all doing to get Patch Compliance as High as possible. Process, Collections, Deployments, etc?
  2. Okay so I have read this somewhere and the way I interpret this i want to make sure is correct. If I stand up a 2012R2 KMS Server and use the Windows Srv 2012R2 DataCtr/Std KMS for Windows 10 Key all Servers Standard/DataCtr/Enteprise and Windows Workstation Windows 10 Below will be activated by this KMS Server? All the KMS Keys at Microsoft VLSC with KMS are only for if you are setting up a machine with that OS and want it to be a KMS right? Next Question if I use 2012R2 will 2016 activate or would it be best to stand up a 2016 KMS? The way i understand this i would need to do the following: Stand-up 2012R2 & Use this Key Srv 2012R2 DataCtr/Std KMS for Windows 10 Add Office Keys 2010/2013/2016 And this will cover my servers and desktops... is a correct assumption?
  3. Windows 7 & Windows 10. Just capture image then install updates via SCCM Console after importing into images? I also want to patch Office and such.
  4. I know there have been changes in software updates by reading starting in 1606... How are you all patching your B&C Image using SCCM... I use SCCM to B&C not MDT... I do have MDT integrated into SCCM.
  5. I am shocked nobody else is looking for this feature... Where I used to work we had Dell and I was able to get this working, but Lenovo is a different animal. Nobody has a working "free" solution for this?
  6. I wanting to start building a home lab using Windows 10 & Hyper-V, but I don't want to have to rebuild my lab every 180/90 days. Does Microsoft not Offer free/cheap licenses for Home Labs? I am not a student, but am a Tech looking to further my skills. What do you all do about licensing and such? I do have a MSDN Subscription through my employer but did not know about usage of those downloads/keys?
  7. Hard Coded main Query: DECLARE @SUG varchar(50); DECLARE @COLID varchar(8); DECLARE @CI_ID int; SET @SUG = 'Software Updates | Servers | 2016' SET @COLID = 'A1200602' SELECT @CI_ID = CI_ID FROM CI_ConfigurationItems WHERE CIType_ID = 9 AND CI_UniqueID = (SELECT CI_UniqueID AS AuthListID FROM v_AuthListInfo WHERE Title = @SUG) SELECT Status = sn.StateName, StatusNumber = (CASE WHEN StateName = 'Compliant' THEN 1 WHEN StateName = 'Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers = CONVERT(float, ISNULL(cs.NumberOfComputers, 0) * 100.00) / ISNULL(NULLIF(cs.NumTotal, 0), 1) FROM (SELECT CI_ID, NumTotal, [0] = NumUnknown, [1] = NumPresent + NumNotApplicable, [2] = NumMissing FROM v_UpdateSummaryPerCollection WHERE CI_ID = @CI_ID AND CollectionID = @COLID) cnt UNPIVOT (NumberOfComputers FOR [Status] IN ([0], [1], [2])) cs LEFT JOIN v_StateNames sn ON sn.TopicType = 300 AND sn.StateID = cs.Status WHERE cs.NumberOfComputers > 0 ORDER BY StatusNumber Both Parameters are just Pulling Available Values Get Values from a query
  8. If I run report with parameters I get blank data, but I hard code them I get data I do not understand why this is happening.
  9. This is the data you want on the report? Are you currently pulling in Email address from Active Directory into SCCM? The display name that outlook uses should be the AD Display name right?
  10. If you put in the Name for Software Update Group and the Collection ID the Main query works I need help getting the parameter to work. Thanks! Main Query: declare @SUG VARCHAR(50); declare @COLID VARCHAR(8); declare @CI_ID int; select @CI_ID = CI_ID from CI_ConfigurationItems where CIType_ID=9 and CI_UniqueID=(select CI_UniqueID as AuthListID from v_AuthListInfo Where Title=@SUG) select Status=sn.StateName, StatusNumber=(CASE WHEN StateName='Compliant' THEN 1 WHEN StateName='Non-Compliant' THEN 3 ELSE 2 END), cs.NumberOfComputers, PercentOfComputers=convert(float, isnull(cs.NumberOfComputers, 0)*100.00) / isnull(nullif(cs.NumTotal, 0), 1) from (select CI_ID, NumTotal, [0]=NumUnknown, [1]=NumPresent+NumNotApplicable, [2]=NumMissing from v_UpdateSummaryPerCollection where CI_ID=@CI_ID and CollectionID=@COLID ) cnt unpivot (NumberOfComputers for [Status] in ([0], [1], [2])) cs left join v_StateNames sn on sn.TopicType=300 and sn.StateID=cs.Status where cs.NumberOfComputers>0 order by StatusNumber Query for SUG Paramter: SELECT CI_UniqueID, Title FROM v_AuthListInfo WHERE Title LIKE '%Compliance%' OR Title LIKE '%Software Updates%' ORDER BY Title Query for COLID Parameter: SELECT DISTINCT c.CollectionID, c.CollectionName FROM v_UpdateSummaryPerCollection c WHERE (CollectionName LIKE '%Patching Group%' OR c.CollectionName LIKE '%Compliance%' OR c.CollectionName LIKE '%Server Patching%' OR c.CollectionName LIKE '%Approved Patching%') ORDER BY c.CollectionName
  • Create New...