Saturday, July 27

Browsing: WQL Quiries

SCCM collection Query do not have particular exe installed

By Eswar KonetiDecember 02, 10:58 am Collections 1 Min Read3,124 Views

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…

SCCM collection based on Heartbeat Agent older than X days

By Eswar KonetiNovember 29, 6:40 pm Collections 1 Min Read14,001 Views

In my previous post,we saw how to create SCCM report to list clients with its heartbeat time stamp . In this post…

SCCM collection for Windows 7 Computers with 64 Bit OS

By Eswar KonetiMay 17, 11:58 am Collections 1 Min Read5,521 Views

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…

SCCM collection for Virtual or Physical computers

By Eswar KonetiApril 04, 7:57 pm Collections 1 Min Read14,476 Views

Computers that are running on virtual(Virtual PC or VMware etc) will have an entry in win32_computersystem with attribute model in…

sccm collection for add and remove programs with ms office

By Eswar KonetiFebruary 11, 1:40 pm Collections 1 Min Read5,391 Views

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…