Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

computer users

Created: 22 Apr 2013 • Updated: 23 Apr 2013 | 2 comments
This issue has been solved. See solution.

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

Operating Systems:

Comments 2 CommentsJump to latest comment

fabio.sanches's picture

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,

SOLUTION
carlsson's picture

Hi Thanks thats just what i needed

C

Hojiblanca