Hi all ,Another report to find out the servers where IIS is installed with the version of it.this assumes that ,you have enabled the inventory agent and set the properties for .exe to not exclude windows folder.If you select exclude files from windows directory,you will not see any results in the report because inetmgr.exe will…
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…