it.blo.gg -

Finding duplicate systems in SCCM

Fire up SQL Management Studio and use som of the following queries:

Find duplicate MAC addresses

SELECT dbo.v_RA_System_MACAddresses.MAC_Addresses0, Count(dbo.v_R_System.Name0) AS SystemCount FROM dbo.v_R_System RIGHT OUTER JOIN dbo.v_RA_System_MACAddresses ON dbo.v_R_System.ResourceID = dbo.v_RA_System_MACAddresses.ResourceID GROUP BY dbo.v_RA_System_MACAddresses.MAC_Addresses0 ORDER BY SystemCount DESC

Find ResourceID for the duplicate MAC address

select * from dbo.v_RA_System_MACAddresses where MAC_Addresses0 = '00:00:00:00:00:00'

Find Name0 for the duplicate MAC addresses

select * from dbo.v_R_System where ResourceID = '12345678' OR resourceid = '12345678'

Find duplicate computer names

select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier, R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId full join SMS_R_System as s2 on s2.Name = s1.Name where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId

Find duplicate HardwareID's

SELECT Name0, Hardware_ID0, Count(Hardware_ID0) AS SystemCount FROM dbo.v_R_System GROUP BY Hardware_ID0, Name0 ORDER BY SystemCount DESC

2013-02-21 @ 16:21:00 Permalink Configuration Manager Kommentarer (0) Trackbacks ()

Windows XP bluescreens after OS deployment

Don't forget to include mass storage driver. You can get a driver pack that covers the most models on the link below.

http://www.deployvista.com/Default.aspx?tabid=78&EntryID=130

Create a Driver Package including all the drivers from the link above, then create a Apply Driver Package step in your Windows XP task sequence selecting the newly created Driver Package.

2013-02-20 @ 16:30:44 Permalink Configuration Manager Kommentarer (0) Trackbacks ()

SCCM 2012 Windows XP OSD installing to D:

I've been having issues with Windows XP being deployed to D:, and finally I've found the solution.

There's an error in the MDT task sequence step "Format and Partition Disk 5.x".

In the Options tab there's some conditions, and one condition is:

ImageOSVer equals 5.1 AND ImageOSVer equals 5.2. I will now tell you - THIS WILL NEVER HAPPEN ;)

Change this by adding an If-statement matching ANY of the listed conditions.

Now, the disk will get partitioned and formatted and the OS will end up at C:.

Out!

2013-02-20 @ 15:49:02 Permalink Configuration Manager Kommentarer (0) Trackbacks ()

'Unnamed VM' failed to initialize

Grant full access to the virtual machine’s security identity using the command:

icacls "%SYSTEMDRIVE%\ProgramData\Microsoft\Windows\Hyper-V\Virtual Machines\befde5dd-dc82-4575-9ca7-57625301ccb9.xml" /grant "NT VIRTUAL MACHINE\befde5dd-dc82-4575-9ca7-57625301ccb9":F /l

Repeat this step for the "%SYSTEMDRIVE%\ProgramData\Microsoft\Windows\Hyper-V\Virtual Machines\befde5dd-dc82-4575-9ca7-57625301ccb9 folder as well. Don't forget to replace the new security on all subfolders and files.

2013-02-12 @ 17:09:27 Permalink Hyper-V Kommentarer (0) Trackbacks ()

.NET Framework 3.5

Makes me smile every time! :)

"Download is complete. You can now disconnect from the Internet."

2013-02-12 @ 11:23:31 Permalink Applications Kommentarer (0) Trackbacks ()

WFCRUN32 Error - Failed to set Event Logging

I got this error when deploying Citrix Online Plugin 12.1 and 12.3 on a freshly installed computer. I think it has something to do with User Account Control, but our group policy doesn't disable UAC before System Center tries to install the software.

Seems like adding the option DONOTSTARTCC=1 solves the problem though :)

CitrixOnlinePluginFull.exe /silent SERVER_LOCATION=http://WIServer DONOTSTARTCC=1

Have a nice weekend!

2013-02-08 @ 11:12:00 Permalink Applications Kommentarer (0) Trackbacks ()