Cisco Unity Communication Database Queries

I was assigned a task to find out the mailbox size of an individual user.  Below are the queries that I successfully ran. Query the mailbox size of a specific user. GSumner is the mailbox username run cuc dbquery unitydirdb select alias as UserID,bytesize,send,receive, warning from vw_user,unitymbxdb1:vw_mailbox where vw_user.objectid in (select userobjectid…

Continue reading

Internet Explorer cannot display Cisco Unified Call Manager Administration

  You may get the above message when you try to access Cisco Unified Call Manager Administration in Internet Explorer.  This happens to people using CUCM version 8.3 or 9.2.  The problem is caused by Microsoft security patch KB3061518.  They removed Diffie-Hellman 512-bit encryption from the supporting Windows OS. In order to…

Continue reading

Exchange: Hide/UnHide Distribution Group Members

By default, this option is not set and it will be treated as false or hiding distribution group members.  You can unhide distribution group members following the below steps. Open Active Directory Users and Computers console Click View Menu and select Advanced Features (to show the Attribute Editor tab) Find your Distribution…

Continue reading

Disable Firefox Auto Update

Method 1 In Firefox address bar, type about:config then click I accept the risk.   You can now search for app.update.auto and double-click on it to set to false. Method 2 Edit prefs.js file that can be found in %APPDATA%\Mozilla\Firefox\Profiles\randomstring.  If the line containing app.update.enabled is not found, then add user_pref(“app.update.enabled”, false); to disable the Firefox…

Continue reading

Powershell: Sample for Download Files from an HTTP page

Import-Module BitsTransfer $emailFileList = “” $destinationFolder = “E:\DestTest\” $uri = “https://test.com/test/test/” $hrefs = (invoke-webrequest -Uri $uri).links.innerText $existingFolder = “E:\ExistingFolder” $existingFiles = Get-ChildItem -Path $existingFolder $download = $true foreach ($href in $hrefs) { $download = $true foreach ($existingFile in $existingFiles) { if ($href -eq $existingFile.Name) { $download = $false } }…

Continue reading

Powershell: Read links in an HTTP page and download all the links

Read the links in an HTTP page $url = “http://mirror.internode.on.net/pub/test/10meg.test” $output = “$PSScriptRoot\10meg.test” $start_time = Get-Date Invoke-WebRequest -Uri $url -OutFile $output Download Files with System.Net.WebClient $url = “http://mirror.internode.on.net/pub/test/10meg.test” $output = “$PSScriptRoot\10meg.test” $start_time = Get-Date $wc = New-Object System.Net.WebClient $wc.DownloadFile($url, $output) #OR (New-Object System.Net.WebClient).DownloadFile($url, $output) Write-Output “Time taken: $((Get-Date).Subtract($start_time).Seconds) second(s)” Download…

Continue reading