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: 852
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: 10327
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: 550
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: 23812
Joined: Mon Sep 18, 2006 5:17 am
Location: Loch Garman, Éire

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)
Lenovo: X240, X250, T440p, T480, M900 Tiny.

PS: the old Boardroom website is still available on the Wayback Machine
.

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: 23812
Joined: Mon Sep 18, 2006 5:17 am
Location: Loch Garman, Éire

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)
Lenovo: X240, X250, T440p, T480, M900 Tiny.

PS: the old Boardroom website is still available on the Wayback Machine
.

dr_st
Admin
Admin
Posts: 9692
Joined: Sat Oct 29, 2005 6:20 am
Location: Israel

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), T490 (20N3), 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

rkawakami
Admin
Admin
Posts: 10327
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: 3810
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!
Planned Purchase: T480s i5-8350 FHD Touch
Impulse Buy: Thinkpad not named for safety reasons :lol:
RIP: X220 4291-C91 X61 7676-A24 760XD-U9E :cry:

RealBlackStuff
Admin Emeritus
Admin Emeritus
Posts: 23812
Joined: Mon Sep 18, 2006 5:17 am
Location: Loch Garman, Éire

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)
Lenovo: X240, X250, T440p, T480, M900 Tiny.

PS: the old Boardroom website is still available on the Wayback Machine
.

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: 10327
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: 966
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
ThinkPadder
ThinkPadder
Posts: 1494
Joined: Fri May 27, 2011 9:19 pm
Location: Florida

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:
600 600X
760LD FUBARd
T21 2647 T22 2647 1@ 1GHz SXGA+ 4 more; T23 2647 1@ 1.2GHz SXGA+ 3 more
T30 2366-88U 2GHz; 2366-83U 1.8G; 5@ 2366-LU0/66U; 2367-KU6 FUBARd
T41 T42 T43
T60 T61 8897 2.4GHz SXGA+; 8898 2.4Ghz; 6463 2@ WSXGA+; 7658 2.5GHz; T61p; 6 more T61s
T500 2
T530 W530

paulgj2
Posts: 29
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!
W701 4323-CTO

T400 6475-8Q5
T400 6474-P9U

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

TPFanatic
Senior ThinkPadder
Senior ThinkPadder
Posts: 2213
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.

beko1987
Freshman Member
Posts: 76
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 X61
Thinkpad R500
Thinkpad X201

iamdmc
Senior Member
Senior Member
Posts: 745
Joined: Fri Sep 21, 2007 11:37 pm
Location: Downtown Toronto, Canada

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

#22 Post by iamdmc » Wed Mar 18, 2020 12:50 pm

FYI there's also a lenovo EOL website now for drivers

https://download.lenovo.com/eol/index.html

just discovered
ThinkPad P14sgen2 (2021)
i7-1185G7 | 32+8GB RAM | 1TB Samsung 980 Pro (PCIe 3.0 speed) | UHD upgrade | Glass Touchpad | Intel AX210

The X61 is dead... long live the X61

Past IBM ThinkPads: T480s, T450s, X250, X230, X220, X300, T410, X61s, T60p, T41, X31, T23, A21m

russur
Posts: 4
Joined: Fri May 21, 2021 5:23 am
Location: Moscow, Russian Federation

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

#23 Post by russur » Wed Oct 13, 2021 9:18 am

Hello!

Here is telegram bot for MTM lookup: https://t.me/thinkpad_mtm_bot

It is my first telegram bot, to build it I install linux on T60 (4:3 14'), learned Python and telegram API, and use serverless cloud function to host it. Was very interesting and exciting, returned to my student years :)

Please tell me about any errors.
Thanks for using!
T400 in everyday use
In my collection: x40, t42, x61, R60, T60, T61, T500, R500, T410, T420, T430.

RealBlackStuff
Admin Emeritus
Admin Emeritus
Posts: 23812
Joined: Mon Sep 18, 2006 5:17 am
Location: Loch Garman, Éire

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

#24 Post by RealBlackStuff » Wed Oct 13, 2021 10:10 am

Don't want to spoil your enthusiasm, but:
forbes.com wrote:Telegram's bots aren't secured using its encryption protocol, MTProto. Instead, the bot platform relies on Transport Layer Security (TLS) protocol used in HTTPS web encryption – which isn't robust enough on its own.
In view of the current security and data breaches, I would advise NOT to even try this out!
Lovely day for a Guinness! (The Real Black Stuff)
Lenovo: X240, X250, T440p, T480, M900 Tiny.

PS: the old Boardroom website is still available on the Wayback Machine
.

dr_st
Admin
Admin
Posts: 9692
Joined: Sat Oct 29, 2005 6:20 am
Location: Israel

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

#25 Post by dr_st » Wed Oct 13, 2021 11:21 am

RealBlackStuff wrote:
Wed Oct 13, 2021 10:10 am
Don't want to spoil your enthusiasm, but:
forbes.com wrote:Telegram's bots aren't secured using its encryption protocol, MTProto. Instead, the bot platform relies on Transport Layer Security (TLS) protocol used in HTTPS web encryption – which isn't robust enough on its own.
In view of the current security and data breaches, I would advise NOT to even try this out!
And what exactly is the risk? Which data are you sharing with the bot? BTW, how is the connection to Thinkpads.com forums secured? Is it not the same TLS/HTTPS?
Thinkpad 25 (20K7), T490 (20N3), 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

russur
Posts: 4
Joined: Fri May 21, 2021 5:23 am
Location: Moscow, Russian Federation

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

#26 Post by russur » Wed Oct 13, 2021 11:52 am

Security is an important thing for many people, I think. If you are already using Telegram, keep in mind that there is a MTM lookup bot.
I did it for myself, I will be glad if it is useful to someone. But no, no.

In any case, thanks to those who collected the information in the xls file.
T400 in everyday use
In my collection: x40, t42, x61, R60, T60, T61, T500, R500, T410, T420, T430.

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 42 guests