Wake-on-LAN is an Ethernet computer networking standard that allows a computer to be turned on or woken up by a network message. The message is usually sent by a simple program executed on another computer on the local area network. Equivalent terms include Wake-on-LAN or Wake on LAN (WOL or WoL), and Remote Wake-Up (RWU). In case the computer being woken is communicating via Wi-Fi, the wake-up-packet can be sent via Wireless Multimedia Extensions (WMM). [1] This may also be called Wake on Wireless LAN (WoWLAN). [2] Wakeup over Wi-Fi networks was not possible in previous implementations of Wake-on-LAN. Wake-on-LAN is…
Author: Eswar Koneti
This is quite simple to create a bootable ISO image to capture winXP or Win7.On the technician computer ,install WAIK tool Downlaod it from here . 1.On technician system launch ‘Windows PE Tools Command Prompt’ from ‘Microsoft Windows AIK’ on the Programs Menu. The entire CD build process is performed in this CMD window. 2.To begin building a Windows PE CD type: copype.cmd amd64 c:\winpe_x64 3.Now mount the Windows PE boot image as a folder on your machine so that it may be edited by typing the following: imagex /mountrw c:\Winpe_x64\winpe.wim 1 c:\Winpe_x64\mount 4.To copy servicing tools into the mounted PE image, type: xcopy "C:\Program…
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
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.