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…
Browsing: sccm report
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…
In My Previous post,I blogged about SCCM Report list packages that do not use UNC path (i.e package Uses local…
Are you Migrating your Existing SCCM /Configuration Manager Infrastructure to Configuration manager 2012 ,if so, You will have to look…
SQL Code used in SCCM Reporting to get list of Advertisements that are Mandatory! select adv.AdvertisementName as [Adv Name], adv.PresentTime…
If you are planning to migrate your SCCM 2007 environment to SCCM 2012,you may have to think about your packages,collections,OSD…
When you are doing Migration from SCCM 2007 to SCCM 2012,you may want to remove some of the drivers which…