Symantec Management Platform (Notification Server)

Does anyone know how to get the output of the Resource manager on a single computer that shows the user logon and logoffs into a report or csv?

It's frustrating that  you can view the list but there is no way to copy/print or output the result to something? 

C

Hi Carlson,

Create an SQL Report with the following query. You can adapt the report or the query to your needs:

select

vc.Name [Computer Name], cl.[Event], cl.[User],cl.Domain, cl.Time, cl.[Login Time], cl.Duration

from Evt_AeX_Client_LogOn cl

join vcomputer vc on cl._ResourceGuid = vc.Guid

where vc.name like '%ComputerName%'

After create the SQL Report, add Parameters to your report.

1) In Query Parameters tab, click Add -> New Parameter

Name: ComputerName

Description: Leave in blank

Other options leave as default and click OK.

2) In the Report Parameters tab, click Add - New Parameter

Name: ComputerName

In Value Provider field choose Basic Parameter Value Edit

In Label Text: Computer Name:

3) Click OK.

4) Run your report with the computer name that you´re looking for Logon/Loggoff events.

Regards,

Hi Thanks thats just what i needed

C