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 SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%Virtual%" To list all physical computers ,create another collection using operator not in from above collection like below: 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%") Hope it helps.
Author: Eswar Koneti
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 multiple computer entries,no worries bcz computer might have additional network connections which will have more than One IP which can be identified Via Resource Explorer—Hardware—>network adapter configuration
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 infrastructure have changed significantly between Configuration Manager 2012 Beta 1 and Configuration Manager 2012 Beta 2, you cannot upgrade to Configuration Manager 2012 Beta 2. For more info please read http://technet.microsoft.com/en-us/library/gg703318.aspx and SCCM 2012 Prerelease documentation on http://technet.microsoft.com/en-us/library/gg682129.aspx Before you start this guide ,Please reference…
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/