Symantec Management Platform (Notification Server)

Hi,
We're using the above report, however, we'd like to have it so when we double click on a certain model, the next window that comes up also has the user name on it. Right now it just gives manufacturer, model, serial number and resource name. However we'd like to add the last logon user in there as well. I do not know SQL at all, would anyone be able to help?
Thanks!
 

Hi, I'm not sure which report you are using, but you will probably need somebody with a little SQL knowledge to know which table/view and which fields to include in the 2nd level query.

Sorry I had put it in the other forum and forgot to copy it on here.  And yeah it'll definitely have to be someone with SQL knowledge.  I tried looking at it, but it's like reading a language you don't understand.

Thanks

Do you have somebody available to help you with SQL? It wouldn't take very long to make the report. I can help if you want.

If you could help me that would be greatly appreciated!!

 Blah it looks like that report is very complicated with a bunch of Transact SQL... it would be much easier just to start from scratch using the report builder wizard. Unless somebody else here who is a SQL guru wants to whip it out... A new, simple one would require a basic query that joins the table with the hardware model info and the vComputer view (or other table) to get user info. I'm swamped right now so I won't be able to help right away. :(

Do you want Primary User or Last Logon User?

I would like Primary User please.

This one was answered for me in the other forum, here it is if anyone is interested.  Works perfectly!

Hi,
Clone the report and then replace the sql in the 2nd level query with:

SELECT DISTINCT
i.[Name],
ISNULL(s.[System Manufacturer],'No data reported') [System Manufacturer],
ISNULL(s.[Computer Model],'No data reported') [Computer Model],
s.[Serial Number], [Last Logon User],
s.[_ResourceGuid]
FROM dbo.Item i
JOIN dbo.Inv_AeX_HW_Serial_Number s
ON s.[_ResourceGuid] = i.Guid
JOIN dbo.Inv_AeX_AC_Identification d
ON d.[_ResourceGuid] = i.Guid
JOIN dbo.CollectionMembership cm
ON cm.ResourceGuid = d.[_ResourceGuid]
JOIN dbo.Item it
ON it.Guid = cm.CollectionGuid
WHERE d.[System Type] = 'Win32'
AND i.[Name] LIKE '%ComputerName%'
AND d.Domain LIKE '%Domain%'
AND it.[Guid] = '%Collection%'
AND
((s.[System Manufacturer] LIKE '%' + '%Level 1%' + '%'
AND s.[Computer Model] LIKE '%' + '%Level 2%' + '%' )
OR
(s.[System Manufacturer] LIKE '%' + '%Level 2%' + '%'
AND s.[Computer Model] LIKE '%' + '%Level 1%' + '%' ))
ORDER BY i.[Name]

All i've done is to add the field: [Last Logon User]

Dan