How to download a copy of everything on Facebook

With this method you can make a copy of everything which have happened on your facebook account, and also recover “deleted” messages and etc.

1. Login into your Facebook account and go to setting after it navigate to General account Settings.
2. Now you can see the Download a copy of your Facebook data, now click on download a copy link.
3. After clicking on link this will open a new page and on this page you can see download archive button. Click on it, after clicking it want you password and asking security question by Facebook.
4. Now you get message by Facebook – “the download link will be sent to your email id which you used to create your Facebook account.
5. Wait for a minute, check your e-mail, now you can see that you received Message from Facebook with download link. Click on download link can download zip file.
6. After downloading zip file extract it and find you lost messages, pictures and videos

Read more:

http://www.computertrickstips.com/recover-deleted-facebook-messages/

How to check version of odbc

To check for correct version of odbc, below is how to access odbc on Windows 64 bits:

• odbc 32 bit
  • c:\windows\SysWOW64\odbcad32.exe
• odbc 64 bit
  • c:\windows\System32\odbcad32.exe

 

 

You can also check what verson of odbc are installed by going to:

• odbc administrator – drivers tab – check if 32/62 dll are installed for the different sw (e.g Oracle, sql server)

 

Read more:

https://community.oracle.com/message/10839853

http://www.connectionstrings.com/download-oracle-11g-release-2-client-odbc-drivers/

http://www.simba.com/wp-content/uploads/2010/10/HOW-TO-32-bit-vs-64-bit-ODBC-Data-Source-Administrator.pdf

 

 

 

Error while opening Excel in Sharepoint2010

If you get error

‘Unable to process the request. Wait a few miniutes and try performing this operation again”

you need to edit the file

‘C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML’

Remove/comment out lines containing xls/xlsx

<Mapping FileExtension=”xlsx” RedirectUrlTemplate=”/_layouts/xlviewer.aspx?id=|0″ NoGetRedirect=”TRUE” CreateRedirectUrlTemplate=”/_layouts/xlviewer.aspx?new=1″/>

 

Reset IIS with through e.g command prompt:

iisreset /restart

Read more

http://sharepoint2010tutor.blogspot.no/2011/11/unable-to-process-request-while-opening.html

http://sharepoint.stackexchange.com/questions/64795/excel-document-opening-in-browser-unsupported-features

https://msdn.microsoft.com/en-us/library/ff595319(v=office.14).aspx

https://technet.microsoft.com/en-us/library/ee837425(v=office.14).aspx

http://stackoverflow.com/questions/22084561/difference-between-iisreset-and-iis-stop-start-command

 

 

 

Exchange log full – mailbox in quarantine

Sometimes when you experience Exchange log (disk) is full, and some mailboxes will have the status in quarantine. You can do the following:

1. Check if any users are in quarantine (powershell)
   • Get-MailboxDatabase|Get-Mailbox |Get-Mailboxstatistics |Select Displayname,IsQuarantined |FT -Autosize | Export-Csv c:\temp\mailboxusers.csv
   • Get-MailboxStatistics -identity USERNAME| FL Isquarantined
2. Solution
   1. Can wait on for the default 6 hours to let exchange release the quarantine
   2. Delete registry (doesn’t work all the time) – use following powershell to check registry for quarantine mailbox
      • Get-ChildItem -Path HKLM:\SYSTEM\CurrentControlSet\services\MSExchangeIS\$env:COMPUTERNAME\ |
        Where-Object {$_.pschildname -ne ‘logstate’ -and $_.pschildname -notlike ‘public*’} |
        Select-Object -ExpandProperty pschildname |
        ForEach-Object {
        Get-ChildItem -Path HKLM:\SYSTEM\CurrentControlSet\services\MSExchangeIS\$Env:COMPUTERNAME\$_\QuarantinedMailboxes |
        Select-Object -ExpandProperty pschildname |
        Get-Mailbox |
        Select-Object -Property name
        }
   3. dismount and mount the maildatabase (powershell)
      • Dismount-Database -Identity MAILBOXDB-Confirm:$False
      • Mount-Database -Identity MAILBOXDB -Confirm:$False
3. Check status of the mailboxdatabase:
   • Get-MailboxDatabase -Identity MAILBOXDB -Status | Format-Table Name, Mounted, BackupInProgress, OnlineMaintenanceInProgress

 

Read more

http://blogs.technet.com/b/sjimmie/archive/2010/07/09/mailbox-quarantine.aspx

http://felipecgoncalves.blogspot.no/2011/08/how-to-check-exchange-databases-status.html

http://felipecgoncalves.blogspot.no/2011/08/how-to-dismountmount-mailbox-databases.html

http://mikefrobbins.com/2013/11/21/insane-powershell-one-liner-to-return-the-name-of-users-with-quarantined-mailboxes-in-exchange-2010/

http://blogs.technet.com/b/rmilne/archive/2014/01/13/how-to-set-mailbox-quarantine-in-exchange.aspx

http://technet.microsoft.com/nb-no/library/10a2b32c-b844-44f1-b750-d5150e0b249c.aspx

http://support2.microsoft.com/kb/2603736/en-us

http://technet.microsoft.com/library/bb331958.aspx#SH

http://whitecraneltd.blogspot.no/2013/02/exchange-2010-and-powershell.html

 http://www.falconitservices.com/support/KB/Lists/Posts/Post.aspx?ID=72

 

 

Reset IIS – clear cache

In order to reset IIS or clear cache, you need to do the following:

1. iisreset or
2. remove cache
   • Click “Start” on your server, open “Administrative Tools” and then open the “IIS” program
   • Navigate to the website in IIS from which you want to remove the caching feature
   • Right-click on your website, then click “Properties.”
   • Click “Home Directory,” click “Configuration,” then click “App Mappings.”
   • De-select the “Cache ISAPI Applications” box, then click “OK.”

 

Read more:

http://stackoverflow.com/questions/3036397/how-to-reset-iis-or-otherwise-clear-cache-when-restarting-a-web-application

http://www.ehow.com/how_7393530_remove-iis-cache.html

 

 

 

Clear .Net cache

If something strange happens on your application/system, you need to clear .NET cache once in a while. You need to do the following from the command line – you might need to start as administrator:

IISRESET
Del /F /Q /S %LOCALAPPDATA%\Microsoft\WebsiteCache\*.*
Del /F /Q /S %LOCALAPPDATA%\Temp\VWDWebCache\*.*
Del /F /Q /S “%LOCALAPPDATA%\Microsoft\Team Foundation\3.0\Cache\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files\*.*“
Del /F /Q /S “C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\*.*“

This is only an example of .NET version that we have on our system, you need to modify the .NET version to suit yours. If you want to schedule clearing the .net you can put everything above in a .bat file and schedule in it windows scheduler.

 

Read more:

http://blogs.k10world.com/technology/delete-net-cache-versions-server/

 

Find SQL Server running port

In order to find which port the sql server instance is running on – run this query towards the database:

USE master GO xp_readerrorlog 0, 1, N'Server is listening on' GO


or


SELECT DISTINCT
local_tcp_port
FROM sys.dm_exec_connections
WHERE local_tcp_port IS NOT NULL

From the command line when you have PID (task manager for sqlsrv.exe)

netstat -ano | findstr *PID*

 

Read more

http://stackoverflow.com/questions/12297475/how-to-find-sql-server-running-port

http://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/

 

Add Active Directory tools under Windows7

You need to do the following steps:

• Download and install “Remote Server Administration Tools for Windows 7” from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7d2f6ad7-656b-4313-a005-4e344e43997d
• Enable Windows feature on: Remote server administration – Role administration tools (you need to be local administrator to do this if the your policy requires it):
  • Enable all AD features below (remember also under AD DS tools)
• The new features for AD are available under “Administrative Tools”

Read more

http://www.sevenforums.com/tutorials/5462-windows-features-enable-disable.html

http://snippetsandhelp.blogspot.no/2011/01/installing-active-directory-tools-under.html

Move Crowd MS SQL database to another server

In order for move the MS SQL database for Crowd (same OS), I did the following:

1. Shutdown application/service Crowd
2. Backup ms sql Crowd database
3. Restore the backup to another MS SQL server
4. Check that the “crowd” user for the database can log into the database (very often you have to recreate the user with the correct password)
5. Edit C:\AtlassianCrowd240\crowd.cfg.xml
   • <property name=”hibernate.connection.url”>jdbc:jtds:sqlserver://SERVERNAME:1433/crowd</property>
6. Startup application/service Crowd
7. If there is error – check log file C:\AtlassianCrowd240\logs\atlassian-crowd.log

Read more:

https://confluence.atlassian.com/display/CROWD/Migrating+Crowd+Between+Servers

 

Moving Jira MS SQL database to another server

In order for move the MS SQL database for Jira (same OS), I did the following:

1. Shutdown application/service Jira
2. Backup ms sql Jira database
3. Restore the backup to another MS SQL server
4. Check that the “jira” user for the database can log into the database (very often you have to recreate the user with the correct password)
5. Edit C:\Program Files (x86)\Atlassian\Application Data\JIRA\dbconfig.xml
   • jdbc:jtds:sqlserver://SERVERNAME:1433/AtlassianJIRA
6. Startup application/service Jira
7. If there is error – check log fileC:\Program Files (x86)\Atlassian\JIRA\logs

Read more:

https://confluence.atlassian.com/display/JIRA/Switching+Databases