locked
User Logon Inventory RRS feed

  • Question

  • We will be migrating from Altiris to ConfigMgr 2012 this year.  I can't wait!!

    In Altiris, by default, the following logon user data is captured:

    - Domain

    - User

    - Last Logon Time

    - Logon count

    Is there any way SCCM can capture this data? 

    Thanks,

    Mino

    Friday, May 10, 2013 5:01 PM

Answers

  • Sure, here's a sample report:

    SELECT sys1.Netbios_Name0 as [Computer Name],
           s.SystemConsoleUser0 as [System Console User],
           s.LastConsoleUse0 as [Last Console Use],
           s.TotalUserConsoleMinutes0 as [Total User Console Minutes],
           s.NumberOfConsoleLogons0 as [Number of Console Logons]
    FROM   v_GS_SYSTEM_CONSOLE_USER s
           JOIN v_R_System sys1
             ON sys1.ResourceID = s.ResourceID
    WHERE  sys1.Netbios_Name0 = @ComputerName
           AND s.SystemConsoleUser0 NOT LIKE 'Some_strange_service_account_only_your_company_has%'
    ORDER  BY s.TotalUserConsoleMinutes0 DESC,
              s.LastConsoleUse0 DESC,
              s.NumberOfConsoleLogons0

    We do have some strange service account...that's why I have that in there, lol. You may not need it.

    That's a per-computer report, the @ComputerName is meant for a prompt, from SRS.  But you could remove that of course.

    There are two pre-requisites, one is that you have a GPO enabled to Audit Logon Events (I'm guessing you do..otherwise Altiris also couldn't gather this information); and there is a hardware inventory component, for the Console User data gathering--which I think is enabled by default.  Anyway, if you find you have no data; those are the two things to look at as to why you may not have any results.


    Standardize. Simplify. Automate.

    • Proposed as answer by Jörgen NilssonMVP Friday, May 10, 2013 7:11 PM
    • Marked as answer by MinoD Wednesday, May 15, 2013 6:35 PM
    Friday, May 10, 2013 5:31 PM

All replies

  • Sure, here's a sample report:

    SELECT sys1.Netbios_Name0 as [Computer Name],
           s.SystemConsoleUser0 as [System Console User],
           s.LastConsoleUse0 as [Last Console Use],
           s.TotalUserConsoleMinutes0 as [Total User Console Minutes],
           s.NumberOfConsoleLogons0 as [Number of Console Logons]
    FROM   v_GS_SYSTEM_CONSOLE_USER s
           JOIN v_R_System sys1
             ON sys1.ResourceID = s.ResourceID
    WHERE  sys1.Netbios_Name0 = @ComputerName
           AND s.SystemConsoleUser0 NOT LIKE 'Some_strange_service_account_only_your_company_has%'
    ORDER  BY s.TotalUserConsoleMinutes0 DESC,
              s.LastConsoleUse0 DESC,
              s.NumberOfConsoleLogons0

    We do have some strange service account...that's why I have that in there, lol. You may not need it.

    That's a per-computer report, the @ComputerName is meant for a prompt, from SRS.  But you could remove that of course.

    There are two pre-requisites, one is that you have a GPO enabled to Audit Logon Events (I'm guessing you do..otherwise Altiris also couldn't gather this information); and there is a hardware inventory component, for the Console User data gathering--which I think is enabled by default.  Anyway, if you find you have no data; those are the two things to look at as to why you may not have any results.


    Standardize. Simplify. Automate.

    • Proposed as answer by Jörgen NilssonMVP Friday, May 10, 2013 7:11 PM
    • Marked as answer by MinoD Wednesday, May 15, 2013 6:35 PM
    Friday, May 10, 2013 5:31 PM
  • This will work.  Thanks Sherry.
    Wednesday, May 15, 2013 6:35 PM