Count Duplicate Names

The following SQL query counts duplicate computer names. The first query looks for duplicate names only. If you have an issue where client records are not populating canonical names (OU path in AD), the second query look for duplicate names that have at least one client record with NULL for the canonical name. /* Count Duplicate Names */…

Count SCCM Client Versions

The following SQL query counts the SCCM client versions by workstations and servers. Note: this will only return count of Windows based clients. If you have Linux/Unix based or Mac, the where clause should be modified to remove Operating_System_Name_and0 criteria. /* Count CM Client Versions by Workstations and Servers */ select ‘Workstations’ as ‘Platform’, Client_Version0,…

Show Maintenance Windows for a Computer

The following SQL query displays a list of maintenance windows for a given computer (SCCM client). Computer name in this example is ‘Computer1’. SELECT FCM.Name AS ‘Client Name’, C.Name AS ‘Collection Name’, SW.CollectionID, SW.Name, SW.Description, SW.StartTime, SW.Duration, SW.IsEnabled FROM v_ServiceWindow SW JOIN v_Collection C ON C.CollectionID = SW.CollectionID JOIN v_FullCollectionMembership FCM ON FCM.CollectionID = C.CollectionID WHERE…

Monitor Maintenance Tasks

To monitor last start and last completed times for maintenance tasks in SCCM, run the below SQL queries. At the bottom of this page is an example of running a maintenance task on demand. select * from SQLTaskStatus Order by LastStartTime desc To calculate the duration of each task, the above query can me modified…

Upgrading to R2 and MDT 2013 Part 7

Version: SCCM 2012 SP1 CU2 and MDT 2012 Update 1 (Upgrading to R2 and MDT 2013) Part 7 – Upgrading Clients Once all the backend changes are completed with the R2 and MDT 2013 upgrade, the final step is upgrading clients. The R2 client version is 5.00.7958.1000. Also, when applying the hotfix KB2910552, there are associating…

Upgrading to R2 and MDT 2013 Part 6

Version: SCCM 2012 SP1 CU2 and MDT 2012 Update 1 (Upgrading to R2 and MDT 2013) Part 6 – Create the MDT 2013 Toolkit Package In order to create an updated MDT package, create an MDT task sequence. In this example, I’ll simply choose the “Client Task Sequence” template.  Mid-way through the task sequence wizard, you will be prompted…

Upgrading to R2 and MDT 2013 Part 5

Version: SCCM 2012 SP1 CU2 and MDT 2012 Update 1 (Upgrading to R2 and MDT 2013) Part 5 – Create MDT 2013 Boot Images Both 32-bit and 64-bit MDT 2013 boot images can be  created from the CM console.  Under Software Library -> Operating Systems, right-click on Boot Images to select “Create Boot Image using MDT”. This screenshots show…