Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Find domain computers without ConfigMgr client installed

Use this report to filter away AD computers that haven’t had it’s object ‘modified’ in months.

select v_R_System.ResourceID,v_R_System.Name0 as [Computer Name],convert(char(26),v_R_System.whenchanged0,103) as [Object Modified], v_R_System.Client_Version0 as [Client Version],v_R_System.Resource_Domain_OR_Workgr0 as [Domain],v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 as [Site]from v_R_System join v_RA_System_SMSAssignedSites on v_R_System.ResourceID = v_RA_System_SMSAssignedSites.ResourceIDinner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System.ResourceID) 
where v_FullCollectionMembership.CollectionID = @CollectionID and v_R_System.Client_Version0 not like @ClientVersion and (DateDiff(day, v_R_System.whenChanged0, GetDate()) < cast(@SystemAge AS int))

order
by v_R_System.
Name0

Share This Post

A community professional, keynoter, and evangelist who has driven social media and marketing strategies, editorial successes, delivered customer successes and built some of the largest and longest-running online communities. Rod has created, managed and grown small, medium, and mega-sized conferences; run entire editorial teams to deliver record traffic and market leadership; as product manager, directed the success of hundreds of product releases; supported sales and marketing to ensure customer success; developed, run and sold businesses; written thousands of technical articles, white papers, case studies, and technical documentation; hosted and delivered hundreds of attendance shattering webinars and virtual tradeshows; and delivered keynote speeches and sessions at a wide variety of events including conferences, webinars, events, and user groups.

Leave a Reply