How to determine which Dell systems may have a battery for recall.

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%'

 

 

Solution Removal Tool (Removes Solution from Database)

Problem

Sometimes after uninstalling a solution from either the Add/Remove Programs or from the Solution Center you find that this has not removed the solution completely from the Database.  Some symptoms that you will see is referrences to the Solution in the Tree Structure on the Notification Server Admin Console.  You may also see a refference to the Solution when attempting to view the GetLicenseDetails.aspx page which would returns a ASP Dump.

---

Environment

---

Cause
	At this time the root cause is undetermined.  It may be a combination of things including SQL Deadlocks or Security.

---

Resolution

Use the following Solution Removal Tool.  In the sample below this will remove Web Administrator for Windows from the Altiris Database.  Please remeber when running this tool to select the correct database to run the query against.  Please note that you use this Removal Tool at your own risk, Database backup is higly recommended before running. Change the @Guid to the Product Guid of the solution you wish to remove: DECLARE @GUID varchar(40) REM Replace GUID with Product GUID of the Solution you wish to Remove from the Altiris Database SET @GUID = '{B2CF75A5-C442-4945-A979-1EAFDD182A76}'   Delete from Item where Guid = @Guid Delete from Item where ProductGuid = @Guid Delete from Item where SecurityGuid = @Guid Delete from ItemClassUserCreatable where ProductGuid = @Guid Delete from ItemDeleted where ItemGuid = @Guid Delete from ItemNameCache where ItemGuid = @Guid Delete from LicenseStatus where ProductGuid = @Guid Delete from SecurityACE where EntityGuid = @Guid Delete from SecurityACEChanged where EntityGuid = @Guid Delete from SecurityEntity where Guid = @Guid Delete from String where BaseGuid = @Guid Delete from StringCacheRN where BaseGuid = @Guid

Script to install SVS Agent

Question
How do you do a silent install of the Software Virtualization Agent?

Answer

Run the following from a command line or in a script:
msiexec.exe /qb? /i \Software_Virtualization_Agent.msi PRODUCT_KEY=

Replace:

= Path to folder containing Software_Virtualization_Agent.msi
= Your SVS product key in xxxx-xxxx-xxxx-xxxx format

Altiris licensing technical FAQ

All the technical questions about license usage can be read here