Month: October 2018

CISCO IP Phone Reset Codes

In order to perform a factory reset of a phone if the password is set, complete these steps:

  1. Unplug the power cable from the phone, and then plug in the cable again.The phone begins its power up cycle.
  2. Immediately press and hold # and while the Headset, Mute, and Speaker buttons begin to flash in sequence, release #.The Headset, Mute, and Speaker buttons flash in sequence in order to indicate that the phone waits for you to enter the key sequence for the reset.
  3. Press 123456789*0# within 60 seconds after the Headset, Mute, and Speaker buttons begin to flash.

SQL Extract from WSUS Database

Today i had a customer come to me and ask if i could easily gather and provide any data on the versions of BIOS firmware running around their network. After looking in to the best way to achieve this i found that WSUS automatically gathers this information when any client machines check in, however there is no export function within the WSUS console to gather this data into a usable format.

As the data is there we can get to it directly using SQL Management Studio or SQLCMD  (https://www.microsoft.com/en-us/download/details.aspx?id=53591)

Simply install either of the above tools and connect to the SQL Database hosting WSUS this will either be on a SQL server or hosted locally on WID and run the following script

use SUSDB

select distinct ComputerModel,BiosVersion,FullDomainName

from tbComputerTargetDetail td, tbComputerTarget t

where t.target_id = td.target_id