Differences between vItem and vComputer
Updated: 21 May 2010 | 5 comments
Hello,
I have a lot of differences in the reports between the summary page and the drill down to the detailed list.
I noticed that the summary page for the Client for example is running againts the vItem view and the drill down is running against the vComputer.
I have a lot of item in vItem which are not in vComputer (only comparing Computers as I am using the guid:
quote:
Select Name, * from vItem
Where Guid = '2D71D1FC-8086-44D4-82F5-00104AC67603'
OR Guid = 'FD3E2429-535D-40B4-84F4-323FC74FAEEF'
OR Guid = '0E895E03-CD62-4724-9F54-349AF5D48D05'
OR Guid = 'B3618128-FFB9-4842-94DA-67284402E7E5'
OR Guid = '6A636C45-BE4C-4919-A359-7863896B03A0'
OR Guid = '3A93C8DC-9E42-4A54-9249-BB35CA45E8FB'
OR Guid = 'F3914354-A824-40AB-8A45-D33455839259'
this is giving me 7 records
quote:
Select Name from vComputer
Where Guid = '2D71D1FC-8086-44D4-82F5-00104AC67603'
OR Guid = 'FD3E2429-535D-40B4-84F4-323FC74FAEEF'
OR Guid = '0E895E03-CD62-4724-9F54-349AF5D48D05'
OR Guid = 'B3618128-FFB9-4842-94DA-67284402E7E5'
OR Guid = '6A636C45-BE4C-4919-A359-7863896B03A0'
OR Guid = '3A93C8DC-9E42-4A54-9249-BB35CA45E8FB'
OR Guid = 'F3914354-A824-40AB-8A45-D33455839259'
this is giving me 0 record
Why these differences? How to correct them?
The Guids exist in Inv_AeX_AC_Client_Agent
Thanks
discussion Filed Under:
Comments
Dom,
From my understanding vitem is any object in the database, where vcomputer has to be a computer resource. For example, a software delivery package is an item. What is the issue, as you see it?
Jim
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.
hi Jim,
My main issue is between the Summary and the Detailed reports seen under the Report tab for the All Agents per Version etc...
The summary is always over what will be listed when I click on it and get the details.
So I checked the xml and also cloned the report to check the content and I have seen that the summary is running against the vItem view and the details is running againts the vComputer view.
So I picked a small report with the AClient version 6.5 and the summary was showing a number of 16 items when I click It displays only 9 items.
I run the same queries and extracted the Guid from the vItem which are missing in the vComputer. They all are computers as per their classguid and the name associated they are computers.
So I would like to know why a computer would be in vItem and not in vComputer?
Why the reports are done against two different views which could cause discrepancies?
Thanks,
vComputer only contains non-Retired assets (or Active assets) which might explain it. If you look at the "CREATE" information for the vComputer view, I think you will see this. It is a little indirect since vComputer uses vComputerResource, which in turn queries vActiveAsset (which has some GUID-based filters to remove some other status types from what I can tell).
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.
Hi Kyle,

This could be an explanation but still my issue remain as I have checking canned reports:
Reports --> Notification Server Infrastructure --> Agent --> Altiris Agent Deployment --> Client Agent Version for one example form my long!!! list of discrepancies...
I have attached the XML. The summary page and the detail page will never be in phasis
Does this means I need to customized all reports to make them real, coherent and compliant...?
Thanks
Kyle,
My problem is that I have a load of servers that are showing up in the Altiris Console as Resources, but are not showing up in vComputer. Interestingly, we have some Microsoft Clustered Servers that are in vComputer (which don't LITERALLY exist), but the underlying servers are not there! :-(
Why might that be? Are we using the right view? We need to export the details out to another database, but we do not have the right informatiuon to export!
Regards,
QuietLeni
I stand by the accuracy of my Inventory of the organisation. Don't blame me for the picture that it presents...
Would you like to reply?
Login or Register to post your comment.