Author: Eswar Koneti

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.

All advertisements with specific status : This report gives you all percentage count with specific status for all advertisement in your environment. In order to get the list of machines where it is advertised with specific status,this report has to be linked to default report i.e 106.It works with SCCM , if you want to run the report in SMS 2003 ,see below after this code. SELECT AdvState.AdvertisementID, AdvName.AdvertisementName, AdvState.LastStateName, AdvState.number AS 'Number of clients with this Status', ROUND(100.0*AdvState.number/SUM(CASE AdvTotal.LastState WHEN 0 THEN 0 ELSE 1 END),1) AS 'Percent with this Status', SUM(CASE AdvTotal.LastState WHEN 0 THEN 0 ELSE 1…

Here are the list of windows update error codes http://inetexplorer.mvps.org/archive/windows_update_codes.htm

if you want find out the computers that doesnt have particualr software installed in,you may write query where applications!=adobe which will not return the correct result as you would expect. you will have to use not in condition to get the correct result. here is you go: 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