Sunday, April 2, 2017

Skype database analyzer

I was going through my old computer files and found files for my old Skype account. Initially, I used SkypeLogView from Nirsoft (http://www.nirsoft.net/utils/skype_log_view.html).
It was examining main.db file located under C:\Users\USERNAME\AppData\Roaming\Skype\SKYPE_USERNAME\. I looked at the file type and it was sqlite database then I used DB Browser for Sqlite (http://sqlitebrowser.org/) to examine the database. I found way more information than what I got from SkypeLogView.

I ended up writing a script to extract some of that information. Initially, I wanted a graph like one displayed here https://github.com/x0rz/tweets_analyzer for all the contacts. I never got that far.

What the script currently does:

  • Extract info about the main account. Info such as emails, phone #'s, mood info, and etc.
  • Extract info about contacts. Skype even stores people who you were in group chat with but whom you haven't added to contact list. 
  • Gets info on how many messages each author has sent.
  • Similar to tweets analyzer, it gets info for hour and number of messages for each author. It doesn't do the cool graph though. :(
  • Prints top 10 words used by each author. (This is kinda useless)

Feel free to copy it. I spent a day on writing that so it's not that great. If anyone improves it, leave a comment. 

2 comments:

  1. Hello Everyone !

    USA Fresh & Verified SSN Leads along with Driving License/ ID Number, AVAILABLE with 99.9% connectivity
    All Leads have genuine & valid information.

    **DETAILS IN LEADS**
    First Name | Last Name | SSN | Dob | Driving License Number | Address | City | State | Zip | Phone Number | Account Number | Payday | Bank Name | Employee Details | IP Address

    *Price for SSN lead $2
    *You can ask for sample before any deal
    *If anyone buy in bulk, we can negotiate
    *Sampling is just for serious buyers

    ==>ACTIVE, FRESH CC & CVV FULLZ AVAILABLE<==
    ->$5 PER EACH

    ->Hope for the long term Business
    ->Interested buyers will be welcome

    **Contact 24/7**
    Whatsapp > +923172721122
    Email > leads.sellers1212@gmail.com
    Telegram > @leadsupplier
    ICQ > 752822040

    ReplyDelete
    Replies
    1. Hello all
      am looking few years that some guys comes into the market
      they called themselves hacker, carder or spammer they rip the
      peoples with different ways and it’s a badly impact to real hacker
      now situation is that peoples doesn’t believe that real hackers and carder scammer exists.
      Anyone want to make deal with me any type am available but first
      I‘ll show the proof that am real then make a deal like

      Available Services

      ..Wire Bank Transfer all over the world

      ..Western Union Transfer all over the world

      ..Credit Cards (USA, UK, AUS, CAN, NZ)

      ..School Grade upgrade / remove Records

      ..Spamming Tool

      ..keyloggers / rats

      ..Social Media recovery

      .. Teaching Hacking / spamming / carding (1/2 hours course)

      discount for re-seller

      Contact: 24/7

      fixitrogers@gmail.com

      Delete