Author: Eswar Koneti

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 works in SCCM environment. 1) Patch Management summary: select summ.ID,summ.QNumbers as 'Q Number', COUNT(distinct ps.ResourceID) as 'Requested', COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End)  as 'Installed', ROUND(100.0*COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End)…

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 and difficult to track the status of each application and export to document . This report will give you all the advertisements that are deployed with in specific date/time. Create a new report with the below SQL query with 2 prompts (start time and end time) select adv.AdvertisementName as…

Recently have a requirement to uninstall all old adobe versions and install the new on.Looking for something which can be done Via but i found the below method is simple that can remove all the older applications and instal the new one(which can be done Via TS by adding two TS actions one with removal of old adobe versions and other for installation of New adobe). Thought of sharing with you here how to remove different versions of applications at one go. Thanks to john Marcum for providing me the command line. Here is the simple script that checks if the application is…

I was thinking to share something interesting with you all and it is very useful at times when you are dealing with installation or Uninstallation of applications ,but due to other priority works,i could not post it early. We recently started application deployment (running on SCCM 2007) for new client and lot of applications are msi without sms /PDF (automation file) file and we follow the process of collection creation based on product ID. we have package available with us without product ID but to know the product ID of the application either we have to edit the package using…

Create New SCCM collection and paste the below query into it. 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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.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_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 7%" and SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC" Also need report :look at here http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx

Here is another patch statistics report for SCCM 2007 environment with summary of patches that are deployed within month (30 days) with different column. select 'Total number of active patches within 30days:', COUNT(distinct Title) AS 'Count' FROM v_GS_PatchStatusEx WHERE (DATEDIFF(Day, LastStatusTime, GETDATE())) <=30 UNION select 'Percent sucessfully installed', round(100.0*COUNT( case when LastState=107 or LastState=105 then ResourceID else NULL end)/COUNT(ResourceID),1) as 'Procent succesful'  FROM v_GS_PatchStatusEx WHERE (DATEDIFF(Day, LastStatusTime, GETDATE())) <=30 select ps.ID, ps.QNumbers, ps.Title,     round(100.0*COUNT(distinct case when ps.LastState=107 or ps.LastState=105 then ps.ResourceID else NULL end)/COUNT(distinct ps.ResourceID),1) as 'Procent succesful' ,        COUNT(distinct case when ps.LastState=107 or ps.LastState=105 then ps.ResourceID else NULL…

I started listing down comparative differences between SMS 2003, SCCM 2007 and SCCM 2012 and with the help of Wei King to finish off the list, here is what we came up with Via http://www.myitforum.com/myITToolbar/frame-click.asp?url=http://mymomexperience.blogspot.com/2011/04/comparing-sms2003-sccm-2007-and-sccm.html

Are you looking for report to have details about pst,pdf or any other files to see where they are and when are they last modified ? first Identify what inventory files do you need want report on and then enable file inventory in software inventory agent with folder location to search for. go to site hierarchy--->site settings—>client agents—software inventory client agent and add the file name into inventory collection tab. provide the sufficient information file name,location and if you search subdirectories as well. Once this is done,make sure all the healthy SMS/SCCM clients passed software inventory client agent and sent…