SELECT COUNT(distinct ResourceID) as [Count], IP_Subnets0 as Subnet FROM dbo.v_RA_System_IPSubnets WHERE IP_Subnets0 NOT IN (SELECT IPSubnet…
Browsing: sccm report
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…
Have you been asked by your boss saying can you send me the report for the applications that are deployed…
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…
Create a new report and paste the following query into it.This needs prompt as well to list the applications installed…
The below scripts works for only Win 2000 and XP not for other operating systems .Here are the simple steps…