SQL Queries – Page 18 – All about Microsoft Endpoint Manager

configMgr(SCCM) report for Computers OS Installed date,Operating system,last bootup time

Posted on January 18, 2012 by Eswar Koneti | 0 Comments

simple and straight forward report that gives you the computers with operating system,CSD version(service Pack),Version number,OS Installed date,LastBootup time.windows Directory etc. You can customise this by adding additional colums http://technet.microsoft.com/en-us/library/dd334593.aspx…

SCCM configMgr inventory report like Asset number Serial number Manufacturer Model Processor IP Address

Posted on December 22, 2011 by Eswar Koneti | 18 Comments

Long back i posted report http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ to get computer information like computer name,Serial number,Processor,Physical memory,service Pack,computer model etc In this post ,i have modified the report little bit from previous post…

sccm report computers with heartbeat time stamp

Posted on November 9, 2011 by Eswar Koneti | 7 Comments

In this post,we will see how to get heartbeat discovery (DDR) time for the clients from specific collection using Reports.For troubleshooting client health issues ,we need to know when was…

SCCM Monthly Patch statistics reports to the management in a simplified manner

Posted on October 25, 2011 by Eswar Koneti | 9 Comments

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 required information what it gives in SMS 2003 since some…

SLA report for SCCM Software Distribution

Posted on September 23, 2011 by Eswar Koneti | 12 Comments

Have you been asked by your boss saying can you send me the report for the applications that are deployed last month with Success rates /failures? You will be wonder…

Another Patch statistics report for SCCM 2007

Posted on May 16, 2011 by Eswar Koneti | 0 Comments

Here is another patch statistics report for SCCM 2007 environment with summary of patches that are deployed within month (30 days) with different column. select 'Total number of active patches within…

SCCM report display computers with IPaddress based on Application/software

Posted on April 1, 2011 by Eswar Koneti | 2 Comments

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 FROM v_GS_ADD_REMOVE_PROGRAMS c, v_R_System a, v_GS_NETWORK_ADAPTER_CONFIGUR b WHERE a.ResourceID =…

SCCM report for computers with last logged on user from collection

Posted on March 28, 2011 by Eswar Koneti | 15 Comments

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 get list of computers with last logged on user name…