Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

64 bit computers in 32 bit collections

Updated: 21 May 2010 | 7 comments
rpoag's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

I am looking at the collections and the 64 bit windows computers collection is almost empty.  I looked at the inventory of a workstation I knew to be 64 bit and the system type is being reported as 32 bit while the OS version is 5.2 (clearly 64 bit windows xp).  I know if I delete the record and submit a new inventory that will most likely fix the issue but then I lose the recovery solution account.  I was thinking of deleting the data in the inv_aex_ac_identification table to let it repopulate since that is the table at issue.  Does anyone know a better way or know if I am going to create some other problem by doing that?

Comments

jharings's picture
15
Oct
2009
0 Votes 0
Login to vote

I thought this was a known issue

with a particular NS agent version, but I can't seem to find it. Your solution is interesting, as the client would keep it's guid locally, and therefore reassociate itself in the db.

I'm still searching for that issue, but you are at the latest agent version right?

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

rpoag's picture
15
Oct
2009
0 Votes 0
Login to vote

We are running version

We are running version 6.0.2403 which I believe is the latest version.  I have a query I found on the knowledgebase for forcing the NS to accept the data a computer submits next so I am running that against machines one at a time for now.  There has to be a better way.
 

declare

@computer char(20)

set

@computer=''

UPDATE

[ResourceUpdateSummary]

SET

[DataHash] = NULL

WHERE

and

[InventoryClassGuid] IN (SELECT [Guid] FROM [Dataclass] WHERE [Name] LIKE 'AeX HW%' OR [Name] LIKE 'AeX SW %' OR [Name] LIKE 'AeX OS%' OR [Name] LIKE 'AeX EU%') resourceguid = (select guid from vcomputer where name = @computer)

Ryan Poag<br>Campbell & Company, Inc.<br>If your question has been resolved, please be sure to "Mark as Solution"! Thank you.

rpoag's picture
15
Oct
2009
0 Votes 0
Login to vote

I think I have a better

I think I have a better query:

UPDATE [ResourceUpdateSummary]
SET [DataHash] = NULL
WHERE [InventoryClassGuid] IN (SELECT [Guid] FROM [Dataclass] WHERE [Name] LIKE 'AeX HW%' OR [Name] LIKE 'AeX SW %' OR [Name] LIKE 'AeX OS%' OR [Name] LIKE 'AeX EU%')
and exists (select guid from vcomputer where exists (select *
from inv_aex_ac_identification
where [os version] = '5.2'
and [system type] = 'win32'
and [os type] = 'professional'))

Ryan Poag<br>Campbell & Company, Inc.<br>If your question has been resolved, please be sure to "Mark as Solution"! Thank you.

KSchroeder's picture
16
Oct
2009
0 Votes 0
Login to vote

AD Import

Ryan,
I will guess that AD Import is the culprit here.  If you force a basic Inventory from the machine (or via Power Management) does the System Type update properly?  If so then the issue is with the AD Import.  Apparently by default it can't gather the architecture of the machine, and so it sets all Windows machines to Win32 when it runs.  There is a work-around, but when I tried implementing it, it actually made things worse as it blanked out the System Type on all my machines until they sent Basic Inventory again.  A few KB articles:

https://kb.altiris.com/article.asp?article=44417&p=1 (specifically about AD Impor resetting the value)
https://kb.altiris.com/article.asp?article=42066&p=1 (talks about Basic Inventory resetting x64 to Win32)

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

rpoag's picture
16
Oct
2009
0 Votes 0
Login to vote

I will check that out to

I will check that out to see.  Thanks for the suggestion.  My question is why does the AD import have a default machine type anyway?

Ryan Poag<br>Campbell & Company, Inc.<br>If your question has been resolved, please be sure to "Mark as Solution"! Thank you.

rpoag's picture
16
Oct
2009
0 Votes 0
Login to vote

That does seem to be the

That does seem to be the issue.  I will have to figure out how I want to handle it.  Thanks.

Ryan Poag<br>Campbell & Company, Inc.<br>If your question has been resolved, please be sure to "Mark as Solution"! Thank you.

KSchroeder's picture
19
Oct
2009
0 Votes 0
Login to vote

I'm waiting to hear back from

I'm waiting to hear back from my AE about how to handle this, and exactly how to set it up so that the system type will not be blanked out if it is already valid, but anything already populated will remain.

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.