This is updated post for long ago blogged post http://eskonr.com/2010/04/sccm-reportcollection-for-computers-with-internet-explorer-with-different-versions/. are you in search of getting summary of IE Versions…
Browsing: SQL Queries
Brief information about proxy MP before we jump into the subject. Proxy Management Point(On Secondary Site) used mainly to avoid…
Quick post on the Boundaries and its assigned Site Servers which are nothing but Distribution Points.Simply creating boundaries does not…
If you search on the web for Configmgr patch compliance report ,you get various links that talk about compliance reports…
Full details:http://social.technet.microsoft.com/Forums/systemcenter/en-US/82a7862a-fc1c-4c45-9635-ee44489c2673/file-inventory-report-query-by-name-count-and-machineid?forum=configmgrreporting select cs.Name0 [Computer name],COUNT(*) as [No of Times] from v_GS_SoftwareFile SF,v_GS_COMPUTER_SYSTEM cs where FileName like '%.mdf%' and…
Long ago,posted Configmgr SP1 SQL Views in spreadsheet which you can download it via post http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/. SQL Views are very…
There was a question in forum list about how to get count of clients by its status (active,obsolete etc). I…
With the default report,you can get Count or list of PC’s from domain Eg: Computers in a specific workgroup or…