How to determine which Dell systems may have a battery for recall.
Question |
| How do you determine which systems in your environment may have a battery that needs to be replaced with the Dell laptop battery recall? |
Answer |
| You can run the following SQL query. NOTE: This query requires that your Notification Server have the Dell Client Manager installed. Select vc.[name] AS 'Computer Name',
bat.[name] AS 'Battery',
bat.[SerialNumber] AS 'Serial Number'
FROM vComputer vc
Inner Join dbo.Inv_OMCA_Battery bat on vc.Guid = bat._ResourceGuid
Inner Join (SELECT DISTINCT ResourceGuid FROM CollectionMembership cm Inner Join
dbo.Dell_OMCA_SupportedModels sm on cm.Collectionguid = sm.Collection AND
sm.ID LIKE '%Latitude%' OR sm.ID LIKE '%Inspiron%' OR sm.ID LIKE '%Precision%' OR sm.ID LIKE '%XPS%') A on vc.Guid = A.ResourceGuid
WHERE
bat.[Name] LIKE '%C5340%'
OR bat.[Name] LIKE '%D6024%'
OR bat.[Name] LIKE '%JD616%'
OR bat.[Name] LIKE '%U586%'
OR bat.[Name] LIKE '%7X5333%'
OR bat.[Name] LIKE '%3K590%'
OR bat.[Name] LIKE '%C5446%'
OR bat.[Name] LIKE '%D6025%'
OR bat.[Name] LIKE '%JD617%'
OR bat.[Name] LIKE '%U5882%'
OR bat.[Name] LIKE '%X5875%'
OR bat.[Name] LIKE '%59474%'
OR bat.[Name] LIKE '%C6269%'
OR bat.[Name] LIKE '%F2100%'
OR bat.[Name] LIKE '%KD494%'
OR bat.[Name] LIKE '%W5915%'
OR bat.[Name] LIKE '%X5877%'
OR bat.[Name] LIKE '%59474%'
OR bat.[Name] LIKE '%C6270%'
OR bat.[Name] LIKE '%F5132%'
OR bat.[Name] LIKE '%M3006%'
OR bat.[Name] LIKE '%X5308%'
OR bat.[Name] LIKE '%Y1333%'
OR bat.[Name] LIKE '%C2603%'
OR bat.[Name] LIKE '%D2961%'
OR bat.[Name] LIKE '%GD785%'
OR bat.[Name] LIKE '%RD857%'
OR bat.[Name] LIKE '%X5329%'
OR bat.[Name] LIKE '%Y4500%'
OR bat.[Name] LIKE '%C5339%'
OR bat.[Name] LIKE '%D5555%'
OR bat.[Name] LIKE '%H3191%'
OR bat.[Name] LIKE '%TD349%'
OR bat.[Name] LIKE '%X5332%'
OR bat.[Name] LIKE '%Y5466%' |
No comments:
Post a Comment