Take a look at our
ThinkPads.com HOME PAGE
For those who might want to contribute to the blog, start here: Editors Alley Topic
Then contact Bill with a Private Message

ThinkPad Machine Type - Model lookup table *PIC*

General Questions, Rumors, Real news & More
Post Reply
Message
Author
twistero
Senior Member
Senior Member
Posts: 851
Joined: Sun Feb 26, 2012 2:25 am
Location: Princeton, New Jersey
Contact:

ThinkPad Machine Type - Model lookup table *PIC*

#1 Post by twistero » Wed Oct 29, 2014 1:49 am

As people have noticed, the new Lenovo support site have very limited support for Machine Type - Models lookups of legacy systems. Right now that feature is still available at http://support1.lenovo.com, but that website may be decommissioned at any moment.

Obviously I have to step in and save the day. :twisted: :mrgreen: :roll:

A python script and several days later I have scraped everything I could from the old support site's model selector. Only ThinkPads, though. 552374 models in total.

This file is a bit large for online services like Google Spreadsheets (400000 cells max), so unfortunately no quick online lookups. Someone who already have a database backend in place may consider hosting a copy and providing a search interface for it (or I can make one if someone pays the bill :roll: ) But a complete offline copy works just as well.

Head over here to download an Excel spreadsheet containing the entire ThinkPad MTM database.

Admin edit: Added PIC warning since I added an image downthread.
X60 tablet 6363-P3U, 3GB ram, 128GB SanDisk Extreme SSD, SXGA+ screen, Intel 6300
T61 Frankenpad in 15 inch T60 body, UXGA LED-lit AFFS LCD, T9300, 6GB RAM, NVidia NVS140m, Intel 6205, 128GB Crucial M4 SSD, 1TB HGST HDD + eBay caddy in Ultrabay
701c butterfly, 75MHz 486DX4, 40MB ram, 1GB CF card

rkawakami
Admin
Admin
Posts: 10135
Joined: Sun Jun 04, 2006 1:26 am
Location: San Jose, CA 95120 USA
Contact:

Re: ThinkPad Machine Type - Model lookup table

#2 Post by rkawakami » Wed Oct 29, 2014 4:39 am

Thanks for all the work! I imported the raw .CSV file into Access 2003 since Excel has a row limit of 64K. Sorted on Fields 3 and 4 and the list is in numerical order so it's easy to find whatever I need. Of course if I knew how to construct a proper query then I probably wouldn't have had to do this sort.
Ray Kawakami
X22 X24 X31 X41 X41T X60 X60s X61 X61s X200 X200s X300 X301 Z60m Z61t Z61p 560 560Z 600 600E 600X T21 T22 T23 T41 T60p T410 T420 T520 W500 W520 R50 A21p A22p A31 A31p
NOTE: All links to PC-Doctor software hosted by me are dead. Files removed 8/28/12 by manufacturer's demand.

Johan
Moderator Emeritus
Moderator Emeritus
Posts: 1998
Joined: Mon Mar 07, 2005 2:00 pm
Location: Copenhagen, Denmark

Re: ThinkPad Machine Type - Model lookup table

#3 Post by Johan » Wed Oct 29, 2014 5:49 am

Wauw; truly another both outstanding and awesome effort by Twistero... greatly appreciated!! :bow: :bow:

I already downloaded the file, opened it with Microsoft Excel 2010 with no difficulties (although as mentioned by Twistero it's *big* containing 552374 lines), and I am able to search for all the models with no difficulties.

What a pleasure being member of such a friendly support-forum as this, and what a huge asset for the forum to have super-helpful and TOP-expert members amongst us such as Twistero!

Thank you, thank you, thank you - personally, I just wish I had, say, 1 % of your skills; man, ooh, how I'd then be clever! :wink:

Johan
IBM T42p's (2373-Q1U & -Q2U): 2.1 GHz, 15" UXGA FlexView, 2 GB RAM, 128 MB FireGL T2, 128 GB 1.8" SATA SSD, IBM a/b/g, BT, Win 7 Ultimate
IBM T42 (2373-N1G): 1.8 GHz, 15" SXGA+ FlexView, 2 GB RAM, 64 MB Radeon 9600, 64 GB 1.8" SATA SSD, IBM a/b/g, BT, Win 7 Ultimate

FryPpy
Senior Member
Senior Member
Posts: 501
Joined: Thu Dec 06, 2012 3:29 pm
Location: Moscow, Russia

Re: ThinkPad Machine Type - Model lookup table

#4 Post by FryPpy » Wed Oct 29, 2014 12:28 pm

twistero wrote: Obviously I have to step in and save the day. :twisted: :mrgreen: :roll:
Thank you good MAN. When they (Lenovo) wiped their databases i have felt both hands cutted off :( I don't know is a S/N lookup is working now (can be saved) but it is good thing too.

I know that this work needs some time - but maybe it is worth while to divide your xlsx-file (database) to parts for models (T60, T61, T500 etc). It produce many small files that can be uploaded to free hosting providers.

RealBlackStuff
Admin Emeritus
Admin Emeritus
Posts: 19511
Joined: Mon Sep 18, 2006 5:17 am
Location: Mt. Cobb, PA
Contact:

Re: ThinkPad Machine Type - Model lookup table

#5 Post by RealBlackStuff » Thu Nov 27, 2014 5:30 am

Made this into a Sticky. Thanks twistero! :thumbs-UP: :bow:

Once you have loaded this in Excel 2010, click on Home, then Find & Select (all the way on the right) and type in e.g. (7661-E17) and include the Parentheses.

In Excel 2003/2007, click on Edit, then Find and type in e.g. (7661-E17) and include the Parentheses.
Lovely day for a Guinness! (The Real Black Stuff)

Check out The Boardroom for Parts, Mods and Other Services.

bluefruit
Posts: 21
Joined: Wed Nov 27, 2013 6:58 am
Location: Singapore

Re: ThinkPad Machine Type - Model lookup table

#6 Post by bluefruit » Wed Jan 14, 2015 7:59 am

Thanks for archiving this. The MTM of both my T61 and X300 showed an error on Lenovo's new support site, but is available in your excel file! :)

RealBlackStuff
Admin Emeritus
Admin Emeritus
Posts: 19511
Joined: Mon Sep 18, 2006 5:17 am
Location: Mt. Cobb, PA
Contact:

Re: ThinkPad Machine Type - Model lookup table

#7 Post by RealBlackStuff » Wed Jan 14, 2015 8:23 am

A member of the German Thinkpad forum has created an online program where you just type in the MTM, like: 2647-4MU and it comes up with the result.
http://sm.krelay.de/tp/index.php
The program was originally in German, but after I asked the programmer, it now switches automatically to English (depending on browser).

(the link was first posted here: http://forum.thinkpads.com/viewtopic.ph ... 90#p748390).
Lovely day for a Guinness! (The Real Black Stuff)

Check out The Boardroom for Parts, Mods and Other Services.

dr_st
Moderator
Moderator
Posts: 7544
Joined: Sat Oct 29, 2005 6:20 am

Re: ThinkPad Machine Type - Model lookup table

#8 Post by dr_st » Wed Jan 14, 2015 1:50 pm

RealBlackStuff wrote:A member of the German Thinkpad forum has created an online program where you just type in the MTM, like: 2647-4MU and it comes up with the result.
http://sm.krelay.de/tp/index.php
The program was originally in German, but after I asked the programmer, it now switches automatically to English (depending on browser).
This is awesome!

Now if someone just makes a Mycroft search plugin for that site, it would be already much better than what we had with Lenovo. :mrgreen:
Thinkpad 25 (20K7), X1 Carbon (20HQ), Yoga 14 (20FY), T430s (IPS FHD + Classic Keyboard), X220 4291-4BG, X61 7673-V2V
T60 2007-QPG, T42 2373-F7G, X32 (IPS Screen), A31p w/ Ultrabay Numpad, A21m 2628-GXU

rkawakami
Admin
Admin
Posts: 10135
Joined: Sun Jun 04, 2006 1:26 am
Location: San Jose, CA 95120 USA
Contact:

Re: ThinkPad Machine Type - Model lookup table

#9 Post by rkawakami » Wed Jan 14, 2015 2:34 pm

Along those lines, I've just added a Firefox QuickSearch that taps into that database. As long as the MTM appears on a page, I can highlight it and perform the lookup. The URL to use when defining the QuickSearch to access that German site is:
http://sm.krelay.de/tp/index.php?type=%s
In operation, the "%s" token is replaced by the highlighted string. Thus, if 2647-HNU appears on a page (or even from this message composition box; but not from Firefox's own Search box), I highlight that MTM, right-click, hover over 'Search for "2647-HNU"... on', wait for the selection list to open up on the right, then click the "Thinkpad MTM lookup" entry. That opens up another tab at the sm.krelay.de site and the system description appears. Here's how it's setup in my browser's Quick Searches folder:

Image
Ray Kawakami
X22 X24 X31 X41 X41T X60 X60s X61 X61s X200 X200s X300 X301 Z60m Z61t Z61p 560 560Z 600 600E 600X T21 T22 T23 T41 T60p T410 T420 T520 W500 W520 R50 A21p A22p A31 A31p
NOTE: All links to PC-Doctor software hosted by me are dead. Files removed 8/28/12 by manufacturer's demand.

axur-delmeria
Senior ThinkPadder
Senior ThinkPadder
Posts: 2001
Joined: Mon May 28, 2012 5:49 am
Location: Metro Manila, Philippines

Re: ThinkPad Machine Type - Model lookup table *PIC*

#10 Post by axur-delmeria » Mon Feb 09, 2015 12:10 pm

Along those lines, I've just added a Firefox QuickSearch that taps into that database.
Nice tip!
Daily driver: X220 4291-C91 i7-2620M

Backup: X220 4291-P79 i5-2520M
Toy: X60F Core Solo U1300
In pieces: two retired but working X61Ts
RIP: 760XD 9546-U9E; X61 7676-A24; and a BOE-Hydis HV121P01-100 in failed SXGA+ mod
:cry:

RealBlackStuff
Admin Emeritus
Admin Emeritus
Posts: 19511
Joined: Mon Sep 18, 2006 5:17 am
Location: Mt. Cobb, PA
Contact:

Re: ThinkPad Machine Type - Model lookup table *PIC*

#11 Post by RealBlackStuff » Tue Mar 03, 2015 1:16 pm

In case any of you missed it: look at the top of each forum page for: Drivers - HMM - MTM (= Machine Type Model)
Lovely day for a Guinness! (The Real Black Stuff)

Check out The Boardroom for Parts, Mods and Other Services.

oboogie
Posts: 5
Joined: Fri Sep 14, 2012 5:04 pm
Location: Austin,TX

Re: ThinkPad Machine Type - Model lookup table *PIC*

#12 Post by oboogie » Thu May 28, 2015 11:00 pm

psref.lenovo.com : product Spec. reference; 05/15

http://www.lenovo.com/psref/psrefs_withdrawn.shtml : withdrawn product specs reference

lexicon
Freshman Member
Posts: 88
Joined: Sat Apr 26, 2008 9:09 pm
Location: Java
Contact:

Re: ThinkPad Machine Type - Model lookup table *PIC*

#13 Post by lexicon » Fri Nov 27, 2015 3:18 am

We've made simple form for quick search the mtm database (based on twisteroid excel file).

http://thinkpadder-id.com/mtm/

Feel free to use it; hope it helps...
T60p[2.0/4G/MomentusXT/ABG/UXGA/W7]
Past:701c T23 T4 T6 X3 X4 X6s

rkawakami
Admin
Admin
Posts: 10135
Joined: Sun Jun 04, 2006 1:26 am
Location: San Jose, CA 95120 USA
Contact:

Re: ThinkPad Machine Type - Model lookup table *PIC*

#14 Post by rkawakami » Fri Nov 27, 2015 5:22 am

lexicon wrote:We've made simple form for quick search the mtm database (based on twisteroid excel file).
Thanks! I just tried a random sample of four of my systems (T420, W500, T60p, T23) and it look fine.
Ray Kawakami
X22 X24 X31 X41 X41T X60 X60s X61 X61s X200 X200s X300 X301 Z60m Z61t Z61p 560 560Z 600 600E 600X T21 T22 T23 T41 T60p T410 T420 T520 W500 W520 R50 A21p A22p A31 A31p
NOTE: All links to PC-Doctor software hosted by me are dead. Files removed 8/28/12 by manufacturer's demand.

SkiBunny
Senior Member
Senior Member
Posts: 520
Joined: Wed Sep 06, 2006 6:51 pm
Location: Canada

Re: ThinkPad Machine Type - Model lookup table *PIC*

#15 Post by SkiBunny » Sat Dec 05, 2015 6:26 pm

Lenovo removed the MTM lookup again recently, so here's a big shout-out to all of you above... Thanks! :D :banana:
To me it's pure genius and invaluable work! :bow:

Ibthink
Senior Member
Senior Member
Posts: 780
Joined: Wed Apr 11, 2012 6:28 am
Location: Gelnhausen, Germany

Re: ThinkPad Machine Type - Model lookup table *PIC*

#16 Post by Ibthink » Sat Dec 05, 2015 7:13 pm

What do you mean? Its still there: http://support.lenovo.com/us/en/product ... e%20Search

Doesn´t work anymore with older machines though^^
IBM ThinkPad R50e | lenovo ThinkPad X301 | lenovo ThinkPad Z61t

SkiBunny
Senior Member
Senior Member
Posts: 520
Joined: Wed Sep 06, 2006 6:51 pm
Location: Canada

Re: ThinkPad Machine Type - Model lookup table *PIC*

#17 Post by SkiBunny » Tue Apr 05, 2016 9:59 pm

It comes & goes and it can depend on your location too. But that page will be gone forever for everyone in just a few more weeks.
Their new lookup (on the lenovo homepage) fails to find some models that the old lookup could.

So again, thanks to the contributors above for providing the complete MTM database lookup and the convenient interface to it. :thumbs-UP:

cadillacmike68
Senior Member
Senior Member
Posts: 747
Joined: Fri May 27, 2011 9:19 pm
Location: Not on Planet Znutar (FL)

Re: ThinkPad Machine Type - Model lookup table *PIC*

#18 Post by cadillacmike68 » Mon Aug 22, 2016 11:05 am

That's some spreadsheet. I was thinking "how in the haell are there over 500,000 models?" Then I did some digging, 7,000 T500 models alone - Wow. :eek:
760LD 9547 FUBARd
T21 2647; T22 2647 4@ 900MHz, 1@ 1GHz SXGA+; T23 2647 2@ 1.13GHz, 1@ 1.2GHz SXGA+, WiFi
T30 2366-88U 2GHz; 2366-83U 1.8G; 5@ 2366-LU0/66U; 2367-KU6 FUBARd
T61 8897, 2.4GHz SXGA+; 8898, 2.4GHz; 6463, 2.4 & 2.1GHz WSXGA+; 7658, 2.5GHz; T61p, 3 more T61s
T500 2

paulgj2
Posts: 23
Joined: Wed Oct 22, 2008 11:36 pm
Location: Bellevue, WA

Re: ThinkPad Machine Type - Model lookup table *PIC*

#19 Post by paulgj2 » Wed Dec 07, 2016 10:25 pm

Great spreadsheet! thanks for doing.

I was also wondering if it holds the info on the type of display whether LED or not. I have the old PSREF and it does indicated if a particular models display is LED or CCFL.

Thanks!
T400 6475-8Q5
T400 6474-P9U

T500 2082-3HU
T500 2242-8RU
T500 2089-5ZU
T500 2056-A48

TPFanatic
ThinkPadder
ThinkPadder
Posts: 1135
Joined: Thu Jul 30, 2015 11:29 pm
Location: Boston, Massachusetts

Re: ThinkPad Machine Type - Model lookup table *PIC*

#20 Post by TPFanatic » Wed Dec 07, 2016 10:45 pm

cadillacmike68 wrote:That's some spreadsheet. I was thinking "how in the haell are there over 500,000 models?" Then I did some digging, 7,000 T500 models alone - Wow. :eek:
I didn't know T500s with Radeon 3470 existed? :eek: An error in Lenovo's documentation perhaps? And then there's the mysterious R400 with Nvdia 9300GM. Amazing work.
lenovo X230 i5 3320m IPS 8GB
lenovo T430 i5 3320m FHD 8GB
lenovo T500 P9700 WUXGA 8GB


Enable 2 finger scroll on any Synaptics touchpads with registry: http://forum.thinkpads.com/viewtopic.php?f=2&t=122612

beko1987
Freshman Member
Posts: 60
Joined: Mon Aug 21, 2017 3:53 am
Location: Oxon, Britain

Re: ThinkPad Machine Type - Model lookup table *PIC*

#21 Post by beko1987 » Mon Sep 10, 2018 8:33 am

I've just found this, what an amazing project! I'm trying to upgrade my T40 and T43 with a SXGA+ screen, and thanks to this have bought a 99p very ratty T43 with said screen fitted! Much cheaper than hunting out just the screen! (although knowing my luck it'll be in better condition than my existing T43, but that's a problem for when it arrives...)

It also enabled me to get rid of several scrap/cheap thinkpads from my watch list (bar a nice T42 that I may succumb to) because they don't have the specs I don't already have in another machine!)

Bit of a game changer this...
Thinkpad T40
Thinkpad T43
Thinkpad X60 Tablet
Thinkpad R500

Post Reply
  • Similar Topics
    Replies
    Views
    Last post

Return to “GENERAL ThinkPad News/Comments & Questions”

Who is online

Users browsing this forum: No registered users and 7 guests