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 like '%Adobe acrobat%' GROUP BY a.Name0, c.DisplayName0, b.IPAddress0   ORDER BY a.name0 If there are…
How can I install SCCM 2012 Beta 2

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 that are changed from SCCM 2012 Beta 1 There are many features and their underlying…

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 below query into it. Select A.Name0, A.UserName0  from V_GS_COMPUTER_SYSTEM A join v_FullCollectionMembership B on A.ResourceID…

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 inventory information sent). Take a look at this post for more information about explaining last logged…

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 post http://blogs.technet.com/b/mdop/archive/2011/03/09/app-v-4-6-sp1-and-med-v-2-0-are-available-as-part-of-mdop-2011.aspx Frequently Asked Questions Q.       How do I upgrade from the release candidate to…

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 from server side if there are any issues running around. When attempting PXE boots via…

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 not in (select sys.ResourceID from v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID where…

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 Community Contributor Award. I should thank to all who has given me the support especially…