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 be located in windows folder. select distinct a.Name0,c.FileVersion from v_R_System a inner join v_GS_SERVICE b on b.ResourceID = a. ResourceID inner join v_GS_SoftwareFile c on c.ResourceID=a.ResourceID where b.DisplayName0 like 'World Wide Web%' and a.Operating_System_Name_and0 like '%Server%' and c.FileName ='inetmgr.exe' Order by a.Name0,c.FileVersion
Author: Eswar Koneti
Are you looking to identify the machines which are having lessthan 512 MB running with Office 2007 or OFfice 2003 with the operating System Installed.If so you can use the below simple SQL query into your reports. Create a New Report and name it as ' Machines with Lessthan 512 MB RAM' as you like.In the SQL statement,click on Edit SQL statement and paste the below query.Click ok and run the report. SELECT dbo.v_GS_COMPUTER_SYSTEM.Name0 AS [Computer Name], dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System], dbo.v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service Pack], dbo.v_GS_COMPUTER_SYSTEM.Model0, dbo.v_GS_PC_BIOS.Manufacturer0, MAX(dbo.v_GS_X86_PC_MEMORY.TotalPhysicalMemory0) AS [Physical Memory (KBytes)], a.DisplayName0 ,a.version0 FROM dbo.v_GS_LOGICAL_DISK INNER…
There might be some scenarios where in you would like to fetch computers with IE Versions, how many of them have IE8, IE9 ,how many of them do not have IE8 etc. Through this post,i wanted to give some useful SQL quires and collections which would help you to create to meet your requirement . The below is query that can be used to get all IE 7 machines.This assumes that , you have enabled software inventory client agent and by default, *.exe is listed. Create a new report and paste the following the query.This can be customized as per…
This VB script might help you in initiating the communication between WindowsUpdateAgent(Client) and WindowsUpdateServer(Server) for windows updates. ' ---------------START CODE--------------- strComputer = inputbox("Enter a computer name to run WUA detectnow","Invoke detectnow") if strComputer = "" then wscript.quit on error goto 0 Set autoUpdateClient = CreateObject("Microsoft.Update.AutoUpdate",strComputer) AutoUpdateClient.detectnow() wscript.echo "Client Communication initiated with WSUS Server." ' ----------------END CODE-----------------
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 listed patches in a good viewable way.so thought of creating such a report and can be linked to other report to get preferable colums which are necessary.May be i can show it to the management team for the patch activity on monthly basis.This basically requries to create…
There might be the scenario where you will be looking for computers which doesnt have particular application installed on.Create a new collection and copy the below simple WQL query which list you all computers there by you can advertise the application package onto it. select SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name not in (select SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe acrobat reader") change the application(adobe actobat reader) the one you are looking at.
Though this process looks easy but havent had a chance to use this.Recently ,i have upgraded my SQL server 2005 to SQL server 2008.There are different ways that you can do this like taking backup of SQL server 2005 ,uninstall 2005 later install 2008 and restore backed up database.I just simply ran the upgrade advisor to see if it has any DTS jobs and other stuff.So started installing SQL 2008(passed pre requisists) and it prompt me to select the instance name.So tried using the default instance name but failed bcz it used by SQL 2005 .I selected named instance(computername\SQLserver2008).For installing the…
Issue: Client PC's would not communicate to WSUS 3.0 SP1 Solution: 1. Delete the PC from the WSUS console (Client PC's - The PC will likely have a red X) 2. At the client PC - Select Start - Run - type CMD 3. At the command prompt type net stop wuauserv 4. Navigate to the Windows Directory 5. Delete the 'Software Distribution' Folder 6. Run Microsoft Update from the Start menu (This will ensure the update software is up to date) 7. Restart the PC 8. Select Start - Run - type in the run box http://WSUSServerName/iuident.cab (wsus…