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

Active Directory user last login report in altiris

Created: 12 Dec 2012 • Updated: 12 Dec 2012 | 10 comments

Hi,

I want to  Active Directory user last login report in altiris.

How to get this report in SQL query.

From where We can found this setting ?

Comments 10 CommentsJump to latest comment

andykn101's picture

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

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

Ashish-Sharma's picture

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.

Thanks In Advance

Ashish Sharma

 

 

andykn101's picture

 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.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

Ashish-Sharma's picture

Hi Andykn,

Thanks for reply,

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

Thanks In Advance

Ashish Sharma

 

 

andykn101's picture

I'm afraid I don't have any scripts but I think there are examples of Custom Inventory scripts in the Custom Inventory section of the Inventory Users Guide and there will be others on here.

But, as I said, first 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?

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

Triinu Gross's picture

The following Connect post provides a lot of custom inventory script examples:

http://www.symantec.com/connect/articles/custom-inventory-solution-7-script-examples

If your issue has been addressed, please use the "Mark as Solution" link for the relevant thread.

Sachin Sawant's picture

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

Andrew Bosch's picture

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).

------------------------------------
Sr. Principal SQA Engineer
Symantec

JimChud's picture

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

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

Sachin Sawant's picture

Hi Jim,

I had run your SQL query but result showing black. i m change data base name also.

 

Please find screen short.

SQL Report.jpg