Hostname History

The problem comes up where you have duplicate GUIDs within MECM, How do you find them? You can do this within the console or within SQL. For this example, I will provide you with the SQL query to help locate computer who name has changed. This query will also help...

Find computers with no active users.

This query will find all computers in SCCM that have had not user logon within the last 30 days. declare @Now as datetimeset @Now = getdate() ;with MINLCU as(SelectSCU.ResourceID as ‘ResourceID’,min(SCU.LastConsoleUse0) as...

Count of Models

Here is a query query for count of computer Models. ;with m as (SELECTCS.Manufacturer0 as ‘Manufacturer’,case CS.Manufacturer0When ‘LENOVO’ then CSP.Version0else CS.Model0end as ‘Model’FROMdbo.v_R_System_Valid RVjoin...

Midwest Management Summit at Mall of America (MMSMOA) 2019

Once again, our very own Chief Architect, Garth Jones, will be presenting at the Midwest Management Summit at Mall of America (MMSMOA) 2019. This year’s edition of the conference runs from May 6-9, 2019. May 6 – 9, 2019 Radisson Blu Mall of America Minnesota, USA...

SQL Query for Getting Started with Power BI Desktop and SCCM

I was asked in a tweet to post my SQL query that I used within Getting Started with Power BI Desktop and SCCM. Since it didn’t make sense to post it to the Enhansoft Blog. I thought that I would post it on SCCMUG.ca site. It took a bit longer to get this out as I need...

Limiting a report to a Collection

For more details please see https://www.windows-noob.com/forums/index.php?/topic/9766-sccm-report-on-collection/     SELECT DISTINCT CS.Name0, R.User_Name0, MAX(SOU.System_OU_Name0) AS Expr1, CS.Description0, CS.Manufacturer0, CS.Model0, BIOS.SerialNumber0...