Author: Eswar Koneti

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 = B.ResourceID Where B.CollectionID =@collID Create a prompt for collection ID collID : select  CollectionID,Name from v_Collection Please refer the post why should u use V_GS_COMPUTER_SYSTEM for user name rather V_R_SYSTEM http://smsug.ca/blogs/garth_jones/archive/2007/06/30/482.aspx

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 on user name http://smsug.ca/blogs/garth_jones/archive/2007/06/30/482.aspx select distinct a.Name0,a.UserName0 from v_GS_COMPUTER_SYSTEM a,v_FullCollectionMembership b where a.username0=@username and b.CollectionID=@COLLID Prompt for username: select distinct username0 from V_GS_Computer_system order by username0 prompt for COLLID : select  CollectionID,Name from v_Collection if you need the last logged on user information from…

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 the RTM? A.       We recommend that you re-run the packaging process of the MED-V image using the latest MED-V Workspace Packager. You can then deploy the updated Host Agent and MED-V workspace to computers in your production environment. If you have already deployed the MED-V…

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 a System Center Configuration Manager 2007 PXE Service Point, PXE boots will initially work and succeed but then all of a sudden stop working.  Examining the server where the PXE Service Point and Windows Deployment Services (WDS) are installed reveals that the Windows Deployment Services…

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 DisplayName0 = @displayname) Prompt for Displayname: select DisplayName0 from v_Add_Remove_Programs You can also filter this to collection ,see how this can be done from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/

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 to Ymsen Marcus and Niall Brady.

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 computer. select a.Name0,a.UserName0,TimeStamp from v_GS_COMPUTER_SYSTEM a ,v_FullCollectionMembership b where DATEDIFF(dd,a.TimeStamp,GetDate()) > 20 and  b.CollectionID = @ID and a.ResourceID=b.ResourceID order by a.Name0 Prompt for ID: SELECT DISTINCT CollectionID, Name FROM v_Collection

Do you want to find out the computers based on the user names where they have logged on lastly and to see if they have specific application is installed or not with date ? Here you go with the SCCM report with list of users . select a.Name0,a.UserName0 as 'Last logged in',c.DisplayName0,c.InstallDate0 from v_GS_COMPUTER_SYSTEM a , v_Add_Remove_Programs c where a.Username0 in ('domain\sccmadmin','domain\user1')  and a.ResourceID=c.ResourceID and c.DisplayName0  like '%Microsoft Office%' order by name0 SCCM report to Display computers that users in a specific security group last logged in on to with software exist or not? select a.Name0,a.UserName0 as 'Last logged in',b.Usergroup_Name0,c.DisplayName0,c.InstallDate0 from…