Symantec Management Platform (Notification Server)

Hi there,

On a monthly basis we are required to provide a software audit for a branch within our company. This branch consists of approximately 40 devices.

With no SQL knowledge and minimal Altiris experience the best i've been able to come up with is to run individual 'Installed SW by computer' reports. As you can imagine... this is quite time consuming.

Is anyone please able to offer some guidance or advice on speeding this up? Is there a way to create a custom script so I can automate querying each device individually? Can I create a filter, insert assets and then report on the filter instead? 

Relative symantec altiris newbie looking for help

Cheers

Hi,

Below is a basic SQL script for searching add remove programs: <Just get the GUID fro the filter and replace>

declare @filter uniqueidentifier = 'eb3a1a12-e1c7-4431-b060-f0333e4e488c' --All Computers

Select distinct vc.Name 'Computer Name'
	,vc.[IP Address]
	,vc.[User] 'AD User Name'
	,case when ua.[Full Name] is NULL then ISNULL(vc.[User],'') else ISNULL(ua.[Full Name],'') end 'User'
	,p.DisplayName
	,p.DisplayVersion
	,p.InstallDate
From vComputer vc
JOIN Inv_AddRemoveProgram p on p._ResourceGuid = vc.[Guid]
left join Inv_UG_User_Account ua on ua._ResourceGuid = vc.[Guid] and vc.Domain+'\'+vc.[User] = ua.[User Name]
JOIN dbo.CollectionMembership cm ON cm.ResourceGuid = vc.[Guid]    
JOIN dbo.vCollection it ON it.Guid = cm.CollectionGuid
Where vc.IsManaged = 1 and p.DisplayName like '%' and p.DisplayVersion like '%'
and p.InstallFlag = 1
and p.DisplayName not like '%update%'
and p.DisplayName not like '%update%'
and it.[Guid] in (@filter)

Attached is the report to import. (just right click on reports > Import

 Report should look like this:

Attachment(s)

Add Remove Programs Search.xml   20 KB 1 version

Hi there, thank you for the quick responses! Do these solutions offer the ability to report on bulk assets at once? Or would they need to be done individually?

Hi again,

Just to rephrase this question:

Is there functionality that will allow me to Create a filter, dump a list of computer ID's in it, call it "Cheeseburger", and then create a clone of "Installed software by computer" which will report on filter "Cheeseburger" instead of individual computers?