You might get a request to find out all the computers in organisation connected to which printers.There might be differetn printers in organisation and connection to the computers will vary.I just thought to post this qeury on the which will be useful for some one. SELECT A.Name0, A.UserName0, B.Name0, B.DriverName0, B.Location0, B.PortName0, B.ShareName0 FROM v_GS_COMPUTER_SYSTEM A, v_GS_PRINTER_DEVICE B WHERE A.ResourceID = B.ResourceID AND B.Name0 != 'Microsoft Office Document Image Writer' AND B.Name0 != 'Adobe PDF' AND B.Name0 != 'Microsoft XPS Document Writer' AND B.Name0 != 'PDF-XChange 3.0' AND B.DriverName0 != 'Microsoft Shared Fax Driver' AND B.DriverName0 != 'pdfFactory 2' AND…
Author: Eswar Koneti
There are many tools like SMS /SCCM or scripting to get list of applications installed on computers(you dont use SMS/SCCM only for this kind of information 🙂 ) but what if the clients are not reported back to site server for some other reason and there could lot of applications installed on computers then you will start troubleshooting the clients why it doesnt report. Use the below simple VB script to get list of applications installed on target computers with its installed date and product ID as well. Collect list of computers that you are looking for and pipe all the computer names into…
Is the client getting the advertisement policy? 1. Check the ccmexec.log for the advertisementID. 2. If the advertisementID is not in the ccmexec.log, check the ccmexec.log for errors communicating with the Management Point. 3. If the ccmexec.log shows errors communicating with the MP, follow basic connectivity tests such as pinging the MP by IP address, pinging the MP by hostname and telnetting to port 80 on the MP. 4. If the ccmexec.log indicates the client can communicate with the MP, check the Management Point to see if the policy exists using SMS Client Centre tool. 5. If the policy is…
Both MySQL and SQL Server do a good job of supporting all major protocols for accessing their respective databases. A standard protocol is the “programming language” used for a program to communicate to a SQL database. The most common protocol is called tSQL, or Transact SQL. Transact SQL is a series of statements that a program can use to access data and create new tables in a SQL database. The statements can INSERT new records, DELETE old records and UPDATE existing records, along with a myriad of other functions. The international standard for this programming language is referred to as…
It is difficult to troubleshoot the machines where the Task sequence(Os deployment) failed remotely.If there are one or two computers which are in front of you,you can check press F8 and see what happens by looking at smsts.log but take a case if you deploy to multiple systems and a person who is not know how to get smsts.log .Steve posted a Great blog on how to capture smsts.log on to share for further troubleshooting. Below is the Task sequence which displays for deploying Operating System with different tasks .Here i have two main groups i.e Error catching Top with…
You might have different operating Systems installed on the computers.One fine day your boss might request you to get list of computer with Operating system and language installed on the computers.Here is the Report to list all the computers with this information. select distinct a.name0,c.Caption0 as 'Operating System',c.CSDVersion0 as Version,b.SystemDefaultLCID as Language from v_R_System a, v_GS_WORKSTATION_STATUS b,v_GS_OPERATING_SYSTEM c where a.ResourceID=b.ResourceID and a.ResourceID=c.ResourceID group by a.name0,b.SystemDefaultLCID,c.Caption0,c.CSDVersion0 Here is the link to refer for Locale IDs, Input Locales, and Language Collections for Windows XP and Windows Server 2003 http://msdn.microsoft.com/en-us/goglobal/bb895996.aspx
2 weeks back,working on patching issues in SMS 2003 which are having some trouble.there are lot of systems which failed the patches due to windows update agent doesnt exisit on the machines(identified the cause because of this) more information look here .It is bit hard to find the systems by looking at resource explorer and finding if it has latest windows update agent or not ? so just create a collection and advertise the package( windows update agent) on to this collection to get the good success rate for patching. select ResourceId, ResourceType, Name, SMSUniqueIdentifier, ResourceDomainORWorkgroup, Client from SMS_R_System where ResourceId not in…
In my last post http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ showed how to create sccm report to list computers with different versions of application installed on computers. This is to list the computers in collection rather report. Create a collection and edit the query ,paste the following into it. select * from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office1%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Office2%" Please replace the bold letters with the correct application name displayed from add and remove programs.