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…
Author: Eswar Koneti
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…
Computers that are running on virtual(Virtual PC or VMware etc) will have an entry in win32_computersystem with attribute model in WMI. You can create a collection to using table called SMS_G_System_COMPUTER_SYSTEM. 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%Virtual%" To list all physical computers ,create another collection using operator not in from above collection like below: 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 where SMS_R_System.ResourceId not in (select SMS_R_SYSTEM.ResourceID from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%Virtual%") Hope it helps.
Computers with specific application installed with IPaddress. Additional reports for Add and remove programs are available from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ SELECT a.Name0,b.IPAddress0,c.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS c, v_R_System a, v_GS_NETWORK_ADAPTER_CONFIGUR b WHERE a.ResourceID = b.ResourceID and a.ResourceID=c.ResourceID and b.IPEnabled0='1' and b.ipaddress0 !='0.0.0.0' AND c.DisplayName0 like '%Adobe acrobat%' GROUP BY a.Name0, c.DisplayName0, b.IPAddress0 ORDER BY a.name0 If there are multiple computer entries,no worries bcz computer might have additional network connections which will have more than One IP which can be identified Via Resource Explorer—Hardware—>network adapter configuration
Yesterday I have started downloading the SCCM 2012 Beta 2 from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4da60258-5e61-4d16-8fae-d3c9fccf56dc and it took a while due to bandwidth issues In this Guide,I will guide you through the installation of SCCM 2012 Beta 2 and other interesting feature /options that are changed from SCCM 2012 Beta 1 There are many features and their underlying infrastructure have changed significantly between Configuration Manager 2012 Beta 1 and Configuration Manager 2012 Beta 2, you cannot upgrade to Configuration Manager 2012 Beta 2. For more info please read http://technet.microsoft.com/en-us/library/gg703318.aspx and SCCM 2012 Prerelease documentation on http://technet.microsoft.com/en-us/library/gg682129.aspx Before you start this guide ,Please reference…
You have report to list all computers based on last logged on username from http://eskonr.com/2011/03/sccm-report-to-list-all-computers-based-on-last-logged-on-user-name-from-collection/ . In this post,you will get list of computers with last logged on user name from given collection. Create a new report and paste the below query into it. Select A.Name0, A.UserName0 from V_GS_COMPUTER_SYSTEM A join v_FullCollectionMembership B on A.ResourceID = B.ResourceID Where B.CollectionID =@collID Create a prompt for collection ID collID : select CollectionID,Name from v_Collection Please refer the post why should u use V_GS_COMPUTER_SYSTEM for user name rather V_R_SYSTEM http://smsug.ca/blogs/garth_jones/archive/2007/06/30/482.aspx
If you want to trace the users on what computers are they logged in(please be noted that this is based on the hardware inventory information and if multiple users logged into same computer will not report to site server until inventory information sent). Take a look at this post for more information about explaining last logged on user name http://smsug.ca/blogs/garth_jones/archive/2007/06/30/482.aspx select distinct a.Name0,a.UserName0 from v_GS_COMPUTER_SYSTEM a,v_FullCollectionMembership b where a.username0=@username and b.CollectionID=@COLLID Prompt for username: select distinct username0 from V_GS_Computer_system order by username0 prompt for COLLID : select CollectionID,Name from v_Collection if you need the last logged on user information from…