SELECT COUNT(distinct ResourceID) as [Count], IP_Subnets0 as Subnet FROM dbo.v_RA_System_IPSubnets WHERE IP_Subnets0 NOT IN (SELECT IPSubnet…
Browsing: SQL Queries
had a requirement to see how many computer falls within the specific subnet. select a.name0,b.IP_Subnets0 from v_R_System a,dbo.v_RA_System_IPSubnets b where…
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…
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…
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…
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…