Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Report help - Which PCs has a user been logging into?

Created: 28 Feb 2011 • Updated: 01 Mar 2011 | 3 comments
This issue has been solved. See solution.

In CMS 6, I obtained a report that could tell us which PCs a user had logged into over a given timeframe, the report options looked like this:

The User ID box had every known user in a pick list, so it could be restricted to a particular user and date range (plus computer), otherwise it would show any user login between those dates.  The report doesn’t work under CMS 7, you get the alert shown above and when running the report, it generates a SQL error.

Does anyone have an equivalent report that could be used to get this information? Thanks.

Comments 3 CommentsJump to latest comment

Cesar_echeverria's picture

This SQL Query can help. SMP 7

SELECT dbo.vComputer.Guid, dbo.vComputer.Name as computer,

dbo.Evt_AeX_Client_LogOn.Event, dbo.Evt_AeX_Client_LogOn.Domain, dbo.Evt_AeX_Client_LogOn.[User], dbo.Evt_AeX_Client_LogOn.Time,

dbo.Evt_AeX_Client_LogOn.[Login Time], dbo.Evt_AeX_Client_LogOn.Duration

FROM dbo.vComputer LEFT OUTER JOIN

dbo.Evt_AeX_Client_LogOn ON dbo.vComputer.Guid = dbo.Evt_AeX_Client_LogOn._ResourceGuid

where dbo.vComputer.ismanaged = '1'

AND dbo.Evt_AeX_Client_LogOn.Time

BETWEEN dateadd(dd,-180,getdate()) AND GETDATE() --in last 180 days

order by dbo.vComputer.Name, dbo.Evt_AeX_Client_LogOn.Time

Cesar Echeverria Castillo

Consultant Engineer

InterLAN Ltda, Medellin, Colombia

P.S.: If this works please let the community knows about it.

Cesar_echeverria's picture

This report is based on the previous query. SMP 7

 

AttachmentSize
InterLAN User Logon.zip 3.53 KB

Cesar Echeverria Castillo

Consultant Engineer

InterLAN Ltda, Medellin, Colombia

P.S.: If this works please let the community knows about it.

SOLUTION
pro.gti's picture

Thanks for the query and report, that’s exactly what I was after, that will be very useful for us, for tracking down what PCs a user has been logging into.