Altiris does not post back logon info as it happens so the database will always be out of date.

Look in Inventory for a sample of machines to see how up to date the information is, I think the information is in AeX_AC_Identification

Hi,

So this is not possible throgh Symantec Management Console Version 7.1.8280 for retrive AD user last logon timestap report.

Is there any other way for find the same fo altiris.

 What you need to think about is what information you want and where it is recorded. When a user logs on to a PC do you want this information to be sent to a database for every single login?

You could maybe create a custom inventory task to record this and put it in startup so it will record logged in user and time and post it back every time a user logs on.

Hi Andykn,

Thanks for reply,

Can you provide some steps and some scripts for retrive information.

Hi Ashish,

Last loging report is default in Altiris console.

Go to the Report->All Report->Discovery and Inventory->Inventory->Cross-platform->
User ->Local User Account Information

I hope you're satisfied this answers

Happy New Year

There is a table, Evt_Logon or something like that that hold logon and logoff events.  They are sent realtime (assuming the computer is connected to the network).

I personally user this report to monitor users but if you changed the where to the computer name you could do a search based on what you are asking.

For us users can regually change or logon to most computers in the business so its easier to know who the primary user is instead of the last logged on.

SELECT cid.[Name] Computer
,(LO.[Domain] + '\' + LO.[User]) [User]
,LO.[Login Time]
,LO.[Time] [Logout Time]
,CONVERT(decimal(10,2),ROUND((LO.[Duration]/60.0),2)) [Duration In Hours]
,LO.[Duration]
FROM [Altiris_CMDB7].[dbo].[Evt_AeX_Client_LogOn] LO
JOIN Inv_AeX_AC_Identification cid ON cid._ResourceGuid = LO._ResourceGuid
WHERE [User] LIKE '%%LOUSERNAME%%'
AND [LO].[Event] = 'Logoff'
ORDER BY LO.[Login Time] DESC