Symantec Management Platform (Notification Server)

We have been in the process of migrating from Livestate to DS and SMP for about 3 years and are getting ready to make a final thrust at the Livestate machines.

There is a service named "Symantec Livestate Agent" installed on the Livestate Machines.

Is there a way to query or report on what computers have this service installed in DS or SMP?

Thanks,

Wolfgang

Yeah the services are listed in the basic inventory of the SMP Agent. So you can create a report and define a query filter for the service name

I am missing something.  Where are you referring to when you say "In the basic Inventory?"  When I look through the reports, I am seeing nothing that is of any help.

A simple filter on the DS based on Application Description gets it done on the screen.

This query will get it done on the DS and then you can move it into Excel to manipulate it:

-- Show Computers that have the Livestate Service Installed
Use eXpress
SELECTDISTINCT computer.name,
service.name AS [Service Name],
service.description AS [Service Description]
FROM computer
INNERJOINserviceON computer.computer_id = service.computer_id
WHERE(service.name ='wcontrol')
ORDERBY computer.name
 

Now lets see if I can get a report out of the SMP that is emailed to management every Monday ....

If you wanted to create a report for 7.1, you would be looking at the Inv_AeX_AC_NT_Services table.

To create a report, you would go to Reports > All Reports, then right-click Reports and choose New > SQL Report. (Though I should really urge you to have a _Wolfgang's Custom Reports folder here.)  Then paste this in:

SELECT vc.Guid, vc.Name, nts.Name, nts.Description, nts.StartupType,nts.Version
FROM vComputer vc
JOIN Inv_AeX_AC_NT_Services nts ON nts._ResourceGuid=vc.Guid
WHERE nts.Description LIKE '%Livestate%'

If you want to use this for a filter, which is what you'd use as part of a target for a policy or task that uninstalls the program or service, you only need a query like this:

SELECT nts._ResourceGuid
FROM Inv_AeX_AC_NT_Services nts
WHERE nts.Description LIKE '%Livestate%'

Does this help?

Perfect!

Thank you!