Symantec Management Platform (Notification Server)

Hello,

Everytime when our client wants us to deploy software, they give us Excel sheet with 50+ user names (first name + last name)

Then, when I must create deployment collection to NS, I must first use Active Directory Users and Computers MMC and search for user name to find out his login name. After I have login name,  I must search Altiris computer collection for login name to find out computers where this specific user is marked as Primary User. After this, I have computer names and I can create deployment collection. This is sooooo frustrating job.

Is there any method or report available for NS, which displays computer names and primary users first + last name?

We don't have any asset database.

You could create a custom report via SQL to match the User fields with the Computer.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT

vc

.[Name] AS [Computer Name],

vc

.[User] AS [Primary User],

vu

.[Display Name] AS [AD Display Name],

vu

 

.[Email] AS [AD Email Address]

FROM

vComputer vc JOIN vUser vu ON vu.[Name] = vc.[User]

ORDER

 

BY [AD Display Name] ASC
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Hi Kev,

I will test your report on monday.

I wonder, is it possible to modify collections to display this information?

Teijo,
The columns displayed in collections are not modifiable.  What you can do however is write a report:

SELECT <columns>
FROM vComputer vc
JOIN vUser....<whatever other tables you need>
JOIN CollectionMembership cm
ON vc.Guid = cm.ResourceGuid
WHERE cm.CollectionGuid = '%_CollectionGuid%'

Then in the report configuration, add a new parameter of type Item Picker with a filter of Collections.  Then you can run the report on whatever collection you want.

Kev,

Your script works beautifully. Thank you.

Thank you Kyle for additional information about collection. Shame I can't mark two solutions.

I can't say this more clearly from experience...

NEVER USE VCOMPUTER IN A COLLECTION!