SCCM linked report Count of computers Assigned to Specific AD site

Today's post is going to listing down computers assigned to specific site with count and this will be linked to another report that gives you computer asset information. If you have referred my previous post on computer asset information http://eskonr.com/2011/12/sccmconfigmgr-report-for-computer-asset-information-serialnumber-manufacturermodelprocessorip-addresshardaware-scan/ OR http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ ,then it would be easy for you make it. You need to create…

We already know that Configuration Manager no longer uses the reporting point; the reporting services point is the only site system role that Configuration Manager now uses for reporting. The reporting services point is a site system role that is installed on a server that is running Microsoft SQL Server Reporting Services. The reporting services…

earlier I posted entry to list all virtual computers http://eskonr.com/2011/04/sccm-collection-for-virtual-or-physical-computers/ this collection gives you all computers that are Physical (running as Host) not Virtual… 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 Where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%Virtual%") and SMS_R_System.Client is…

long ago have posted report on computers with SCCM report for Last logged on computer name with application installed or not and SCCM report display computers with IPaddress based on Application/software this report gives you computers with ip address and last logged on username from a given collection : select A.Name0,c.IPAddress0 as 'IP ADDRESS',E.UserName0 as…

    SELECT b.Netbios_Name0, b.User_Name0, CASE WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003' WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007' WHEN a.FileVersion LIKE '14.%' THEN 'Office 2010' ELSE 'Udda Version' END AS 'Office Version', a.FileName, a.FileVersion, a.FilePath FROM v_GS_SoftwareFile a JOIN v_R_System b ON a.ResourceID = b.ResourceID JOIN v_RA_System_SystemOUName c ON a.ResourceID = c.ResourceID 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 etc. You can customise this by adding additional colums http://technet.microsoft.com/en-us/library/dd334593.aspx and Creating Custom Reports By Using Configuration Manager 2007 SQL Views http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22052 Select SYS.Netbios_Name0, OPSYS.Caption0 as C054, OPSYS.Version0, OPSYS.CSDVersion0, OPSYS.InstallDate0, OPSYS.LastBootUpTime0, OPSYS.WindowsDirectory0, OPSYS.Description0 from v_R_System…