Symantec Management Platform (Notification Server)

Hello All

I am trying to create some reports that is based on the information found on the Resource Manager Home section.

I found this kb on the support site http://www.symantec.com/docs/HOWTO7871

But the information is based on Altiris 6.x database queries and it seems that the information is in different database tables now.

For example the Hardware information query in the article shows this

select

isnull(a.[System Manufacturer], N'')

,isnull(a.[Computer Model], N'')

,isnull(a.[System Model Number], N'')

from vResource r

left join Inv_AeX_HW_Serial_Number a on a.[_ResourceGuid] = r.[Guid]

left join Inv_AeX_AC_Identification i on r.[Guid] = i.[_ResourceGuid]

where r.[Guid] = @ResourceGuid

But there is no Inv_AeX_HW_Serial_Number table and I cannot seem to find where it is in 7.1 tables.

Thanks

RIchard

Much of this information is included in the vHWChassis view.  You could create a query like this:

SELECT

vc.Name,

vwc.[Serial Number],

vwc.Manufacturer,

vwc.Model,

vwc.[Asset Tag]

FROM vComputer vc

JOIN vHWChassis vwc on vwc._ResourceGuid=vc.Guid

You can also find columns using a query like this:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%Serial%' AND TABLE_NAME NOT LIKE 'xdls%' ORDER BY TABLE_NAME

Does this help?

Thanks, that is what I needed for my reports