Tags: SQL

Posted on July 10, 2012 by | 2 Comments | 4,371 Views
Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/188bb324-9217-4fa6-b814-06a3d353bf52 Boundary information (AD Site) added . select distinct v_GS_SYSTEM.Name0 as 'Computer Name',A.AD_Site_Name0, substring(AccountName0,charindex('Domain=',Accountname0)+8,(charindex('Name=',Accountname0)-charindex('Domain=',Accountname0)-10)) as 'Domain Name', substring(AccountName0,len(AccountName0)-charindex('"',reverse(AccountName0),2)+2,charindex('"',reverse(AccountName0),2)-2) as 'User Name' from v_GS_SYSTEM INNER JOIN v_GS_LocalAdmins ON v_GS_SYSTEM.ResourceID = v_GS_LocalAdmins.ResourceID INNER JOIN v_R_System A ON v_GS_SYSTEM.ResourceID=A.ResourceID JOIN v_FullCollectionMembership FCM on v_gs_system.ResourceID = FCM.ResourceID where (AccountName0 not like '%Administrator%' AND AccountName0 not like…
Read more »

Posted on June 14, 2012 by | 0 Comments | 215 Views
Long Ago have posted sccm report about all advertisements that are currently assigned to specific computer http://eskonr.com/2010/12/sccm-report-to-list-all-the-advertisement-that-are-currently-assigned-to-computer/ this post gives you the advertisements targeted to specific Computer which are only MSI based. Create simple report with below SQL Query SELECT distinct adv.AdvertisementName,adv.AdvertisementID,pkg.PackageID,advinfo.PackageName,adv.ProgramName from v_Advertisement adv     inner join v_FullCollectionMembership FCM ON FCM.CollectionID=adv.CollectionID     Inner join…
Read more »
Managed SQL server FixSQLRegistryKey stopped working

Posted on April 3, 2012 by | 8 Comments | 6,457 Views
  Trying to install the required Prerequisites files for Configuration Manager 2012 all are done except SQL sever SP1 with CU4. SQL server 2008 R2 has got installed but later SP1(QLServer2008R2SP1-KB2528583-x64-ENU) failed with Error “Managed SQL server FixSQLRegistryKey stopped working” Trying to fix this by looking at registry/setup log file but I couldn’t. The Fix…
Read more »

Posted on January 19, 2012 by | 0 Comments | 1,732 Views
 Usually when applications are installed,they wont repot to site server with installed software and its details why because the value that should report to site server is not picked by sms agent by default and you should edit SMS_DEF.MOF file which you find it from your site server installed drive,inbox folder,clifiles,hinv . Below is the…
Read more »

Posted on December 22, 2011 by | 18 Comments | 7,816 Views
Long back i posted report  http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ to get computer information like computer name,Serial number,Processor,Physical memory,service Pack,computer model etc In this post ,i have modified the report little bit from previous post to add more fields that gives you lot more information about the computer . It is  very simple and straight forward report that just use…
Read more »

Posted on November 9, 2011 by | 7 Comments | 14,859 Views
In this post,we will see how to get heartbeat discovery (DDR) time for the clients from specific collection using Reports.For troubleshooting client health issues ,we need to know when was the client last reported its DDR . If you need to create collection to list the clients that are not sending heartbeat DDR for past…
Read more »

Posted on October 25, 2011 by | 9 Comments | 3,819 Views
This is continuation to the post avilable here on http://eskonr.com/2010/03/monthly-patch-statistics-reports-to-show-up-to-the-management-in-a-simplified-manner/ Report posted on the above link doesnt give you the required information what it gives in SMS 2003 since some of the columns in have been changed i.e product has blank value from v_GS_patchstausEX view etc in sccm 2007. Below is the modified report that…
Read more »
SLA report for SCCM Software Distribution

Posted on September 23, 2011 by | 12 Comments | 2,529 Views
Have you been asked by your boss saying can you send me the report for the applications that are deployed last month with Success rates /failures? You will be wonder after looking at the success rate 🙂 and start troubleshooting why is this . We will be deploying number of applications per day using SCCM…
Read more »