Skip to Main Content
Liongard Library

Welcome to Liongard Library, where Lions share! This is a community-led space where Liongard users can come to teach and learn from one another.
Share custom Metrics, get inspired and see what’s trending in the Pride.

Pride Etiquette:
➕ Have great custom Metrics? Add them as entries!
🌟 Want to use a Metric? Copy the query and
follow this doc.
👍 Tried a Metric from the Library? Like it!
📣 Have a question or feedback on a Metric? Add a comment!
🔎 Not sure where to start? Learn about Metrics and how to write them.
💬 Need help writing a metric or want to help support others? Join the conversation in our Liongard Lounge #metrics slack channel.


🥴 See something off? Open a support chat to let us know.

Categories Active Directory
Created by _ _
Created on Jan 13, 2022

Active Directory: Last Login with Timestamp

This will return us the last logon for the AD user.

Query

Users[].join( ` `, [join(` `, [` AD LOGIN: `, to_string(UserName)]), join(` `, [`. Name of User: `, to_string(Name)]),join(` `, [`: `, to_string(LastLogonDate)])])

  • Attach files
  • Matt Scutt
    Reply
    |
    Mar 1, 2023

    Thanks!


    For anyone wondering, the following will return the same as the above, but only for enabled users:


    Users[? Enabled == `true`].join( ` `, [join(` `, [` AD LOGIN: `, to_string(UserName)]), join(` `, [`. Name of User: `, to_string(Name)]),join(` `, [`: `, to_string(LastLogonDate)])])