Are you looking to identify the machines which are having lessthan 512 MB running with Office 2007 or OFfice 2003 with…
Browsing: Configmgr 2007
There might be some scenarios where in you would like to fetch computers with IE Versions, how many of them…
Long back created a report for the monthly Patch statistics which can be found in http://www.windows-noob.com/forums/index.php?/topic/1764-patch-management-report-in-sms-2003/#entry6281 Below all the reports…
You might get a request to find out all the computers in organisation connected to which printers.There might be differetn…
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…
All advertisements with specific status : This report gives you all percentage count with specific status for all advertisement in…
if you want find out the computers that doesnt have particualr software installed in,you may write query where applications!=adobe which…
SELECT c.Name0, a.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS a, v_R_System c WHERE a.ResourceID = c.ResourceID AND a.DisplayName0 like ‘%Adobe acrobat%‘ GROUP BY c.Name0,…