Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How to search given string at all chat histories?
СTRL+F - search inside one chat, but I have a lot them, so I want find something in all saved chats?

share|improve this question
3  
Knowing your operating system would help! –  slhck Oct 10 '12 at 12:40
    
Have you looked here? shop.skype.com/apps/Search-Results.html?q=search#results –  Indrek Oct 10 '12 at 12:40
add comment

3 Answers

up vote 8 down vote accepted

In the Contact list or Recent list, simply click the contact or group you want to view the conversation history for and your conversation history is displayed.

The main.db database file where all chat history is stored. main.db is a standard SQLite database file and can be opened using any SQLite browser application. However, there is a free application, which is especially designed to read Skype’s chat and call data – SkypeLogView.

The main.db file is saved in one of the following (depending on OS).

On Windows 7 and Vista: C:\Users\[USER NAME]\AppData\Roaming\Skype\[Skype Name]

On Windows XP: C:\Documents and Settings\[USER NAME]\Application Data\Skype\[Skype Name]

On Mac OS X: Library/Application Support/Skype/[Skype Name]

For future, you may want to consider SkyHistory

share|improve this answer
1  
SkypeLogView - helps me, really nice tool. –  coms Oct 10 '12 at 15:48
2  
SkyHistory still works with recent Skype. Thanks! –  Vadzim May 20 at 13:52
add comment

Writing your own SQL queries using e.g. SqliteBrowser to search the Skype database, allows for more flexibility and functionality than using a 3rd party Skype-specific tool.

For example, this query will search for a text string in all your chats, an display the (local) time the message was posted, the message itself, the name of the chat (if it has a name), and who is in the chat.

select DISTINCT datetime(m.timestamp, 'unixepoch', 'localtime'), m.body_xml, c.topic, c.friendlyname
from Messages m
INNER JOIN Chats c ON m.convo_id = c.conv_dbid
where m.body_xml LIKE '%my text%' --case insensitive
order by m.timestamp DESC
share|improve this answer
add comment

SkyHistory did not work for me - seems like it was not designed for 68MB of skype logs : )

One of the most powerful approaches is a also very simple - just use SQLite client. Here I wrote a simple manual: http://jehy.ru/articles/2014/05/26/searching-through-skype-history/

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.