Symantec Management Platform (Notification Server)

Hi I am running a report of non-active computers, I need to also report on the serial numbers of these inactive computers as we have had a few computers disappear off site and they may have been retired. Could anyone help me with the extra info I need, I have tried to copy sql from other reports that do find serial numbers without any success to date.

Also does anyone know of any good documentation on how to create reports.

Thanks in advance
Cat

Below is my sql for non-active computers
declare
@computerTypeGuid uniqueidentifier,
@VirtualMachineTypeGuid uniqueidentifier

set @computerTypeGuid = '493435F7-3B17-4C4C-B07F-C23E7AB7781F'
set @VirtualMachineTypeGuid = '2C3CB3BB-FEE9-48DF-804F-90856198B600'

select i.Name,
vfars.Guid as _ResourceGuid,
vfars.Status,
i.CreatedBy as [Created By],
i.CreatedDate as [Created Date],
i.ModifiedDate as [Modified Date]
from vFixedAssetResourceStatus vfars
left outer join item i on i.Guid = vfars.Guid
where ResourceTypeGuid in (@computerTypeGuid, @VirtualMachineTypeGuid)
and vfars.Status != '%StatusFilter%'
order by vfars.Status, i.[Name]

I don't see where you are defining the alias for 'i'.
The table for serial numbers is AeX_Inv_HW_Serial_Number

There is a pretty good SQL primer on Altirigos, and the KB has a few articles on how to create reports using the report builder. The #1 thing I have to share is that you have to learn the schema. Which of course is changing in NS7.