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…
Year: May 17, 11:58 am
Here is another patch statistics report for SCCM 2007 environment with summary of patches that are deployed within month (30…
I started listing down comparative differences between SMS 2003, SCCM 2007 and SCCM 2012 and with the help of Wei…
Are you looking for report to have details about pst,pdf or any other files to see where they are and…
Computers that are running on virtual(Virtual PC or VMware etc) will have an entry in win32_computersystem with attribute model in…
Computers with specific application installed with IPaddress. Additional reports for Add and remove programs are available from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ SELECT a.Name0,b.IPAddress0,c.DisplayName0…
Yesterday I have started downloading the SCCM 2012 Beta 2 from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4da60258-5e61-4d16-8fae-d3c9fccf56dc and it took a while due to bandwidth…
You have report to list all computers based on last logged on username from http://eskonr.com/2011/03/sccm-report-to-list-all-computers-based-on-last-logged-on-user-name-from-collection/ . In this post,you will…