Client Management Suite

 View Only
Expand all | Collapse all

Active Directory user last login report in altiris

  • 1.  Active Directory user last login report in altiris

    Posted Dec 12, 2012 02:18 AM

    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 ?



  • 2.  RE: Active Directory user last login report in altiris

    Posted Dec 12, 2012 06:23 AM

    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



  • 3.  RE: Active Directory user last login report in altiris

    Posted Dec 12, 2012 06:31 AM

    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.



  • 4.  RE: Active Directory user last login report in altiris

    Posted Dec 12, 2012 07:47 AM

     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.



  • 5.  RE: Active Directory user last login report in altiris

    Posted Dec 13, 2012 12:26 AM

    Hi Andykn,

    Thanks for reply,

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



  • 6.  RE: Active Directory user last login report in altiris

    Posted Dec 13, 2012 04:02 AM

    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?



  • 7.  RE: Active Directory user last login report in altiris

    Posted Jan 02, 2013 01:27 AM
    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


  • 8.  RE: Active Directory user last login report in altiris

    Posted Jan 02, 2013 11:25 PM

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



  • 9.  RE: Active Directory user last login report in altiris

    Broadcom Employee
    Posted Jan 03, 2013 06:49 AM

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

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



  • 10.  RE: Active Directory user last login report in altiris

    Posted Feb 05, 2013 05:43 AM
    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


  • 11.  RE: Active Directory user last login report in altiris

    Posted Apr 08, 2013 02:50 AM
      |   view attached

    Hi Jim,

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

     

    Please find screen short.