myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


IBM LEVENO battery recall

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> IBM LEVENO battery recall Page: [1]
Login
Message << Older Topic   Newer Topic >>
IBM LEVENO battery recall - 9/29/2006 12:11:50 PM   
schramosta

 

Posts: 93
Score: 3
Joined: 7/23/2003
Status: offline
Is there any way within SMS to report on the machines that are impacted by this battery recall.

IBM offers a batterycheck.exe program, but I don't see any way to centralize the results.

Steve
Post #: 1
RE: IBM LEVENO battery recall - 9/29/2006 4:59:34 PM   
skissinger


Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline
*warning* work in progress!

Pre-requisite: in sms_def.mof, change FALSE to TRUE for the SMS_Report "Battery", and in the keys below, you only need TRUE for 2 things: for DeviceID (the key field) and Name

Here's what I've got so far as a report.  However, there is still some debate going on about whether or not the criteria of Battery Model is really all you need to look for.  If a consensus is reached, I'll update this thread.

select distinct SYS.Netbios_Name0, sys.User_Name0 [Last Logged on User], sys.AD_Site_Name0, Batt.Name0 [Battery Model],
case CSYS.Model0
When '23718VU' then 'IBM X40 23718VU'
When '2371K4U' then 'IBM X40 2371K4U'
When '2373k1u' then 'IBM T42P Centrino 2373K1U'
when '2373k9u' then 'IBM T42P #1 2373K9U'
When '23736zu' then 'IBM T42 23736ZU'
When '237375u' then 'IBM T40 237375U'
When '2373w1j' then 'IBM T40 2373W1J'
When '2373pu7' then 'IBM T40 2373PU7'
When '237372u' then 'IBM T40 237372U'
when '23718vu' then 'IBM X40 23718VU'
when '200755u' then 'IBM T60 15" '
when '200768u' then 'IBM T60 14" '
when '170685u' then 'IBM X60 (170685u)'
when '170686u' then 'IBM X60 (170686u)'
else CSYS.Model0 end as 'Model' from v_r_system sys
inner join v_GS_Battery batt on batt.resourceid=sys.resourceid JOIN v_GS_Workstation_Status ws on batt.ResourceID=ws.ResourceID join v_GS_Computer_System CSYS on SYS.ResourceID=CSYS.ResourceID
where (batt.name0 like '%92P1072%' or batt.name0 like '%92P1088%' or batt.name0 like '%92p1142%' or batt.name0 like '%92p1170%' or batt.name0 like '%92p1174%' or batt.name0 like '%92p1073%' or batt.name0 like '%92p1089%' or batt.name0 like '%92p1141%' or batt.name0 like '%92p1169%' or batt.name0 like '%92p1173%' or batt.name0 like '%93p5028%' or batt.name0 like '%93p5030%')
and  datediff(day,ws.LastHWScan,getdate()) < "30"
order by sys.ad_site_name0

(in reply to schramosta)
Post #: 2
RE: IBM LEVENO battery recall - 10/2/2006 1:48:58 PM   
skissinger


Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline
Update: I haven't heard that any other battery model types are required, and the query above turned into a FAQ, so I think we can consider this procedure & report good to go.

http://www.myitforum.com/faqs/afmmain.aspx?faqid=95

(in reply to skissinger)
Post #: 3
RE: IBM LEVENO battery recall - 10/3/2006 3:53:34 PM   
JBravoM3

 

Posts: 1
Score: 0
Joined: 8/15/2006
Status: offline
In speaking with Lenovo, it does appear that the Name or FRU number via WMI will tell you if a battery "may" be part of the recall (basically a Sony) but will not clearly identify it as being one that needs to be recalled. There is another 11S bar code that determines that and so far I have been unable to determine that exists anywhere in WMI. Still waiting on a response from them to see if there is another location in WMI to get that info.

(in reply to schramosta)
Post #: 4
RE: IBM LEVENO battery recall - 10/6/2006 4:35:38 AM   
apurba

 

Posts: 29
Score: 0
Joined: 6/11/2005
Status: offline
Check with your IBM / Lenvo rep, they provided us a tool what we used, then we pushed an advert to all IBM laptops and collected the file for each machine on a server share,  from there I then used the DOS find command

File from Lenovo is Battinfo.exe

battinfo --unattended --outputfilename \\servername\IBMBAT\%COMPUTERNAME%.csv

(in reply to JBravoM3)
Post #: 5
RE: IBM LEVENO battery recall - 10/6/2006 7:22:51 AM   
skissinger


Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline
I've been waiting for our Asset Manager to get this from our Lenovo rep--but haven't heard anything.  Assuming that the file wasn't accompanied with an agreement telling you not to share it, could you upload it? 

How to upload:  http://www.myitforum.com/faqs/afmmain.aspx?faqid=97

(in reply to apurba)
Post #: 6
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> IBM LEVENO battery recall Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.279