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…
Browsing: SQL
Have you been asked by your boss saying can you send me the report for the applications that are deployed…
Here is another patch statistics report for SCCM 2007 environment with summary of patches that are deployed within month (30…
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…
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…
If you want to trace the users on what computers are they logged in(please be noted that this is based…
Create a new report and paste the following query into it.This needs prompt as well to list the applications installed…
This report gives you list of PCS where no user logged into the computer since 20 days.If the SCCM clients…