Loading
search-img

JLassen.20160609142050 asked a question.

January 16, 2018 at 8:00 AM
User Logon History (Reporting)?
Have any of you succeeded in perhaps setting up some reporting on user logon history per device? I've been looking around in the SMACC and a device has a logon history, but I have yet to figure out if it's possible to set this up for all devices in one report. I can combine the device name, the login data + the user ID of any given user, but I'm missing the link between the User ID (number) and the actual user/full name. Any suggestions or solutions to this?
  • 2 answers
  • 113 views

  • Community Manager (Flexera Software)

    Hi Jasper,   I’m not sure if this is possible with the inventory custom views. The data however is available in the database and we have the possibility to create custom reports in Snow License Manager.   This select statement on the SnowInventory database should provide you with the requested result.   --Start SQL Select Statement USE SnowInventory select inv . DataLoginUser . ClientId ,               inv . DataLoginUser . Date ,               inv . DataLoginUser . UserId ,               inv . DataLoginUser . UpdateTime ,               inv . DataUserAccount . UserName ,               inv . DataUserAccount . FullName ,               inv . DataClient . HostName        from inv . DataLoginUser        left outer join inv . DataUserAccount on inv . DataLoginUser . UserId = inv . DataUserAccount . UserId        left outer join inv . DataClient on inv . DataLoginUser . ClientId = inv . DataClient . ClientId        order by       inv . DataClient . hostname ASC ,                            inv . DataLoginUser . UpdateTime ASC --End SQL Select Statement   You can use this query to create a custom report in SLM or ask your Snow Software partner or a Snow Software technical consultant to do this for you. Off course you can also use any other BI solution to query the database with this select statement to get the result. Kind regards, Jeroen
    Expand Post

+1.800.374.4353
CONTACT SALES SUPPORT HUB FLEXERA REVENERA
© 2026 Flexera. All rights reserved.
Privacy policy Terms and conditions Revenera Community Help
Loading
User Logon History (Reporting)?