This issue needs a solution.

Active Directory user last login report in altiris

Created: 12 Dec 2012 • Updated: 12 Dec 2012
Ashish-Sharma's picture
Login to vote
-1 1 Vote

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 ?

Filed Under

Comments

andykn101
Partner
Accredited
Certified
12
Dec
2012

Altiris does not post back

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
Accredited
12
Dec
2012

Hi, So this is not possible

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
Partner
Accredited
Certified
12
Dec
2012

 What you need to think about

 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
Accredited
12
Dec
2012

Hi Andykn, Thanks for

Hi Andykn,

Thanks for reply,

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

Thanks In Advance

Ashish Sharma

 

 

andykn101
Partner
Accredited
Certified
13
Dec
2012

I'm afraid I don't have any

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
Symantec Employee
Accredited
03
Jan
2013

The following Connect post

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
Partner
Accredited
01
Jan
2013

Hi Ashish, Last loging report

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
Symantec Employee
02
Jan
2013

There is a table, Evt_Logon

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

05
Feb
2013

I personally user this report

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
Partner
Accredited
07
Apr
2013

Hi Jim, I had run your SQL

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