Monthly Patch statistics reports in SMS/SCCM to show up to the management in a simplified manner

Long back created a report for the monthly Patch statistics which can be found in http://www.windows-noob.com/forums/index.php?/topic/1764-patch-management-report-in-sms-2003/#entry6281 Below all the reports have been created using the last state messages.Even you can create different type of quiries based on this. I was referring to the Patch process and found an image which gives the statistics for the…

You might get a request to find out all the computers in organisation connected to which printers.There might be differetn printers in organisation and connection to the computers will vary.I just thought to post this qeury on the which will be useful for some one. SELECT A.Name0, A.UserName0, B.Name0, B.DriverName0, B.Location0, B.PortName0, B.ShareName0 FROM v_GS_COMPUTER_SYSTEM…

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,…

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…

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…

Report gives you all the installed applications excluding software updates .You can also customise to add other sec updates which you dont want them in report by adding  AND A.DisplayName0 NOT LIKE "name" at the end of report. SELECT A.DisplayName0,A.InstallDate0 A.Version0,A.Publisher0 FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B WHERE A.ResourceID = B.ResourceID AND A.DisplayName0 NOT LIKE ‘Hotfix…