Client Management Suite

 View Only

  • 1.  unwanted users entry

    Posted Oct 27, 2014 02:20 AM

    A big count of unwanted user is in network, how can i find the user which is not been activate to delete the entry fo those users?



  • 2.  RE: unwanted users entry
    Best Answer

    Posted Oct 27, 2014 02:26 AM

    Check the report

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


  • 3.  RE: unwanted users entry
    Best Answer

    Posted Oct 28, 2014 07:48 AM

    Report of primary user last login

    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