Computers that are running on virtual(Virtual PC or VMware etc) will have an entry in win32_computersystem with attribute model in WMI. You can create a collection to using table called SMS_G_System_COMPUTER_SYSTEM. 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 inner join SMS_G_System_COMPUTER_SYSTEM on…

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 = b.ResourceID and a.ResourceID=c.ResourceID and b.IPEnabled0='1' and b.ipaddress0 !='0.0.0.0' AND c.DisplayName0…

Yesterday I have started downloading the SCCM 2012 Beta 2 from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4da60258-5e61-4d16-8fae-d3c9fccf56dc and it took a while due to bandwidth issues In this Guide,I will guide you through the installation of SCCM 2012 Beta 2 and other interesting feature /options…

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 from given collection. Create a new report and paste the…

If you want to trace the users on what computers are they logged in(please be noted that  this is based on the hardware inventory information and if multiple users logged into same computer will not report to site server until…

Today is the official release of Microsoft Enterprise Desktop Virtualization v2. You can now download the RTM version of MED-V v2 from the MVLS site https://licensing.microsoft.com ,MSDN or TechNet. For more information about the release please see the MDOP blog…

Frequently we see some issues with sccm clients when PXE boot for OS deployment with some locations(WDS servers) because of IP helpers and to identify the issue is caused because of this,it took some days because we have to check…

Create a new report and paste the following query into it.This needs prompt as well to list the applications installed on computers . Select Distinct sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0 FROM v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID WHERE sys.ResourceID…

Today morning I step into office and just checked my mails .I saw mail from microsoftcommunitycontributor saying Dear Eswar Raju, Congratulations! We’re pleased to inform you that your contributions to Microsoft online technical communities have been recognized with the Microsoft…

This report gives you list of PCS where no user logged into the computer since 20 days.If the SCCM clients has any issues in sending inventory information to site server,you will see lot of computers though user logged into the…