- Had a real brain teaser at my new jerb
- Had a real brain teaser at my new jerb
- Keep it Classy, McAfee - Unmainted Web
- Windows Server 2012 - Same Crap, Different Color
- SCCM 2012 Configuration Manager WDS Windows Deployment Servers DHCP PXE Settings
- Cleaning up Duplicate Content on a Drupal Site
- Pasting Images into Word 2013
- Breaking into an ePolicy 3.6 or ProtectionPilot Server - For Fun and Profit
- Nerdymark's Timelapse Machine - Raspberry Pi
- The EXECUTE permission was denied on the object 'Win7DiskUtilizationDrilldownReport', database 'OperationsManagerDW' ...
|
|||
Long story short, there's a stored procedure in the SCCM database that does some bad math to calculate the uniqueness of a SMBIOS GUID. This had me stumped for a week, and finally found probably the only other person on the planet that was having the same problem. Problem solved by adding a few bits to 3 stored procedures. NBS_LookupDeviceFind the line On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid Change to On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid + '.' NBS_LookupPXEDeviceFind the line On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid Change to On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid + '.' MP_GetClientIDFromSmbiosIDFind the line Where (m.smbios_guid0 = @vchsmbiosid) and (isnull(m.obsolete0,0) != 1) Change to Where (m.smbios_guid0 = @vchsmbiosid + '.') and (isnull(m.obsolete0,0) != 1) Big thanks to Moto What's this all about? Symptom: Using SCCM to deploy Windows 7 with PXE to "Unknown Computers". We had everything configured correctly. MICROSOFT had a bug in their SP :)
|
|||
Long story short, there's a stored procedure in the SCCM database that does some bad math to calculate the uniqueness of a SMBIOS GUID. This had me stumped for a week, and finally found probably the only other person on the planet that was having the same problem. Problem solved by adding a few bits to 3 stored procedures. NBS_LookupDeviceFind the line On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid Change to On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid + '.' NBS_LookupPXEDeviceFind the line On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid Change to On xref.machineid = aux.itemkey and aux.smbios_guid0 = @smsbios_guid + '.' MP_GetClientIDFromSmbiosIDFind the line Where (m.smbios_guid0 = @vchsmbiosid) and (isnull(m.obsolete0,0) != 1) Change to Where (m.smbios_guid0 = @vchsmbiosid + '.') and (isnull(m.obsolete0,0) != 1) Big thanks to Moto What's this all about? Symptom: Using SCCM to deploy Windows 7 with PXE to "Unknown Computers". We had everything configured correctly. MICROSOFT had a bug in their SP :)
|
|||
nerdymark posted a photo: |
|||
nerdymark posted a photo: |
|||
nerdymark posted a photo: |
|||
|
|||









