ASK Garth!

Garth is your MEMCM Inventory and Reporting Expert!

Helping you get the most out of ConfigMgr.

 

Goal Setting

Vestibulum ac diam sit amet quam vehicula elementum sed sit

Goal Setting

Vestibulum ac diam sit amet quam vehicula elementum sed sit

Relationship Coaching

Vestibulum ac diam sit amet quam vehicula elementum sed sit

Stress Management

Vestibulum ac diam sit amet quam vehicula elementum sed sit

Career Advice

Vestibulum ac diam sit amet quam vehicula elementum sed sit

Free Report

Grab the Free monthly giveaway Dashboard or report from Enhansoft

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.

Looking for Forums to post questions?

Other Bloggers

Here is a list of other Bloggers that I love!

Learn MEMCM Reporting

 

  

Garth’s Latest Blogs

Adding the existence of a Service to a query.

My answer to the reddit post. https://www.reddit.com/r/SCCM/comments/lxslnw/sql_query_for_a_report/ First off you should always remember that you should never query the MECM tables directly. Next this will require a sub query to add the three extra rows. Lastly State...

Hostname History

This query will display computers who host names changes. SelectCS.Name0,HCS.Name0,HCS.TimeStampfromdbo.v_GS_COMPUTER_SYSTEM CSjoin dbo.v_HS_COMPUTER_SYSTEM HCS on Cs.ResourceID = HCS.ResourceIDWhereCS.Name0 <> HCS.Name0

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...