Create a New report and paste the below query with prompt asking for computer name: select a.name0 ,b.SerialNumber0,c.model0 from v_R_System a,v_GS_PC_BIOS b,v_GS_COMPUTER_SYSTEM c where a.ResourceID=b.ResourceID and a.ResourceID=c.ResourceID AND a.name0=@hostname Prompt for computer name @hostname: select name0 from v_GS_computer_system Below is the collection which will prompt for computer name which should be created under component management--->queries section. select SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_R_System.LastLogonUserName from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.Name = ##PRM:SMS_R_System.Name##
Author: Eswar Koneti
There are lot of issues with Personnel laptop or desktop computer but you are not sure what that issue related.Here are am listing some of the problems which you might see in your day to day issues with PC’s also given their identification how to resolve it 🙂 1. MONITOR LED IS BLINKING Check all the connections like Monitor Cable, Data cables, RAM, Display Card, CPU connections. 2. CONTINUOS THREE BEEPS Problem in RAM Connection. 3. THREE BEEPS ( 1 Long 2 Short) Problem in Display Card Connection 4. THREE LONG BEEPS PERIOD WISE Problem in BIOS or RAM (Basic…
What is RBA? RBA a simplified administration of security permissions within the ConfigMgr environment. This allows organizations to use Security Roles to group sets of permissions together that collectively define an administrative span of control. There are 13 out of the box (in the current beta) and these are customizable, or can be added to for additional role definition. The end goal is to show what is relevant to the person doing the work, without distracting them , or creating a situation where something can happen. RBA is: A common look and feel across System Center products in console Designed…
The SuperFlow interactive content model provides a structured and interactive interface for viewing documentation. Each SuperFlow includes comprehensive information about a specific dataflow, workflow, or process. Depending on the focus of the SuperFlow. you will find overview information, steps that include detailed information, procedures, sample log entries, best practices, real-world scenarios, troubleshooting information, security information, animations, or other information. Each SuperFlow also includes links to relevant resources, such as Web sites or local files that are copied to your computer when you install the SuperFlow. The SuperFlow for Configuring Software Updates provides detailed steps that help you to plan for…
Have seen many forums about client push installation method in which SCCM fails to install Client on target computers because of security permissions to connect to admin$. Though there are many ways in doing this process, I prefer to use Group Policy over script based method since it gives me better central control overview of configuration. 1. Go to Active Directory users and Computers Add the user Account to member of above sec group which you want to make it as local admin on all the computers. Now create a Group Policy in which you will make the user account…
Below are some the links which are about System center configuration manager 2007 which you can have it reference. How to - Step by Step setup of a System Center Configuration Manager test lab: http://blogs.technet.com/kevinsul_blog/archive/2010/01/07/how-to-information-on-how-to-install-and-configure-configmgr-for-testing-reloaded.aspx you can download a SCCM R2 Test Drive VHD: http://www.microsoft.com/downloads/details.aspx?FamilyID=e0fadab7-0620-481d-a8b6-070001727c56&displaylang=en System Center TechNet Virtual Labs: http://technet.microsoft.com/en-us/virtuallabs/bb539977.aspx General SCCM Information: SCCM Home Page -http://www.microsoft.com/systemcenter/configurationmanager/en/us/default.aspx SCCM TechCenter - http://technet.microsoft.com/en-us/systemcenter/cm/default.aspx SCCM Documentation Library - http://technet.microsoft.com/en-us/library/bb680651.aspx SCCM 2007 Case Studies - http://www.microsoft.com/systemcenter/en/us/configuration-manager/cm-case-studies.aspx myITforum - http://www.myitforum.com/absolutenm/ Training link from Bryan Kinnan - http://technet.microsoft.com/en-us/systemcenter/cm/ff597934.aspx Video link from Greg Paff - http://blogs.technet.com/deploymentguys/archive/2008/03/20/sccm-2007-and-microsoft-deployment-toolkit-video-walkthrough.aspx SCCM Blogs: http://blogs.technet.com/configmgrteam/default.aspx http://blogs.technet.com/wemd_ua_-_sms_writing_team/default.aspx http://blogs.technet.com/kevinsul_blog/default.aspx http://blogs.technet.com/configurationmgr/default.aspx…
By default in SCCM,you do not have separate collections for Windows 7 or server 2008 OS as like you have in Windows XP and server 2003.You can create a query based collection using the following method/ query. collection for windows 7: Right click on collections and say new collection ,go to query based collection and paste the below syntax. 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 OperatingSystemNameandVersion like "%Workstation 6.1%" collection for Windows server 2008 or server 2008 R2: 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 OperatingSystemNameandVersion like "%Server 6.0%" If you looking for server 2008 R2 ,the version…
Though the original post is avilable in windows-noob , having utilised the original task seqeunce, there are slight modifications done to carryout this task which are simple to upgrade WinXP to win7. To use the existing Task sequence in 64 Bit OS , you will have to create additional packages like USMT and Micrisoft runscanstate pacakges which are used to in exisitng TS. 1. Create a New package"USMT x64 Only" which will point to source directory c:\program files\WAIK\tools\USMT\amd64. Do not create any program for this. MAke it avialble on to DP. 2.Open notepad ,paste the below code and name it as…