Quick post on the Boundaries and its assigned Site Servers which are nothing but Distribution Points.Simply creating boundaries does not…
Browsing: SQL Queries
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…
Inventory report for laptops who have webcam feature ? You can use this report both on SCCM 2007 and Configmgr…
Running SQL queries directly from SQL server management studio is not safe method until you know what you are doing…