Use Subselected query to get the results: select * from SMS_R_System where SMS_R_System.NetbiosName like "%rts%" and SMS_R_System.ResourceId not in (select…
Browsing: WQL Quiries
In my previous post,we saw how to create SCCM report to list clients with its heartbeat time stamp . In this post…
Create New SCCM collection and paste the below query into it. select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System…
Computers that are running on virtual(Virtual PC or VMware etc) will have an entry in win32_computersystem with attribute model in…
In my last post http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ showed how to create sccm report to list computers with different versions of application installed on…