The following SQL query can be used to query the list of collections that doesn't have any deployments. you can…
Browsing: SCCM Reports
create reports for the requirement and i first start analyzing the necessity and find the information about the required…
We already know that Configuration Manager no longer uses the reporting point; the reporting services point is the only site…
Usually when applications are installed,they wont repot to site server with installed software and its details why because the value…
In this post,we will see how to get heartbeat discovery (DDR) time for the clients from specific collection using Reports.For…
This is continuation to the post avilable here on http://eskonr.com/2010/03/monthly-patch-statistics-reports-to-show-up-to-the-management-in-a-simplified-manner/ Report posted on the above link doesnt give you the…
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…
Here is another patch statistics report for SCCM 2007 environment with summary of patches that are deployed within month (30…