Eswar Koneti's Blog

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...

There are lot of tools available like SCCM client center or Collection commander or Right Click Tools etc. to trigger SCCM client agent Actions using these tools but the customer environment doesn’t have any of these tools to use and we had a requirement...

  Below is the report to list computers with IP address and Subnet information from Given collection. select distinct A.Name0,c.IPAddress0 ,D.IP_Subnets0 from v_R_System A inner join v_FullCollectionMembership B on A.ResourceID=B.ResourceID Inner...

The Microsoft Enterprise Desktop Virtualization v2 Beta Refresh is now available for download on the Microsoft Connect site. The updated software provides fixes to customer reported issues and new features including Workspace packager updates which add...

When you assign any advertisement (either application or Task sequence) to collection(Group of computers) ,all the advertisement will be tracked(logged) in SCCM Database with its status and other details.The advertisement will run on the computer and...

Here is another report today ,to list all the computers with their maintenance window setting and are part of which collection. The maintenance window information( collection ID,Description,time etc.) is available from SQL view called v_ServiceWindow...

Report to list all the computer where the discovery agent time shows older than 30 days. This you can find out if you right click on the computer ,go to properties and see Agent name[0] (ex:SMS_AD_SYSTEM_DISCOVERY) respect to Agent time[0] for the above...

Today,I come across several advertisement status message IDs for a particular advertisement which can be viewed under system status--->advertisement status. I,Thought of sharing the excel sheet with you about all the advertisement status message...

If your boss ask to get list of laptops which are managed by SMS or SCCM.what do you do and how do you get that. Right click on computer and go to resource explorer to identify the computer is Laptop or Desktop ? You can identify if the computer is Laptop...

Seen Lot of questions/helps in many forums on the SCCM client issues like client is not reported to SCCM console ,site code unsuccessful, Client is installed but Console shows NO and many more. Here is the check list which i have prepared to follow...

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...

System Center Updates Publisher (SCUP) helps users to publish their private updates to Windows Server Update Services (WSUS) and synchronize the updates in Configuration Manager 2007. Typically users synchronize these updates with WSUS by clicking "...